SQL Server Standard vs. Enterprise Edition

A question I often get asked by customers is which edition of SQL Server do I use? I then based on the workload, high availability/disaster recovery, scalability, BI and other requirements do walk the customer down to the decision. You can also work through this using the edition comparison tool on the web at the…

20

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…

2

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…

2

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…

1

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

4

SQL Server 2008 R2 Best Practices Analyser

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 and a Microsoft SQL Server 2008 or 2008 R2 instance…

2

SQL Server 2008: Upgrading to Standard/Enterprise Edition from Evaluation Edition

I often get asked about upgrading SQL Server 2008 Evaluation Edition to a retail edition such as Standard or Enterprise Edition. This is very well documented at the below SQL Server books online link: How to: Upgrade to a Different Edition of SQL Server 2008 (Setup) http://msdn.microsoft.com/en-us/library/cc707783.aspx Below are the main steps, using the Setup…

10

Time really flies when you have fun

Well with a great product release like SQL Server 2008 and many many features like Geospatial support, data visualisation with reporting services, DW optimisations and many other bells and whistles; one can be kept busy for a long long time. And it only hit me how quickly time has flown when I read the following…

1

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…

2

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…

3