SQL Server with Mr. Denny:

SQL Server 2012

1

July 12, 2012  2:00 PM

PBM, Replication and Stored Procedure Names



Posted by: Denny Cherry
Replication, SQL Server, SQL Server 2008 R2, SQL Server 2012, System Objects

One of the things that Policy Based management is really good at is making sure that people don't create stored procedures that start with "sp_".  However when the server that you are deploying the policies to is also being used for SQL Server replication this can get a little more complex seeing...

June 28, 2012  2:00 PM

What do I do with Standard Edition SQL Servers using Mirroring



Posted by: Denny Cherry
SQL Server, SQL Server 2012

With the release of SQL Server 2012 many of the people who are using Standard Edition and Database Mirroring are quite nervous about what their HA options are going to be moving forward, and rightfully so as Microsoft has been pretty silent on this specific topic.  Let me see if I can't calm your...


June 14, 2012  9:00 PM

When does SQLCLR launch?



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

A change was made to the SQLCLR, as to when the SQLCLR is loaded.  In SQL Server 2008 R2 and below the SQLCLR component was loaded only when the “clr enabled” setting, which is controlled through sp_configure, is enabled.  Even with the SQLCLR is enabled on SQL Server 2008 R2 and...


June 11, 2012  9:00 PM

SQL Server 2012, SQLCLR and Max Server Memory



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

When SQLCLR was first introduced in SQL Server 2005, one of the big complaints that I had with it was that SQLCLR could technically steal all the memory away from the SQL Server’s buffer pool by simply growing it’s memory pool which would cause the OS to request memory back from the SQL...


May 30, 2012  2:00 PM

Time to vote for vmworld 2012 sessions



Posted by: Denny Cherry
Performance Problems, SQL Server, SQL Server 2012, VMware, VMworld

For those that are interested in the VMware product line and the VMworld conference, it is time to begin the community voting for sessions that will be given at VM World 2012 in both San Francisco, CA USA and Barcelona, Spain. You'll need to register...


May 16, 2012  9:16 PM

Time to Register for TechEd pre-cons



Posted by: Denny Cherry
Performance, Pre-Con, SQL Server, SQL Server 2008 R2, SQL Server 2012, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America, Tom LaRock

So Microsoft TechEd is quickly approaching. If you wanted to sign up for a pre-con there is still time, and plenty of space left available at both the North America and Europe TechEd pre-cons. These pre-cons are full day long sessions, being presented in this case by Tom LaRock and...


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  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...


March 12, 2012  2:00 PM

AlwaysOn and Error 41006 (and error 41158)



Posted by: Denny Cherry
SQL Server, SQL Server 2012

When setting up AlwaysOn Availability Groups you may receive Error 41158 which references error 41006 when you attempt to join the the replica to the Availability Group.  What these errors in a nut shell mean is that it ain't going to work with your current configuration. Assuming that you ran...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: