Performance Tuning a Spotlight for SQL Server Query
The other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the system where coming from Spotlight for SQL Server. The query in question is used by spotlight to figure out when the most recent full, differential and log database backups […]
A week of using my Surfii (when you have more than one Microsoft Surface)
So while at the TechEd North America conference Microsoft gave the attendees, speakers and booth staff the ability to purchase some Microsoft Surfii (surf-I) at some major discounts. The Surface RT was available for $99 US and the Surface Pro was just $399 US. Needless to say I purchased both of them. I’ve been using […]
Read Only Routing Configuration UI
One of the big downsides to using the SQL Server 2012’s AlwaysOn Availability Group feature is that there is no UI to help you configure read only routing. Thankfully there is a fix for this. Denny Cherry & Associates Consulting is happy to announce the first of or AlwaysOn Tools which is the Read Only […]
SQL Server 2014 Standard Edition High Availability
With all the announcements about SQL Server 2014 this last week there have been a lot of questions about what’s going to happen for SQL Server 2014 and the non-shared storage High Availability options as we are now one step closer to database mirroring being removed from the product. You’ll see several blog posts coming […]