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
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 […]

By May 12, 2015 0 Comments Read More →

Taking (and passing!) the 70-461 Exam and Pursuing My MCSE Certification

Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam.  I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months.  Taking this exam was step one, and now I have four remaining.  Rather than spending a bunch of money on studying materials, I opted to self […]

Better Together: Reduced Run Time and I/O
By April 29, 2015 0 Comments Read More →

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one management cares about.  When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment, consisting of different server architecture and storage speed than production. If you’re […]

By March 24, 2015 0 Comments Read More →

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!).  There is no getting around it – blogging is time consuming.  Especially technical blogging.  My first few posts were fairly long, […]

Posted in: Syndication, Writing