June 28, 2012 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 2012With 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
Posted by: Denny Cherry
CLR,
SQL CLR Procedure,
SQL Server,
SQL Server 2012A 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
Posted by: Denny Cherry
CLR,
SQL CLR Procedure,
SQL Server,
SQL Server 2012When 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
Posted by: Denny Cherry
Performance Problems,
SQL Server,
SQL Server 2012,
VMware,
VMworldFor 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
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 LaRockSo 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
Posted by: Denny Cherry
Book,
Robert Cain,
SQL Server,
SQL Server 2012One 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
Posted by: Denny Cherry
Amazon,
Database security,
Securing SQL Server,
SQL Injection,
SQL Server,
SQL Server 2012In 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
Posted by: Denny Cherry
SQL Server,
SQL Server 2012,
Windows 2008 R2Microsoft 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
Posted by: Denny Cherry
SQL Server,
SQL Server 2012When 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...
