SQL Server with Mr. Denny:

Storage


September 12, 2012  2:00 PM

When clustering guests, host them on different LUNs



Posted by: Denny Cherry
Clustering, Hyper-V, SQL Server, Storage, VMware

When building virtual clusters under any HyperVisor you need to make sure that all the nodes of the cluster are being hosted on different LUNs on the hosts. If you build the VMs on the same LUN and that LUN fails for some reason then both of the nodes of the cluster will be down, and the whole...

August 9, 2012  2:00 PM

Second Edition of Securing SQL Server now longer available for pre-order. It’s Shipping! (repost)



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Azure, Data Loss, Data Security, Database Administration, Database security, Microsoft Windows, Security, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Storage

In case you missed the blog post over on securingsqlserver.com, I wanted to repost it here... I'm afraid that I've got some bad news.  You can no longer pre-order


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

Moving huge amounts of data between data centers



Posted by: Denny Cherry
Data Center Build, Migration, Restore Database, SQL Server

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

The process could not execute ‘sp_replcmds’ on …



Posted by: Denny Cherry
Replication, SQL Server

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


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


March 29, 2012  2:00 PM

SQL Server Replication and DR



Posted by: Denny Cherry
Distaster Recovery, Replication, SQL Server

Every once and a while people ask me if they should use SQL Server Replication to get data to a DR site.  And typically to them my answer is "probably not".  The reason that I say that is for a couple of reasons. 1. If there are triggers on your tables, replication doesn't have a way to ensure...


March 12, 2012  6:16 PM

SQL Saturday 120 Storage and Virtualization Pre-Con



Posted by: Denny Cherry
Aaron Nelson, Audry Hammonds, Grant Fritchey, Jeremiah Peschka, Kendra Little, Randy Knight, SQL Saturday 120, SQL Server, Storage, Virtualization

Interested in my SQL Bits pre-con, but you just can't make it out to London for SQL Bits?  Have I got a deal for you.  It has just been announced that I will be giving my Storage and Virtualization pre-con at SQL Saturday 120 on March 23rd, 2012. SQL Saturday is bringing you this pre-con for...


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: