Project Gemini has got an official name – PowerPivot for Excel 2010

PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Leveraging familiar Excel features, users can transform enormous quantities of data from virtually any source with incredible speed into meaningful information to get the answers they need in seconds. Using SQL Server…

1

Want to take control of your SQL Server Environment?

Come and join me for a lunchtime session at tomorrows SQL Server user group meeting. Following are the details:   Date: 7th October 2009 Time: 12:00pm Location: Westpac, 275 Kent St, Sydney NSW 2000 Session Details Learn how to leverage Policy Based Management as a tool to better manage your SQL Server environment in your…

1

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 investments can help streamline consolidation and upgrade initiatives across the application lifecycle—all with tools that make it…


Achieving High Availability with SQL Server 2008

I highly recommend that you read the following whitepaper on achieving high availability with SQL Server 2008 if you are planning or currently designing a high availability solution for your SQL Server environment. This whitepaper goes through the architecture one of our reference customers utilised to achieve 99.99% uptime of their SQL infrastructure. High Availability…


Cumulative Update #7 for SQL Server 2008 RTM

  Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 RTM. o    Understanding Incremental Servicing Model for SQL Server   o    CU#7 KB Article:…


Looking to save money $$$ Want to Consolidate your SQL Server environment?

If the answer to those questions is YES!! Then you don’t want to miss my talk about SQL Server consolidation/virtualisation. And the best part is you don’t even have to leave the comfort of your office. This is a virtual conference that can be accessed over the web using Live Meeting. I look forward to…


Teched Australia 2009

Just got back from sunny Gold Coast, with what I can say was a very successful Teched, at least from my perspective and the many attendees I talked to. I think the biggest thing this year at Teched were the HP mini Netbooks. They were widely used by all attendees, during sessions, breaks, just about…

1

From the Ground to the Sky – SQL Azure Migration Wizard

Many of you maybe playing around with your CTP invitations for SQL Azure and wondering how to get your current on premises databases into the cloud. Some options you have probably used: Script out the database and modify these scripts quite a lot to recreate the objects in the cloud Once you have got the…

2

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…

2

Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2

The following knowledge base article describes the known issues when you install Microsoft SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2 . List of known issues when you install SQL Server on Windows 7 or on Windows Server 2008 R2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;955725  For all editions except express edition of…

1