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 … Read more
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 … Read more
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 … Read more
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 … Read more
I was going through some old files recently and I came across a folder that was essentially a junk drawer of scripts I’ve put together over the years. I don’t know what to do with most of them now. For example, the isql scripts for some Sybase ASE 11.5 instances aren’t very helpful for many these … Read more
Snapshots and checkpoints are fine tools for you to use, but when you are done with them you should get rid of them, especially for a database server.
