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 Control and Configuration Management Integrating External Changes with the Project System Build and Deployment…


Whitepaper: SQL Server High Availability Whitepaper by SQL CAT Team – Failure Is Not an Option: Zero Data Loss and High Availability

  When it comes to financial transactions of customers and their money, it is absolutely imperative that none of these transactions is ever lost due to an IT system failure (or any other type of failure). This white paper shows you how to create a Microsoft SQL Server infrastructure that enables operation for zero data…


Microsoft® SQL Server® code-named ‘Denali’ – Community Technology Preview 1 (CTP1)

The CTP 1 for SQL Server Denali is now available to download at the below link: Link to Download: Things that excite me about this upcoming release is: AlwaysOn – make high availability lot easier going forward in SQL Server, and also the ability to make the remote sites available for continuous read and…


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…


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


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: 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…


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 newest migration toolkit, others include Oracle, Sybase, Access,…


SQL Server virtualisation improvements with SLAT in Intel and AMD

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 throughput for hardware with SLAT & Windows Server 2008 R2 (required for SLAT support) degrades…


Resource: Book on SAP integration with SQL Server

Do you run SAP as your ERP systems? Do you also have SQL Server or SharePoint in your environment? Do you want to give your users easier ways to access the data in your SAP systems – let them be able to self-serve reports. Well if the answers to any of the above questions is…