SQL Server

By August 18, 2015 1 Comments Read More →

Studying for the 70-462 Exam: Database Mirroring

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the short guy in the back, standing on his tippy toes trying to make sure everyone remembers he was there.  Despite this, and the fact that it’s been marked as a deprecated feature, Microsoft still feels it’s necessary to […]

By August 11, 2015 12 Comments Read More →

10 Signs You’re Enjoying Your DBA Career Too Much

Most database professional recognize they have a good career path, and mostly enjoy the work they do.  It’s possible to cross the line of enjoying it a little too much though.  Here’s some guidelines to asses your situation: 1.  Instead of being excited for the weekend, you’re anxious for Monday to get here to see the stats […]

Posted in: SQL Server, Syndication
Credentials and Proxies: Getting Started
By August 4, 2015 1 Comments Read More →

Credentials and Proxies: Getting Started

If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a login is.  However, did you know that you can access resources outside of SQL Server without granting the login permissions everywhere, and also run job steps under accounts that don’t have SQL Server access?  Say […]

SQL Server Audit: Getting Started
By July 28, 2015 1 Comments Read More →

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route).   SQL Server Audit is easy to set up, and requires […]

By May 25, 2015 0 Comments Read More →

4 Things You’ll Need Before Installing a Failover Cluster Instance

Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and creating the cluster itself, so you’re good to go to start installing SQL Server right?  Not quite – you still need a few other things and unless you’re a in a jack-of-all-trades role, you may […]

Posted in: SQL Server, Syndication
By May 19, 2015 0 Comments Read More →

The Case for Optimize for Ad Hoc Workloads

I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server configuration setting.  My initial thought was to leave it disabled, since this is the default after all, and we didn’t have a specific situation where it was believed enabling this would have helped.  I admittedly did not know […]