Skip to Content

Developer Posts

Stopping Execution of Future Batches

Posted February 17, 2017

By

  There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are... more »
11

Source Control for SSMS

Posted November 25, 2016

By

  It would be awesome if we could use source control such as TFS directly in SSMS like we can in Visual Studio but at the moment we can’t for the... more »
0

SQLSentry does it Again – Plan Explorer is Completely Free

Posted September 08, 2016

By

  Many of us have used the free version of Plan Explorer from SQLSentry for a long time to help tune and explore query plans in a way that SSMS can only... more »
3

My Best Blog Posts from 2015

Posted January 29, 2016

By

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make... more »
0

Free or Useful Windows and Developer Resources

Posted August 13, 2015

By

 I was just made aware of a bunch of resources that you may find very useful. I especially liked the Windows 10 jumpstart videos but there are a lot of... more »
0

Microsoft //Build and Office365 Events Coming to a Chicago, LA, Charlotte, Indianapolis, and Jacksonville

Posted June 04, 2015

By

The //build Tour If you build software using Visual Studio or code against the Microsoft stack, you don’t want to miss the //build traveling... more »
0

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance

Posted March 30, 2015

By

Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that... more »
0

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance

Posted March 23, 2015

By

Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice! Optimization Phases and Missed Opportunities and... more »
0

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

Posted March 16, 2015

By

Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are... more »
0

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

Posted February 27, 2015

By

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube.  One... more »
4