SQL Server with Mr. Denny:

SQL Server 2008 R2


March 13, 2013  2:00 PM

Deleting LOB Data and Shrinking the Database



Posted by: Denny Cherry
Andre Kamman, Database, Database Administration, DBCC PAGE, Mladen Prajdić, Paul Randal, SQL Saturday, SQL Saturday 194, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, System Objects, Tables

While attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen...

February 25, 2013  11:44 PM

SQL Saturday 177 Slide Deck



Posted by: Denny Cherry
SQL Saturday, SQL Saturday 177, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

This last weekend I had the privilege of speaking at SQL Saturday 177 in Mountain View, CA.  One of the great things about this SQL Saturday is that in some ways it...


February 20, 2013  2:00 PM

Cleaning Up Reporting Services Snapshots



Posted by: Denny Cherry
Reporting Services, SQL Server, SQL Server 2008 R2

If you've been running a SQL Server Reporting Services machine for a long time you may have noticed that your ReportServerTempDB database has...


December 26, 2012  2:00 PM

Cross Database Chaining



Posted by: Denny Cherry
Data Security, Database, Database security, Security, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3.  However this feature isn't often understood mostly because it isn't often used. Database chaining is when permissions cascade from one object to another because they are used by the...


November 17, 2012  2:00 PM

Backup Databases on Creation



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, CREATE TRIGGER, Data Loss, Database, Database Administration, DDL Trigger, Recovery, SQL Server, SQL Server 2008 R2, SQL Server 2012, T/SQL, Transactions, Trigger, xp_create_subdir

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are...


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

Security Sessions at SQL PASS 2012



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database, Database Administration, Database Design, Database security, Encryption, Security, SQL Injection, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

The SQL PASS session list for the SQL PASS 2012 Summit has been released.  This year there are 192 sessions being presented at the SQL PASS summit.  Last year at the 2011 summit there were only a couple of sessions...


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


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


May 14, 2012  2:00 PM

Be careful which node you install a clustered instance from



Posted by: Denny Cherry
Installation, SQL Server, SQL Server 2008 R2

While installing a clustered SQL Server instance recently I ran across a bit of an annoyance.  When I was going through the SQL Installation process I didn't pay any attention to which node of the cluster currently owned all the disks that I was planning on using for SQL Server.  Because of this...


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: