SQL Server with Mr. Denny:

SQL Server


May 6, 2010  11:00 AM

If you change the default instances port number, you may not be able to connect



Posted by: Denny Cherry
Microsoft CSS, SQL Server

Something that some companies like to do is to change the port number that the default instance is listening under as a security precaution.  However this has a habit of stopping anyone from connecting to the default instance without knowing the port number. This is because the default instance...

April 21, 2010  5:00 PM

Don’t plan on enrolling SQL Express instances in your SQL 2008 R2 multi server management console



Posted by: Denny Cherry
Multi-Server Management, SQL Server, SQL Server 2008 R2

While Microsoft has been telling us over and over how multi-server management will be this great way to manage all your instances, don't plan on managing your SQL Express instances with it.  Multi-Server management will only enroll Web Edition up through the Data Center Edition.  The Express...


April 21, 2010  4:12 PM

Limited SQL Server 2008 R2 Virtualization Support



Posted by: Denny Cherry
Live Migration, SQL Server, SQL Server 2008 R2

As part of the SQL Server 2008 R2 launch it was announced that SQL Server 2008 R2 now supports Hyper-V Live Migration.  However according to MSDN only the Standard, Enterprise and Datacenter editions support Live...


April 21, 2010  3:09 PM

SQL Server 2008 R2 has been Released to Manufacturing



Posted by: Denny Cherry
Powerpivot, SQL Server, SQL Server 2008 R2, SSRS

Microsoft's new database platform SQL Server 2008 R2 has gone RTM.  This means that the code has been locked, and shipped to the DVD pressing company so that they can begin pressing the DVDs. For those looking on MSDN or TechNet to download the RTM version, hold off.  The final version will be...


April 19, 2010  11:00 AM

Hey sysadmins, powerpivot is coming, and it’ll take a lot of disk space.



Posted by: Denny Cherry
Powerpivot, SQL Server, SQL Server 2008 R2, Storage

So if you haven't heard of PowerPivot yet, it's going to be the next best thing to sliced bread for your business users.  While it'll take a while for most IT shops to get the full Sharepoint & PowerPivot integration setup, PowerPivot will be available to your users within the next few weeks...


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,


April 5, 2010  12:00 PM

Events, events, events. When the hell am I suposed to get work done?



Posted by: Denny Cherry
Back To Basics, In Person Events, Plagiarism, Sean McCown, SQL Server, SSWUG

This week I've got a few speaking events to let everyone know about. On Tuesday April 6th, at 6pm I'll be speaking to the LA C# User Group.  The meeting is held at the Manhattan Beach Library at 1320 Highland Ave in Manhattan Beach, CA 90266.  The group...


April 1, 2010  11:00 AM

Getting started with Master Data Services in SQL Server 2008 R2



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

A couple of days ago a new article went live over on SearchSQLServer.com where I dig into setting up Master Data Services.  This is the first in a series of articles which will be either 2 or 3 articles long where I'm going into MDS in some...


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