Use SCOPE_IDENTITY()–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Assembling a Session

With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:

Short...

Assembling a Session

Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...

Excel as a Database Professional

People ask me all the time how to become a DBA.  This is a topic that so many colleagues of
mine...

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...

Database Mirroring Isn’t Going Anywhere

AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in...

Dynamic SQL & Quotename

Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...

Deployment Contributor KeepTableColumns Filter

To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know...