At Teched North America we just announced our official SQL Server Private Cloud story, and I really like how this encapsulated in the below poster (which by the way can be downloaded from the site). The SQL Server Private Cloud story is about consolidating databases, and providing and easy to deploy...

Come and hear about the Microsoft Application platform at the upcoming briefing seminars in a city near to you: Date City Venue 28th March 2011 Sydney Vibe Hotel Ballroom A, 88 Alfred St, Milsons Point 29th March 2011 Melbourne Microsoft Office, Level 5, 4 Freshwater Place Southbank 30th March 2011 Canberra...

  As a leading authority on Master Data Management and the Australian distributor of Profisee's Master Data Maestro, Decision Resources is delighted to extend this invitation for leading Australian businesses to participate in the Master Data Services Solution Showcase,  being hosted by our...

The January 2011 update includes lots of great new content and several usability improvements. Below is a high level overview of what is included: 31 presentations (PowerPoint slides, videos and transcripts included) 27 demos (installer scripts, videos and transcripts included) 12 hands on labs (installer...

  The almost 500 page Upgrade Technical Reference guide for SQL Server 2008 R2 is available at the dedicated upgrade site . This guide not only covers upgrading from versions prior to 2008, it also covers considerations (minimal) for upgrades between SQL Server 2008 and 2008 R2. If you are looking...

  Recently, on codeplex the Application Lifecycle Management Rangers from Microsoft have made available guidance on database development practices when using Visual Studio 2010 database projects. This practical guidance is focused on the following topics: Solution and Project Management Source Code...

Master Data Services portal page is now live on MSDN! This portal  presents information about MDS from many different sources, including Microsoft, third-party, and community contributions. The following table outlines the kind of information we’re sharing with users on the page: Section Description...

Microsoft announced today the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4.2 release. SQL Server Migration Assistant for MySQL is the...

A cumulative update for Master Data Services has been released. It addresses a number (30+) of issues that weren't addressed before the release of SQL Server 2008 R2 RTM release.  If you are looking at using MDS, then this update is a MUST for you. It also fixes the issue of publishing business...

While preparing for a demonstration of SQL Server 2008 R2 Master Data Services – vanilla build – my colleague Lee Theofanis from Decision Resources came across an issue regarding business rule activation. The Issue After creating a business rule through the Master Data Manager portal, and then trying...

Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server 2008 or 2008 R2 instances. The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions: Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance...

Kerberos/Double hop with SSRS From a infrastructure implementation of Microsoft BI solutions, one of the most difficult things to get right can be authentication between multiple servers in a scale out solution. This is known as the ‘double hop’ situation. A new white paper released in April 2010 outlines...

We are very excited to share that today, Microsoft released SQL Server 2008 R2 to manufacturing! Customers can expect availability in the next few weeks through Microsoft’s distribution channels. For more information, visit www.sqlserverlaunch.com . SQL Server 2008 R2 enhancements continue to support...

An comprehensive whitepaper regarding the installation and deployment of PowerPivot has been recently released by the SQL CAT Team. It can be accessed from the below site: http://sqlcat.com/whitepapers/archive/2010/04/14/microsoft-sql-server-2008-r2-powerpivot-planning-and-deployment.aspx Direct link...

Three of the six RTM SQL Server 2008 R2 e-clinics are ready; the final three will arrive in mid-April: · Introduction to Microsoft® SQL Server® 2008 R2 Master Data Services / This two-hour clinic describes the capabilities of Microsoft SQL Server 2008 Master Data Services, including the following topics...

Download it from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d   SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2Update...

As we are nearing to the release of SQL Server 2008 R2, I have been presenting about its new features and one that reasonates well amongst the DBAs is the multi server management. DBAs see this as a great way of getting insight into planned consolidated SQL Server environements. It not only helps from...

You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address 256 processors. This is all good in theory – now see a video showing off some of the latest hardware from Unisys running pre-release versions of SQL Server 2008 R2. With this combination you can get a 72...

Well then follow the below link and you can launch an virtual lab that takes you through the PowerPivot add-in. The only thing you need to install is an ActiveX control to let you access the virtual lab environment. https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d

SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization. Such...

With SQL Server 2008 R2 CTP 2 being available, I have been playing around with one of the new features – Report Builder 3.0. One of the new features in this reporting services version is the ability to create Map based reports. Out of the box we will only ship with the map of USA and each of its states...