By August 26, 2015 0 Comments Read More →

Agile Development – A DBA’s Initial Thoughts

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally involve a large release at the very end of a project.  If you’ve heard terms like daily scrum, product […]

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 0 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