SQL Server with Mr. Denny:

SQL Server 2008


April 2, 2014  5:00 PM

How I Setup TempDB



Posted by: Denny Cherry
Back To Basics, Database Administration, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, TempDB

How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there.  So here's how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well.

Number of Files

The number of files that...

January 29, 2014  2:00 PM

Log Shipping Databases and Permissions Problems



Posted by: Denny Cherry
Attaching Database, Data Security, Database, Database Administration, Error 3013, Error 3119, Error 4319, Full Recovery Model, Log Shipping, Recovery Model, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Recently I was doing log shipping for a client in preparation to move their databases from one data center to another, when I was asked to change the drive that one of the target databases was being restored to. No problem, I'll just use ALTER DATABASE ... MODIFY FILE (name='xxx',...


January 15, 2014  2:00 PM

Fixing TempDB database problems when starting SQL using a minimum config



Posted by: Denny Cherry
Data Loss, Database, Database Administration, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, T/SQL, TempDB

So the other day I typo'ed something. Usually this isn't that big a deal, but in this case when fixing tempdb for a customer I told SQL to put two logical files into the same physical file. I was able to get it to let me do this because I first added the files, then realized that I had put them...


December 18, 2013  2:00 PM

Encryption and Compression



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...


December 11, 2013  2:00 PM

Clustering in Amazon EC2 – Tomorrow!



Posted by: Denny Cherry
Clustering, Database, Database Administration, DataCenter, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, Recovery, Server Hardware, SIOS Technologies, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Tomorrow (December 12th) at noon Pacific Time I'm presenting a session with SIOS Technologies on using their SANLess Clustering Technology to build a clustered SQL Server for High Availability within Amazon's EC2 cloud. This session is...


November 13, 2013  2:00 PM

Old Versions of SQL Server On New Hardware Can Be Interesting



Posted by: Denny Cherry
Database, Database Administration, DataCenter, Microsoft Windows, Server Hardware, SQL Licensing, SQL Server 2008, Windows 2008 R2

Recently a friend was working on one of his clients SQL Servers and he ran into an interesting problem. The hardware in question was a HP DL 580...


October 27, 2013  2:00 PM

If you could give an aspiring DBA just one piece of advice what would it be?



Posted by: Denny Cherry
Database, Database Administration, ITKE grandparent, SQL PASS, SQL Saturday, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Probably the best advise that I could someone entering the field of Database Administration would be to keep learning. If you think that you know...


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


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


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: