SQL Server with Mr. Denny:

SQL Server 2000


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

March 26, 2014  7:00 PM

Excel 2013 and Analysis Services 2000



Posted by: Denny Cherry
SQL Server, SQL Server 2000

So I got a strange question from a client the other day.  Can I get Excel 2013 connected to Analysis Services 2000? Yes you read that correct, SSAS 2000.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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


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


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


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


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


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: