SQL Server with Mr. Denny:

SQL Server 2008


February 14, 2011  2:00 PM

My MCM Lab experience.



Posted by: Denny Cherry
Certifications, MCM, SQL Server, SQL Server 2008

So just in case you missed it, I took and passed the Microsoft MCM lab last Thursday.  Since I'm the first person to go through the test in the new format I wanted to put together some comments (as best I can thanks to NDAs). So the MCM gives you 6 hours to complete, and when you take it,...

February 7, 2011  2:00 PM

If you aren’t doing backups, you aren’t doing your job.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database.  There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...


July 29, 2010  11:00 AM

Running a query against multiple servers at one



Posted by: Denny Cherry
SQL Server 2008, SQL Server 2008 R2, SQL Server Management Studio

So you've got a bunch of machines that you want to run a quick query against.  SQL Server 2008's Management Studio gives you a quick and easy.  Open up the Registered Servers in Management Studio and select a group of servers.  Then right click on the group and click on the "New Query"...


April 12, 2010  9:00 AM

Man, I really hope this is my last post about plagiarism.



Posted by: Denny Cherry
Plagiarism, Sean McCown, SQL Server 2008, Twitter

So there have been a lot of talk recently about plagiarism in our little corner of the Internet.   If you haven't read up on it you can read up here,


March 29, 2010  11:00 AM

So I was installing SQL 2008 CU6 for SP1 the other day…



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

God that sounds boring doesn't it. Anyway, I was installing SQL 2008 CU 6 for SP 1 the other day and I was greeted with the dreaded "some process is running which will cause your SQL Server to reboot after install" screen.  The app which was running was fshost.exe which is part of the Full Text...


March 25, 2010  11:00 AM

Using Service Broker instead of Replication



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

During my SQL Service Broker sessions I talk about using SQL Service Broker as a replacement for SQL Replication.  But I've never really documented how to do this other than bits and pieces here and there.  So here I'm going to try and spell out how I put a system like this together for an auto...


October 7, 2009  7:50 AM

Data Transformation Services vs. SSIS: The key differences



Posted by: Denny Cherry
DTS, SearchSQLServer.com, SQL Server 2008, SSIS

I recently published an article on SearchSQLServer.com about DTS and SSIS where I talk about some of the differences.  Obvsiolly I didn't cover all the differences between DTS and SSIS, just...


September 14, 2009  5:24 PM

SQL Server Clustering Guide & Webcast Links



Posted by: Denny Cherry
iSCSI, SQL Server 2008, Starwind, Webcast

A white paper which I wrote for Starwind Software is now available.  The link to register for the webcast (October 21, 2009) has also been

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important



Posted by: Denny Cherry
Index Performance, Performance Problems, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, Statistics, White Paper

Today I'm publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy.


September 1, 2009  6:31 PM

SQL Server 2008 Clustering Article in SQL Server Magazine



Posted by: Denny Cherry
Article, Clustering, SQL Server 2008, SQL Server Magazine, Windows 2008

For those of you who haven't check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on...


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: