SQL Server with Mr. Denny:

SQL Server


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


June 4, 2012  3:55 PM

Storage and Virtualization Class Starting Tomorrow



Posted by: Denny Cherry
SQL Server, SSWUG, Storage, vConference

SSWUG.ORG's virtual class will provide database administrators (DBAs) with the skills to properly design storage and virtualization solutions. Denny Cherry, course instructor and SQL Server MVP and Microsoft Certified Master,...


June 4, 2012  2:00 PM

VMware vCenter Performance Tuning



Posted by: Denny Cherry
Index Performance, Nonclustered Index, SQL Server, vCenter, VMware

As hopefully everyone that is using VMware's vSphere in either data center knows VMware's vCenter runs off of a Microsoft SQL Server database (by default).  Now as good as they guys at VMware are at building a virtualization platform there database leave a little to be desired.  I've identified a...


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 28, 2012  2:00 PM

Know your app when migrating your data



Posted by: Denny Cherry
Migration, Network Traffic, SQL Server

One of the projects that I'm working on at the moment is moving a data center from being hosted in Dallas Texas up to New Jersey so that it's closer to the companies corporate office in New York City.  As a part of this data center migration the Microsoft SQL Server databases must be moved to the...


May 28, 2012  2:00 PM

Figuring out how log shipping is doing



Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...


May 22, 2012  9:00 AM

Still time to sign up for SQLDay 2012 pre-con



Posted by: Denny Cherry
SQL Server, Storage, Virtualization

There is still plenty of time to get signed up for my SQLDay 2012 all day session in Poland this week on Thursday the 24th of May. Below you'll find a description of the session which I'll be teaching.

This session will be a two part session in...


May 21, 2012  2:00 PM

What to do when your Twitter account gets hacked



Posted by: Denny Cherry
Social Commentary, SQL Server, Twitter

On occasion Twitter accounts get hacked and are used to send out spam to other twitter followers, usually via Direct Message. When your twitter account is taken over there are two different things that you need to do in order to get your account back under your control. The first is pretty...


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


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: