The Primary Filegroup Cannot be Backed Up as a File Backup

File Group backups are great when working with very large databases (VLDB’s) that have been partitioned.  Typically when I come...

We Are Hiring!

My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's.  As you have probably seen...

Calendar Tables in T-SQL

In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...

SQL Server 2014 RTM

The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...

Houston SQL Saturday #308 – Presenting

Saturday May 10th – Houston SQL Saturday #308
I will be presenting at the upcoming SQL Saturday in Houston on May10th.  For...

South Alabama Day of .NET Presentations Downloads

I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...

T4 Support in SSDT

Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me.  On tuesday night,...

All in Fun

My first commercial!
Steve on a HorseThis comes from our DBA Team promotion, which is ongoing this year.

Filed under: Blog Tagged:...

Backup Checksums and Trace Flag 3023

One of the items I always flag when performing a health check on a server is whether backups are being...

Building the SQLSaturday Orlando Marketing Plan–Part 1

I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the...