Extreme situations require extreme commands

The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...

A Collection of SQL Server Help Scripts

[read this post on Mr. Fox SQL blog] Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have...

A Collection of SQL Server Help Scripts

[read this post on Mr. Fox SQL blog]
Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked...

Using tSQLt to Find Min/Max Times

I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since...

Using Virtual Desktops for Presentations

Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...

Why You Should Change the Cost Threshold for Parallelism

I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...

2016/2017 Whitepaper Updates

One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...

T-SQL Programming for Developers Course

Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?

...

SQL Server Query Store

Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...

Cumulative Update #11 for SQL Server 2014 SP1

The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...