SQL Server with Mr. Denny:

SQL Server 2005


March 27, 2013  2:00 PM

Using Event Viewer Logging for SSIS Performance Trouble Shooting



Posted by: Denny Cherry
BIDS, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSIS

So while working with a client recently I was going some performance tuning on SSIS for them.  While SSIS isn't exactly my normal workload, the problem wasn't really in SSIS, but just normal SQL Statements being called from SSIS. While attacking this problem, the first thing that I did was look...

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 Prajdić, Andre Kamman and myself with an interesting problem.  She had a database table which was about 200 Gigs in size which she wanted to...


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


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


April 12, 2012  2:00 PM

CPU Affinity Mask and virtualizating SQL Servers



Posted by: Denny Cherry
Error Message, Grant Fritchey, Hyper-V, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

If you have physical SQL Servers that you plan on moving into a virtual environment you'll want to double check your affinity mask settings before actually moving the machine from a physical server to a VM when using P2V software.  The reason for this is that if the affinity mask is set for...


April 9, 2012  5:06 PM

Upgrading MS Ops Manager & SQL Server



Posted by: Denny Cherry
Error 29112, MERGE statement, Microsoft Operations Manager, Microsoft System Center, OperationsManager, OperationsManagerDW, SQL Server, SQL Server 2005, SQL Server 2008 R2, System Center Management Configuration Service

Something which has come up when upgrading Microsoft Operations Manager 2007 to 2012 is that there is an extra step which isn't really documented in the Ops Manager upgrade guide.  You see when upgrading from Ops Manager 2007 to 2012 you also need to upgrade the SQL Server to SQL Server 2008 R2 as...


March 1, 2012  2:00 PM

Init Replication From Backup



Posted by: Denny Cherry
Replication, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2

One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot.  The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup. However this technique...


December 5, 2011  2:00 PM

Schema Design Changes shouldn’t just be done once



Posted by: Denny Cherry
Federated Database, SQL Server, SQL Server 2005, SQL Server 2008 R2

Just because you did a schema design change before doesn't mean that you shouldn't look into doing another one.  A while back, before I started working with Phreesia, they decided to fix some performance problems by federating some data.  The data is question...


June 15, 2011  5:27 PM

It’s #sqlpass summit session announcement time



Posted by: Denny Cherry
BI, Encryption, SQL PASS, SQL PASS 2011, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSAS, Stacia Misner

So I've managed to trick the kind folks of the SQL PASS program committee once again this year.  I've gotten two sessions accepted for the summit. The first is a "regular session" which is the normal 75 minute community session during which I'll be presenting "Where should I be encrypting my...