SQL Server with Mr. Denny:

June, 2012

1

June 28, 2012  2:00 PM

What do I do with Standard Edition SQL Servers using Mirroring

Denny Cherry Denny Cherry Profile: Denny Cherry

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

Moving huge amounts of data between data centers

Denny Cherry Denny Cherry Profile: Denny Cherry

Every once and a while I get the fun project of moving a data center from one location to another, often from a Managed Service Provider to either a CoLo facility or to another Managed Service Provider.  When I'm doing this the data sizes typically aren't small.  In the case of my current project...


June 19, 2012  2:00 PM

I’ll be at SQL PASS 2012, will you?

Denny Cherry Denny Cherry Profile: Denny Cherry

It appears that I've been selected to give a couple of presentations at the premier Microsoft SQL Server conference again this year.  At the 2012 SQL PASS Summit in Seattle, WA this year I'll be presenting a regular session titled "


June 18, 2012  2:00 PM

The process could not execute ‘sp_replcmds’ on …

Denny Cherry Denny Cherry Profile: Denny Cherry

When setting up SQL Server replication you might see an error message from the Transactional Replication Log Reader Agent which reads like the following.

Error messages:
  • The process could not execute 'sp_replcmds' on ''. (Source: MSSQL_REPL, Error number:...


June 14, 2012  9:00 PM

When does SQLCLR launch?

Denny Cherry Denny Cherry Profile: Denny Cherry

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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


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: