DBInsight's Blog

SQL in the AWS Cloud – SQL User Group PP Slides

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 Server […]

Continue Reading →

Posted in: AWS, Cloud, Performance, SQL Server 2014

Leave a Comment (0) →

Microsoft’s In Memory Strategy for SQL Server

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. Therefore it […]

Continue Reading →

Posted in: Business Intelligence, Performance, SQL Server 2014

Leave a Comment (0) →

AWS EC2 SQL Server Clustering

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. However, all is not lost, SQL Server Magazine’s Denny Cherry article (here) highlights a […]

Continue Reading →

Posted in: AWS, Cloud, High Availability

Leave a Comment (0) →

Arrrggh SQL Server 2012 SP1 Performance Bug Alert

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. The description from the KB Article follows. You may experience slow performance in SQL Server […]

Continue Reading →

Posted in: Performance, SQL Bug

Leave a Comment (0) →

PowerShell for DBAs – Working with INI files

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). Anyway all these major scripts required a large number of configuration parameters and as you would expect […]

Continue Reading →

Posted in: PowerShell

Leave a Comment (0) →
Page 5 of 7 «...34567