SQL Server with Mr. Denny:

SQL Server 2008 R2


December 6, 2010  2:00 PM

Microsoft SQL Server’s MDS has come a long way.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2008 R2

OK, now that I have your attention pretty much nothing has changed in Denali's Master Data Services.  The install procedure is a bit different now but that is about it.  To install the Denali version of MDS just run through the normal SQL Server installer.  When you get to the service list page...

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


June 14, 2010  11:00 AM

Getting started with Master Data Services in SQL Server 2008 R2



Posted by: Denny Cherry
SQL Server 2008 R2

I recently published an article on SearchSQLServer.com where I write all about SQL Server 2008 R2's Master Data Services and how to get...


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


March 3, 2010  6:23 PM

Getting set up for multi-server management with SQL Server 2008 R2



Posted by: Denny Cherry
MSM, Multi-Server Management, SearchSQLServer.com, SQL Server, SQL Server 2008 R2

I've just published a new article up on SearchSQLServer.com where I'm talking about how to setup the new Multi-Server Management feature of SQL Server 2008 R2 complete with some screen shots in case you...


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: