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

Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...