-
Transactions: Rolling back a nested transaction
5December 17, 2013 by Kenneth Fisher
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). …
Continue reading -
T-SQL Tuesday #49: Wait for it
3December 10, 2013 by Kenneth Fisher
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. …
Continue reading -
Undocumented functionality in FORMATMESSAGE
2December 9, 2013 by Kenneth Fisher
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which …
Continue reading -
Insert into a table using only default values
4December 4, 2013 by Kenneth Fisher
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value …
Continue reading -
Why do DBAs like to say “It Depends” so much?
1December 2, 2013 by Kenneth Fisher
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice …
Continue reading -
Finding active DTS packages
9November 27, 2013 by Kenneth Fisher
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
Continue reading -
Finding the metadata for a query
2November 25, 2013 by Kenneth Fisher
You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
Continue reading -
A pattern to do beginning of period calculations.
Leave a commentNovember 20, 2013 by Kenneth Fisher
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
Continue reading -
Connection options in SSMS
2November 18, 2013 by Kenneth Fisher
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know …
Continue reading -
Who’s on call
6November 13, 2013 by Kenneth Fisher
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 