SQL Server with Mr. Denny:

SQL Server


May 7, 2012  2:00 PM

SQL PASS 2012 First Timers Webcast



Posted by: Denny Cherry
SQL PASS, SQL Server

As the SQL PASS 2012 Summit is quickly approaching I'm announcing, well in advance, that I'll be doing a another First Timers webcast.  The web cast won't be for a while, but I wanted to start getting the word out there now.  I'll be giving a repeat of my very popular webcast from last year on...

May 1, 2012  2:00 PM

Here is May, the month of Travel



Posted by: Denny Cherry
SQL Excursions, SQL PASS, SQL Server

So it appears that May is going to be one of the busier travel months for me this year (at least so far).  With three important week long events scheduled for this month it's going to be a hell of a month. First is SQL Rally where I'm in Dallas Texas from May 7th-12th (I've got a pre-con on the...


April 30, 2012  2:00 PM

New SQL Server 2012 Book Published



Posted by: Denny Cherry
Book, Robert Cain, SQL Server, SQL Server 2012

One of the many projects which I had the pleasure of working on during the second half of 2011 and the first quarter of 2012 was Wrox's


April 26, 2012  2:00 PM

Securing SQL Server 2nd Edition Coming Soon



Posted by: Denny Cherry
Amazon, Database security, Securing SQL Server, SQL Injection, SQL Server, SQL Server 2012

In case you missed my announcement earlier this week over on SecuringSQLServer.com... I'm pleased to be able to announce that the


April 23, 2012  5:25 PM

What’s wrong with the University of Florida?



Posted by: Denny Cherry
Budget, Computer Science, Social Commentary, SQL Server, STEM, University of Florida

This past week the University of Florida decided that they no longer need to teach their customers (let’s be realistic with decisions...


April 23, 2012  2:00 PM

Windows Hot Fix makes SQL 2012 AG’s fail over faster



Posted by: Denny Cherry
SQL Server, SQL Server 2012, Windows 2008 R2

Microsoft has recently released hot fix 388724 under MS KB 2687741 which resolves a performance issue when failing over a SQL Server 2012 Availability Group from one replica to another. The basic jist of the problem is that there was an...


April 19, 2012  2:00 PM

AlwaysOn and your application source code



Posted by: Denny Cherry
Connection Issues, SQL Server

One of the things that people will need to change to their applications when using AlwaysOn under SQL Server 2012 will be that the applications will need to have retry logic added to the application so that if the SQL Server is down that the application can retry the connection. Now this...


April 18, 2012  8:30 AM

Storage and Virtualization in Poland May 24



Posted by: Denny Cherry
In Person Events, SQL Server

Come and join me in Poland, May 24th, 2012 (24-05-2012) at SQL Day 2012.  During this day long session we will be looking at storage and virtualization from a...


April 16, 2012  2:00 PM

SQL Saturday 111 Slide Decks



Posted by: Denny Cherry
In Person Events, SQL Saturday, SQL Server

I've uploaded my slide decks from SQL Saturday 111. The sessions can be found on the session pages for the two sessions. I gave two sessions at SQL Saturday 111 in Atlanta, GA. The first was


April 12, 2012  2:00 PM

CPU Affinity Mask and virtualizating SQL Servers



Posted by: Denny Cherry
Error Message, Grant Fritchey, Hyper-V, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

If you have physical SQL Servers that you plan on moving into a virtual environment you'll want to double check your affinity mask settings before actually moving the machine from a physical server to a VM when using P2V software.  The reason for this is that if the affinity mask is set for...