It seems that, of the DBAs who use FILESTREAM, it is common to ask, “why do I have more file system objects then I have rows with BLOB columns?” This question inevitably bring us to the topic of the garbage…
Today, Microsoft announced that SQL Server 2014 RTM will be generally available on April 1st, 2014. In addition to this wonderful piece of information; Quentin Clark (Corporate Vice President, Data Platform Group), Microsoft CEO Satya Nadella, and COO Kevin Turner…
Yesterday (Friday, March 14th, 2014) Richmond, VA’s SQL Server user group was fortunate enough to have Brent Ozar ( @BrentO | BrentOzar.com) stopped by and present a 101 level session on SQL Server Internals. I made the 4 hour round…
From blogs.msdb.com: Dear Customers, The 11th cumulative update release for SQL Server 2008 R2 SP2 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the SQL Server 2008 R2 SP2 hotfixes which have been available since the initial release of…
“You only need one thing; a backup or a résumé. Never both.” This quote certainly summarizes a very important piece of being a DBA. You must be able to recover from a disaster. There are many ways to offer redundancy…
For those SQL Prompt users, like myself, I’m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query window and the table suggestions don’t immediately populate. This can be annoying if you were looking…
I manage a moderately complicated topology that includes one-way transactional replication with push subscriptions to and from several database instances. Due to my day-to-day tasks I know this topology pretty well and often I simply know what my publications are,…
A globally unique identifier (GUID) is a great way to identify a record in your database. It can be easily created at the database or application layer and, when generated, is guaranteed to be unique regardless of other records already…
The SQL Server alert system does a great job of handling notifications for SQL Agent job failures but if want to know if a job is hung, taking longer than expected, or maybe it’s disabled and hasn’t been running, we…
Infographic: “Your Backups – Restored from the Dead” To be a database administrator is to accept a life of stress and paranoia. We are charged with the responsibly of protecting one of a business’s most valuable resources, its data. We…