DBInsight’s Blogs

SQL in the AWS Cloud – SQL User Group PP Slides
Posted by Rob Risetto on November 08, 2014

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

Continue Reading

Buffer Pool Extension Feature Road Test on AWS
Posted by Rob Risetto on October 23, 2014

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

Continue Reading

Powershell for DBAs – Working with DB Exclude Lists
Posted by Rob Risetto on October 02, 2014

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.

Continue Reading

Microsoft’s In Memory Strategy for SQL Server
Posted by Rob Risetto on September 20, 2014

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.

Continue Reading

Magic Quadrant for the Cloud – Infrastructure as a Service (IaaS)
Posted by Rob Risetto on September 09, 2014

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.

Continue Reading

AWS EC2 SQL Server Clustering
Posted by Rob Risetto on August 28, 2014

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.

Continue Reading

SQL Server 2014 CTP 2 is out
Posted by Rob Risetto on August 15, 2014

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.

Continue Reading

Arrrggh SQL Server 2012 SP1 Performance Bug Alert
Posted by Rob Risetto on July 26, 2014

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.

Continue Reading

BI Corner – Old BI vs. New BI vs. Hybrid BI
Posted by Rob Risetto on July 19, 2014

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.

Continue Reading

PowerShell for DBAs – Working with INI files
Posted by Rob Risetto on June 25, 2014

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

Continue Reading