General

Lone DBA, Lemming or Master of your Domain

Lone DBA, Lemming or Master of your Domain

Are you a lone lemming or the master of your domain? Many organizations hire only one database administrator. This lone DBA is in a unique position which can be both rewarding and challenging. I have spent years as a lone…

Ding Level 3 in My Epic Life Quest

Ding Level 3 in My Epic Life Quest

Wahooo! Today is a day to celebrate. I just realized that I have achieved level 3 in my Epic Life Quest. Stay tuned as I work my way to level 4. I plan to include being a Microsoft Certified Solutions…

Do we care about development environment performance?

Do we care about development environment performance?

Recently, but not for the first time, I was confronted with a server administrator that didn’t want to allocate more than one vCPU to a SQL Server machine in a development environment. His exact words ring over and over in my…

Discovering Symantec NetBackup

Discovering Symantec NetBackup

I have worked with a large organization (150,000+ employees). This organization has a central location and hundreds of subordinate sites. Headquarters (HQ) has dictated that the Symantec NetBackup MS SQL Client will be used for all SQL Server backups. Each site has…

Trace flags every DBA should know about

I have compiled a list of trace flags which I recommend enabling by default on all of you SQL Server instances and ones which are simply, useful. Check out the page and bookmark it for reference as I will be…

Do not use percentage based auto-growth

Do not use percentage based auto-growth

Having autogrowth enabled on your SQL Server instance is great! Even in IT shops where you diligently right-size your database files (which is a good idea), autogrowth is the perfect emergency feature. It will increase the size of your files, as needed, until…

Synchronizing Server Objects for Availability Groups

Synchronizing Server Objects for Availability Groups

After we create a strategy for synchronizing our data for disaster recovery, we then need to consider keeping our server objects synchronized. Depending upon which objects you are working with there are various solutions available to you. xp_help_revlogin (2005 and…

It is who you know, or is it?

It is who you know, or is it?

I have spent a lot of time learning about how to effectively network and the benefits that it can bring to my life and career. What I find interesting, however, is that there is a negative connotation revolving around the good ol’…

Writing Repeatable T-SQL

Writing Repeatable T-SQL

Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not mean that the languages, such as T-SQL, are more difficult or that applications are any less…