Category Archives: DBA

How SQL Server Can Make Things More Secure … Use Encryption!

One of the hottest topics in the technology world is security.  This topic is important because there are few things that can hurt a company more than stolen or misused data.  So, it is easy to see why security should … Continue reading

Posted in DBA, Security | Tagged , | 1 Comment

Database Snapshots

Last week, I took a Caribbean cruise as a much needed family vacation.  It was very enjoyable!  We took a lot of pictures or we could say snapshots, which help us to remember those “good” times.  Then, I came back … Continue reading

Posted in DBA | Tagged , | Leave a comment

Distributed Transaction Coordinator (DTC) in a SQL Failover Cluster

At my company, we have recently refreshed some of our physical hardware for our SQL failover clusters.  During our building of these new servers (Windows 2012 R2 and SQL Server 2012), we decided to change the setup of the distributed … Continue reading

Posted in DBA | Tagged , , | Leave a comment

SQL PASS 2014

As I have mentioned in the past, the PASS Summit is probably one of the most beneficial events in the SQL Server community for a database professional.  This year’s event took place in Seattle, Washington from November 3-7, 2014.  I … Continue reading

Posted in DBA, Professional Networking, Training | Tagged , | Leave a comment

Exploding Data Sizes … Better Try Data Compression

It is estimated that the amount of data in the digital universe is doubling every two years. By 2020, the amount of data is estimated to reach 44 zettabytes, or 44 trillion gigabytes (http://www.emc.com/leadership/digital-universe/2014iview/executive-summary.htm). Of course, not all of this … Continue reading

Posted in DBA | Tagged , | Leave a comment

What is the Status of the Backups?

In one of my very first posts (https://sqlbadboy.wordpress.com/2012/09/25/what-should-i-be-doing-as-a-dba/), I indicated that one of the DBA’s primary responsibilities is to protect their company’s data by implementing a backup strategy.  And because everyone knows this is part of a DBA’s job, the … Continue reading

Posted in DBA | Tagged , , , | 1 Comment

SQL Server Installations … Is there an “Easy” Button?

In previous posts, I have discussed the benefits of giving attention to how you install your SQL Server (https://sqlbadboy.wordpress.com/2012/11/06/preparation-and-setup-leads-to-good-results/) and the need to automate things when you are doing them again and again (https://sqlbadboy.wordpress.com/2013/02/25/can-you-do-it-again-and-again-ok-lets-automate-it/). So, if we put the principles … Continue reading

Posted in DBA | Tagged , , | Leave a comment

What is SQL Server Waiting On?

Waiting is one of the hardest things for many people to do.  For example, imagine that you are on your way to work in a car and you come upon a traffic jam.  Your once short commute is now taking … Continue reading

Posted in DBA | Tagged , , | Leave a comment

Keeping up with SQL Server Versions

Have you ever heard the expression, “Keeping up with the Joneses”?  If not, it basically refers to comparing yourself to your neighbor in a social and economic way so as not to appear inferior.  However, depending on whom you ask, … Continue reading

Posted in DBA | Tagged | Leave a comment

Full-Text Search – A Beginner’s Guide

In my experience, many DBA’s and developers seem to shy away from Full-Text Search (http://technet.microsoft.com/en-us/library/ms142571.aspx).  But, it is not as complicated as you may think.  In this post, I am going to attempt to make it as easy as possible … Continue reading

Posted in DBA, Developer, TSQL | Tagged | Leave a comment