SQL Server with Mr. Denny:

SQL Server


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

July 9, 2012  6:20 PM

Windows 2012 Dates Announced



Posted by: Denny Cherry
Microsoft Windows, SQL Server

It appears that Microsoft has released the dates for RTM (Release To Manufacturing) and GA (General Availability) for both the Windows 2012 Server and Client Operating Systems. Both the client and server with RTM the first week in August with the server OS will be available in September and the...


July 5, 2012  6:31 PM

VMworld needs to provide more feedback to session submitters



Posted by: Denny Cherry
Database, SQL, SQL Server, Tech Ed, vCenter, Virtualization, VMware, VMworld, VMworld 2012, vSphere 5.0

I've submitted a lot of sessions to a lot of conferences over the years.  And while the feedback from some of the conferences is a little cryptic thanks to the review team only having access to canned responses, it'll do.  Now personally I'd love to get specific feedback saying exactly why my...


July 5, 2012  2:00 PM

Prepping the security for a data warehouse



Posted by: Denny Cherry
Active Directory, Database security, Permissions, SQL Server

So in an earlier blog post I talked about how I had to grant some users the ability to create indexes in a reporting server.  A couple of people have asked me how I created the domain...


July 2, 2012  2:00 PM

Giving users the ability to create indexes



Posted by: Denny Cherry
Index Performance, SQL Server

So I ran across a pretty interesting requirement when setting up a new reporting database server.  The end users who run queries against the databases on this server are pretty good at performance tuning their own queries so they wanted the ability to create indexes on the tables on the reporting...


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

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



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Data Security, Database security, In Person Events, SQL PASS, SQL PASS 2012, SQL Server

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 …



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


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: