Recommended reading from mrdenny for July 24, 2015

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Optimize Heap Memory Settings for Analysis Services Tabular 2012/2014 #ssas #tabular Nutanix and Acropolis: Should VMware Be Worried? June 30th Leap Second Could Trigger Unexpected Issues Tech Talk 27: The hypervisor no…

Read more

Updating All Jobs To Check For AG Primary Replica

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each server, then modify the jobs on each server to check and see…

Read more


If You Thought Database Restores Were Slow, Try Restoring From an EMC Data Domain

Recently I did something which I haven’t had to do for a VERY long time, restore a database off of an EMC Data Domain. Thankfully I wasn’t restoring a failed production system, I was restoring to a replacement production system, so I was getting log shipping setup. I’ve worked in plenty of shops with Data…

Read more

Recommended reading from mrdenny for July 17, 2015

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Optimize Heap Memory Settings for Analysis Services Tabular 2012/2014 #ssas #tabular SQL Server 2016 : In-Memory OLTP Enhancements June 30th Leap Second Could Trigger Unexpected Issues Take A Bold Data Mining Algorithms…

Read more


Idera Geek Sync—Dealing with Bad Roommates SQL Server Resource Governor

Next Monday at 1000 CDT/1100 EDT/1500 GMT I will be doing a webinar with Idera on SQL Server Resource Governor. In my time as a SQL Server DBA, it’s rare especially in small to medium size companies to have only one applications databases running on a given SQL Server. SQL Server licensing is expensive—frequently far […]

Read more

Be Careful When Starting Up Azure VMs Running SQL Server

So Microsoft has done something pretty dumb with the Azure VMs which are running Microsoft SQL Server. By default the front end firewall (the one that allows or blocks traffic from the public Internet to the VMs) allows traffic to the default SQL Server port 1433. At first this is fine, until you change the…

Read more


Recommended reading from mrdenny for June 26, 2015

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Time to Start Plotting My 2016 Database Design Book Latest MVA Offerings for SQL Server and for Windows 10 (Yes it’s time to start looking at this) DBAs and the Internet of…

Read more