DBA Archives - Page 2 of 21 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB)

May 17, 2012

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Documentation, SQL Download, SQL White Papers

Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of upgrade in-depth. This is indeed a helpful detailed white paper. Even writing a summary of this white paper would take over 100 pages. This further proves that SQL Server 2012 is…

SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool

October 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, DBA

New in the expressor Studio 3.4 release is the rules editor. This graphical coding tool replaces the transform editor of earlier versions. The rules editor works in concert with the newly introduced attribute propagation functionality to minimize the amount of data mapping and coding you need to provide. The expressor…

SQLAuthority News – Community Tech Days – TechEd on The Road – Ahmedabad – June 11, 2011

June 3, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, MVP, SQL Wait Stats

TechEd on Road is back! In Ahmedabad June 11, 2011! Inviting all Professional Developers, Project Managers, Architects, IT Managers, IT Administrators and Implementers of Ahmedabad to be a part of Tech•Ed on the Road, on 11th June, 2011. We have put together the best sessions from Tech•Ed India 2011 for…

SQL SERVER – DBA or DBD? – Database Administrator or Database Developer

November 29, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

Earlier this month, I had poll on this blog where I asked question – Are you a Database Administrator or Database Developer? The word DBA (Database Administrator) is very common but DBD (Database Developer) is not common at all. This made me think – what is the ratio of the…

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server

August 12, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

DBA, SQL Scripts

I was recently called to attend the Query Tuning Project. I had a very interesting experience in this event. I would like to share to you what actually happened. Note: If you are just going to say that shrinking database is bad, I agree with you and that is the…

SQL Tips – 5 SQL Server Best Practices

July 30, 2010

Pinal Dave

SQL Tips and Tricks

Best Practices, Database, DBA, SQL Server

In this blog post we will see 5 SQL Server Best Practices.

Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now.

SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010

July 28, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

DBA, MVP, Spatial Database, SQL Joins, SQLAuthority Author Visit

Earlier this month, I got the opportunity to visit Malaysia for community sessions on June 29 – July 1, 2010 at Kuala Lumpur, Malaysia, which I would consider as valuable experience. I presented two different sessions at the event. The event was extremely popular in local community, and I had…