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...

Adding a PowerShell Job Step to an existing SQL Agent Job Step with PowerShell

In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...

Monday Coffee 2017-03-13

Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for...

TSQL2sday – Daily database WTF

This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...

VS Code PowerShell Snippets

Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...

Next Stop, SQL Saturday Richmond

I can’t believe it’s almost time for SQL Saturday #610.  I’ll be there presenting What is Power BI?  If you...