Migration cookbook now available for the latest Azure SQL Database Update (V12)

The cookbook describes various approaches you can use to migrate an on-premises SQL Server database to the latest Azure SQL Database Update (V12). The cookbook can be viewed and downloaded here. This latest Azure SQL Database Update (V12) brings near-complete SQL Server engine compatibility, even more Premium performance and marks the first step in delivering…

8

Windows Azure Virtual Machines now available

Now available – Windows Azure Infrastructure Services, which includes Virtual Machines and Virtual Networks to keep your Windows Azure connected to your on-premises infrastructure and applications. Windows Azure Infrastructure Services provide the robust cloud infrastructure that is needed to run SQL Server and many of the applications that rely on SQL Server. With Windows Azure…

1

Virtualise and Consolidate SQL Server with confidence on Windows Server 2012 Hyper-V

  The study by ESG Labs, demonstrates performance, scalability, and low overhead of Hyper-V can be used to reduce costs and improve the manageability, flexibility, and availability of SQL Server workloads. Through their testing, ESG Lab confirmed that the performance and scalability of Windows Server 2012 with Hyper-V makes it possible to consolidate a tier-1…

3

I have had my head in the cloud lately…..

With the launch of the Virtual Machine preview on Windows Azure along with Media Services and Websites I have been busy just setting up a few environments. It has been really easy to spin up new VMs very quickly – literally in few clicks once you have registered for the preview for Virtual Machine. What’s…

2

My SQL Saturday Presentation on the HP Database Consolidation Appliance (DBCA)

Thank you to those who attended my SQL Saturday presentation last Saturday at Epping Boys High School. It was a very well organised event by Grant Paisley pictured below, enjoying the many boxes of pizza made available during the lunch break for attendees. There are still more SQL Saturday events to go – Adelaide, Perth…

3

Reference Architecture for High Performance SQL Server

HP and Microsoft engineering teams have worked together to create a reference architecture to Accelerate Online Transaction Processing (OLTP) database workloads with a fully-flash based HP/Microsoft architecture and achieve significant performance increases, simplified database manageability, and industry leading TCO. The HP OLTP RA, built on HP ProLiant DL980 servers and HP VMA-series 3210 Memory Arrays…

3

Thinking about moving your database to the cloud

To help you evaluate your SQL Server database(s) readiness to move onto our public offering – SQL Azure, we have made available a new experimental online service – SQL Azure Compatibility Assessment   on SQL Azure Labs. This services checks compatibility of your schema. To use this service you need: Live ID A .dacpac extracted…

6

See you at Teched Australia 2011

Just finishing off the final touches to my two presentations and hope to catch you either in my sessions or at the exhibition floor where we will be showcasing the new HP Business Decision (BDA), exciting BI visualisation with Project Crescent and the new AlwaysOn capability to easily enable availability for your databases. Below are…

4

Tips & Tricks: YOU HAVE LOST ACCESS TO SQL SERVER. NOW WHAT?

A Principal Data Engineer at Microsoft (Saleem Hakani) had authored the below SQL Server Tips & Trick and I thought it would be one that would be found handy by many. Keep this one handy you never know when you may need it (Hopefully not too many times). You are working as a trusted DBA…

24

SQL Server Private Cloud Simplified

At Teched North America we just announced our official SQL Server Private Cloud story, and I really like how this encapsulated in the below poster (which by the way can be downloaded from the site). The SQL Server Private Cloud story is about consolidating databases, and providing and easy to deploy, manage and grow platform…

6