Query Hash Values, Plan Guides and the Query Store

I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does...

SSMS Tips: Copy Full Path

When you right click on a tab you’ll see a number of different options. You can set up new horizontal...

Vnext – Its SQL Server 2017

Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can...

The Birthday Problem – with T-SQL and R

When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...

Setting the default file type for a new file in VS Code

Just a short post today. When you open a new file in VS Code (Using CTRL + N) it opens by...

Always Encrypted

By David Postlethwaite

Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database....

Monday Coffee 2017-04-24

Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well...

Monday Coffee 2017-04-24

Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well...

Moving Azure resources between subscriptions – especially VSTS Team Services Account

For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...

I Escaped from a SQL Server Service Pack Nightmare

I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade,  if...