SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk

I had a lot of fun yesterday presenting my talk on how to go from not having your database in...

Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

How do you choose a source control system for your SQL Server database

If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.
If you...

SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk

I had a lot of fun yesterday presenting my talk on how to go from not having your database in version control to deploying to a CI database, running...

Thank You Community

All I can say is, “Wow…Thank you!”.  I won a seat on the PASS Board of Directors and it’s very...

Deployed Target Metadata with PoSH

This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Related Posts:

PowerShell to Backup XE Session...

Deployed Target Metadata with PoSH

Having just covered the methods to discover the metadata for a deployed session including the details about the session settings,...

Untrusted Check Constraints

Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can...

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem...

SQL Server Contracting - The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...