Archive | DBA

SSDT VS 2012 – Bringing an existing database under source control

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesAlright! You are the […]

Error when trying to use DAC connection in SQL Server

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesSo, one of my […]

SQL Job Steps And Run_Duration: The query that formats run_duration correctly and doesn’t make you want to shoot your eye out

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesEver tried to figure […]

SQL Query: List All Indexes And Their Columns

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesLooking to write a […]

Escaping From An Underscore In A SQL Server Wildcard / LIKE Search

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesThere are two different […]

Parse and sort SET STATISTICS IO output with Excel

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesI wish I could […]