See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
All things Data Related....
On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data
database consolidation appliance
Fast Track DW
HP Database Consolidation Appliance
master data management
Master Data Services
multi server management
reporting services integration
Service Pack 2
sharepoint 2010 integration
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
sql server 2008 r2 free training
SQL Server 2012
SQL Server 2014
sql server as service
SQL Server Migration
Tips & Tricks
Visual Studio 2010
Windows Server 2008 R2
Windows Server 2012
Browse by Tags
All things Data Related....
sql server 2008 r2
Update for SQL Server 2008 Developer Training Kit – Now includes SQL Server 2008 R2 material
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...
29 Mar 2010
FREE Online SQL Server 2008 R2 Training
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...
7 Apr 2010
SQL Server 2008 R2 Best Practices Analyser
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...
20 Jun 2010
Database Development Guidance Paper published by the Application Lifecycle Management Rangers
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...
22 Nov 2010
SQL Server 2008 R2: Multi Server Management Feature Survey
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...
16 Mar 2010
Master Data Services Portal on MSDN
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...
29 Aug 2010
SQL Server 2008 R2 has RTMed
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...
22 Apr 2010
Update: New SQL Server 2008 R2 Upgrade reference manual available
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...
22 Jan 2011
Application and Multi-Server Management features in SQL Server 2008 R2
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...
6 Oct 2009
Master Data Services–Business Rule Activation error and its fix
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...
20 Jun 2010
Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010
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
7 Dec 2009
Really Scale with SQL Server 2008 R2
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...
22 Dec 2009
FREE Webinar: Master Data Services
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...
6 Feb 2011
Report Builder 3.0: Getting Aussie Maps in the Reports
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...
26 Aug 2009
SQL Server 2008 R2 and SQL Azure Whitepapers
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...
1 Jun 2010
SQL Server 2008 R2 Update for Developers Training Kit–Jan 2011
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...
30 Jan 2011
Migrate from MySQL/Access to SQL Azure or SQL Server with ease!
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...
16 Aug 2010
SQL Server Private Cloud Simplified
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...
18 May 2011
Platform Power Briefings
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...
17 Mar 2011
Master Data Services first cumulative update is now available!
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...
29 Jun 2010
Whitepaper: PowerPivot Planning and Deployment
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...
19 Apr 2010
© 2014 Microsoft Corporation.
Privacy & Cookies