My colleague Alan Eldridge, BI Technology Specialist at Microsoft, put together a great post on incorporating Reporting Services reports in Word and PowerPoint. With his permission I am making it available to you. This post talks about incorporating the...

Are you a Oracle DBA that has responsibility for SQL Server’s within your organisation, or even better your organisation has realised the cost saving achieved by migrating from Oracle to SQL Server, and now you have to look after SQL Server. Whatever...

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

Recently I had query around documentation that discusses the benefits of running SQL Server in a virtualised environment on modern hardware with SLAT or second level address translation. The below graph shows that (see the solid red line) the relative...

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

This month we have two sessions: Master you data with Master Data Services (Shashank Pawar) Why use PowerShell (Siraj Jamdar) | Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) 6...

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

SQL Azure Extends to 50 GB SQL Azure database is now extending from 10GB to 50GB size of database storage capacity. With 50 GB capacity now available, customers can have much broader use of the SQL Azure highly available, relational database...

Be early to register for Teched this year as you all remember last year was a sell out. This year is going to be fantastic with a whole lot of new products and technologies that were and are being released this year. Below are a list of a few: * SQL Server...