We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas, Nevada. Can you feel the excitement building? The SQLSat 295 team has been working hard […]
Category: News
New Backup Behavior in SQL 2014
As has been well publicized, today is the official Release To Manufacturing date for SQL Server 2014. You can read more about all of that here. Something that hasn’t received much word is a new […]
Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to the script here. This time we have a bit of a bug update. The details […]
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17 people step up and place remarkable […]
Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear […]
Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All of them would have been really good examples. The problem has not been the quality […]
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about […]
T-SQL Tuesday #051: Place Your Bets
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL Tuesday. This also marks what should […]
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the repository, I realized there was some […]
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part to me rushing around trying to […]