SQL Server 2008 Enterprise and DW Optimisations

One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform. Many organisations have deployed it – with DW ranging from 1TB well into the 60-80TB. So what makes SQL Server 2008 Enterprise a better choice than SQL Server 2005 is due to the star join and…


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…


SQL Server 2005 Users

SQL Server 2005 SP2 support will be retired on the 12th January 2010. Now is a good time to start planning upgrades of applications to SQL Server 2005 SP3 or SQL Server 2008 (were possible). Link: http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2005&Filter=FilterNO


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


PowerPivot (NOV CTP) for Excel 2010 (Beta) Now Available

SQL Server PowerPivot is an innovative data analysis technology that redefines how organizations apply and succeed with BI. IT managers can deliver corporate BI solutions and also establish a managed BI collaboration environment that gives business users the power to get the answers they need to make decisions on their own, facilitates information sharing and…


SQL Server 2008 R2 – November CTP now Available

The November CTP download is available for MSDN and TechNet subscribers. The public download is available here. The Data Platform Insider blog provides an overview of what’s new in CTP release for SQL Server 2008 R2.


Top Tips for Effective Database Maintenance

Many of you new SQL Server DBAs may be wondering what are the things to lookout for to effectively maintain a production SQL Server database. Paul Randal has written an excellent article on this very topic, and it covers the following points: Managing data and transaction log files Eliminating index fragmentation Ensuring accurate, up-to-date statistics…


SQL Pass Announcements – New SQL Server 2008 R2 Editions

Two new premium editions in SQL Server 2008 R2 SQL Server 2008 R2 Datacenter Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter delivers a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure. Datacenter helps enable…


Whitepaper: High Availability with SQL Server 2008

This white paper describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes of downtime and data loss, and how to evaluate and balance requirements and limitations…


Whitepaper: Consolidation Using SQL Server 2008

Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed plan and timeline for success, and a strategy for administering the consolidated environment. This white paper walks through the journey of…