Whitepaper: SQL Server’s Price/Performance

Following whitepapers have been released/updated and discuss SQL Server’s great low TCO and Enterprise capabilities. It is a must read for anyone looking for a database platform that can provide the best value.   Do Not Pay Too Much For Your Database Licenses: update from previous white paper entitled Understanding DB Pricing that shows SQL…


End User Guidance for MS based BI solutions

As more and more customers implement Performance Point Services based BI solutions using SharePoint 2007/2010, one question I am getting asked is about how do we provide continuing guidance to end users beyond the formal user training they might receive. With PPS one can build great BI solutions and if end users aren’t aware of…


SQL Server 2008 SP2 Now Available

Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.  Service Pack 2 for SQL Server 2008 includes new compatibility features with SQL Server 2008 R2, product improvements based on requests from the…


SQL Server High Availability: Technical Case Study

The SQL CAT Team have just released another SQL Server High Availability case study. This time it is based on a Australian customer – Queensland Rail’s implementation of a geo-clustered SQL Server using Hitachi SANs with Truecopy. This infrastructure is used to run their SAP databases which was migrated of mainframe – z/OS with DB2….


PowerPivot SharePoint Integration Install Bug

I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message:     Error: Your SQL Server 2008 R2 installation completed with failures.             Object reference not set to an instance of an object. When you view…


SQL Server Most Secure Database

Let me say that again just in case you missed it, SQL Server is the most secure RDBMS. This is just not me saying, it is based on figures tracked by NIST, and the full details have been written up by a independent analyst. The full report can be accessed at: http://itic-corp.com/blog/2010/09/sql-server-most-secure-database-oracle-least-secure-database-since-2002/ So next time…


Learning and getting trained to be a SQL Server DBA

Time to time I get questions asked about training and learning more about SQL Server management, maintenance, best practices. As with every Microsoft product I say they are best learnt with hands on technique, that is to say get yourself a copy of the software (of course legally/eval versions) and install it and as most…


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 Getting Started Features links to introduce customers to MDS, help them find…


SQL Azure Service Update 4

Service Update 4 is now live with database copy, improved help system, and deployment of Microsoft Project Code-Named “Houston” to multiple data centers.   Support for database copy: Database copy allows you to make a real-time complete snapshot of your database into a different server in the data center. This new copy feature is the…