Skip to Content

andrew kelly (46 Posts)


Free E-Books From Microsoft Again

Posted July 11, 2017

By ,

In books, Documentation, SQL Server, Windows

  The Director of Sales Excellence at Microsoft is once again giving away free E-Book downloads.  Apparently millions of them in fact on all sorts of... more »

Getting Excited about my Practical Performance Monitoring Pre-Con

  I was working on the demo’s for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I... more »

Finding When Someone Last Ran a DBCC

Posted June 28, 2017

By ,

In Administration, DBCC, Tips & Tricks, TSQL

  The other day someone on Twitter asked how to find out when or who last ran a DBCC FREEPROCCACHE command on their SQL Server instance. Since this is not... more »

Seldom Used Keyboard Tricks

Posted June 22, 2017

By ,

In SQL Server, SSMS, Tips & Tricks, Uncategorized

  I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver... more »

SQL Updates Newsletter–May 2017

  I missed posting the last few months of these but here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina... more »

New Cumulative Updates for SQL Server 2014

  Microsoft announced two new CU’s for SQL Server 2014 yesterday. Below are the links to the KB’s and some quick facts for each CU. Cumulative Update... more »

Latest SQL Server 2014 CU Updates

  Microsoft released a few more Cumulative Updates for SQL Server 2014 as listed below. There are a number of interesting fixes so I highly recommend if... more »

Stopping Execution of Future Batches

  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 »

SQL Updates Newsletter – January 2017

  Here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which... more »

Latest SSMS Download (16.5.3)

Posted January 27, 2017

By ,

In Administration, SQL Server, SSMS, Updates

  There was a slight issue with the SSMS version that was released a few days back (16.5.2) which has been fixed and replaced with release 16.5.3. If you... more »