Skip to Content

Tips & Tricks Posts

Finding When Someone Last Ran a DBCC

Posted June 28, 2017

By

  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 »
0

How to calculate barcode check-digit using T-SQL language

Posted June 23, 2017

By

Introduction In order to scale, it’s imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to... more »
0

Seldom Used Keyboard Tricks

Posted June 22, 2017

By

  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 »
0

SQL Updates and More

Posted October 31, 2016

By

  A good friend of mine (Fany Carolina Vargas) from Microsoft puts together a fantastic blog post each month which shows a whole host of goodies related... more »
0

SQL Updates and More

Posted October 31, 2016

By

  A good friend of mine (Fany Carolina Vargas) from Microsoft puts together a fantastic blog post each month which shows a whole host of goodies related... more »
0

SQL Updates and More

Posted October 31, 2016

By

  A good friend of mine (Fany Carolina Vargas) from Microsoft puts together a fantastic blog post each month which shows a whole host of goodies related... more »
0

The biggest table in your database

Posted February 11, 2016

By

You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is... 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

SQL Server DML Triggers – Tips & Tricks – Part 4 (“Statements that each Trigger should have”)

Posted May 01, 2015

By

This is the fourth blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The previous parts can be found here: SQL Server DML... more »
0

SQL Server DML Triggers – Tips & Tricks – Part 3 (“Trigger debug”)

Posted March 21, 2015

By

This is the third blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first and the second parts can be found here:... more »
0