December 6, 2010 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 11,
SQL Server 2008 R2OK, 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
Posted by: Denny Cherry
SQL Server 2008,
SQL Server 2008 R2,
SQL Server Management StudioSo 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
Posted by: Denny Cherry
SQL Server 2008 R2I 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
Posted by: Denny Cherry
Multi-Server Management,
SQL Server,
SQL Server 2008 R2While 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
Posted by: Denny Cherry
Live Migration,
SQL Server,
SQL Server 2008 R2As 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
Posted by: Denny Cherry
Powerpivot,
SQL Server,
SQL Server 2008 R2,
SSRSMicrosoft'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
Posted by: Denny Cherry
Powerpivot,
SQL Server,
SQL Server 2008 R2,
StorageSo 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
Posted by: Denny Cherry
SearchSQLServer.com,
SQL Server,
SQL Server 2008 R2A 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
Posted by: Denny Cherry
Replication,
Service Broker,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2During 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...
