Just a quick post for some Friday fun. If you want to know how to do database mirroring right, start with this MSDN link: http://msdn.microsoft.com/en-us/library/ms189852.aspx And if you are thinking of buying yourself a nice book on Christmas on database mirroring, I’d recommend this one: Pro SQL Server 2008 Mirroring
SQL Server Performance
The Five DBA Food Groups
Tomorrow is Thanksgiving here in the USA. It’s a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force retail workers to work longer hours in the name of(…)
The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)
Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL Server 2014. You might recall that earlier(…)
HOW TO: Find Currently Running Long SQL Agent Jobs
A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you want the opportunity(…)
Q&A From My Azure Webinar With Scott Klein
Recently (OK, on July 23rd, 2014 to be exact) I co-presented a webinar with Scott Klein (blog | @SQLScott) titled “Know Before You Go: SQL Server on Microsoft Azure Virtual Machines“. It was a repeat performance of the session we delivered at TechEd in Houston earlier this year. There were a handful of questions asked during(…)
HOW TO: Know What That Installer Did to Your Database
Remember when I told you I had come across and old script that checked your SQL Server configuration setting? Well, here’s another old script of mine I think is worth sharing. The idea was that I wanted to verify what changes (if any) were made to my SQL Server instance as a result of a 3rd party vendor(…)