Recently I presented the topic of SQL Server in the AWS Cloud to the Queensland SQL Server User Group. The presentation provided an overview of the potential SQL Server application use cases for the AWS Cloud, in particular, I demo-ed an AlwaysOn Availability Group failover from a AWS EC2 instance to a on-premise SQL
One of the exciting new features coming out of the SQL Server 2014 release is the Buffer Pool Extension (BPE) option. BPE allows you extend the SQL Server Buffer Pool to fast IO devices like SSDs and therefore provides the equivalent of a level 2 cache. Basically SQL Server doesn’t have to retrieve data from slower disks for frequently
This post is part 2 of the Powershell for DBA – Working with INI Files and describes a simple method and then a more complex method to exclude databases from subsequent processing within a Powershell script.
It’s quite interesting that Microsoft’s SQL Server 2014 release has a number of In Memory performance optimisation features. The clock speeds of CPUs have not significantly increased over the last few years but memory has become relativity cheap and the 64 bit Windows platforms now provide substantial scope to run high memory footprints.
The Cloud IaaS market is constantly on the move so an IaaS Provider’s positioning can change within a short period of time.
According to the Gartner Group, Amazon Web Services (AWS) is still way ahead of all competitors and sits in the sweet spot of Magic Quadrant.
Ok so you can’t actually setup a failover cluster in the traditional sense on Amazon Web Services (AWS) EC2 instances (virtual machines). Essentially AWS does not provide a disk storage option that allows you to provision cluster aware, shareable disk devices.
SQL Server 2014 CTP 2 is now out and available for download (here).
Below is a summary of the new features in CTP 2 as outlined by the SQL Server blog (here). Microsoft have stated that CTP 2 is feature complete and therefore will be a close representation of the RTM version.
I’m highlighting this bug notice in my newsletter and blog since it has the potential to affect quite a few SQL Server 2012 installations.
Here’s the link to the MB KB article http://support.microsoft.com/kb/2845380 .
CU4 for SP1 resolves the issue.
Here’s an article by Mark Kromer (SQL Magazine – SQL Server BI Blog) on his views on the Old BI (traditional ETL/DW) vs. New BI (Big Data Hadoop) paradigms, and how a hybrid approach of traditional ETL/DW with Hadoop and MPP is emerging.
Over the last 3 years I have developed a range of major PowerShell scripts to deploy/configure Replication, SQL Server clustering onto multiple nodes and to perform Database Maintenance tasks (think Ola Hallengren SQL maintenance solution but in PowerShell).