SQL Server Blog

Applying SQL Server Service Packs

April 1st, 2017

Applying SQL Server Services Packs to your environment is very important. The approach on when to apply service packs has changed over time, and makes it very important to have the process included into your support windows. This post takes you through how to apply a Service Pack into an Availability Group environment.

Read More

SQLSaturday 509 Brisbane

March 2nd, 2016

SQLSaturday 509 in Brisbane is bring your a precon event on Friday 27th May, 2016 as part of the SQLSaturday event. Registrations are open.

Read More

SQLSaturday 509 Brisbane

January 4th, 2016

The SQLSaturday show is coming to Brisbane again in 2016. Put a reminder in your calendar now for Saturday 28th May, 2016 for your free day of SQL Server and Business Intelligence (BI) training from some of Australia’s leading SQL Server experts. 

Read More

Don’t call me Crazy, Biml is not just for BI

December 28th, 2015

For those of you who have read some of my previous articles, you will know that I predominantly write on..

Read More

Tail of the Log

August 20th, 2015

Tail of the Log is an important aspect of SQL Server databases for recovery purposes. In this article Warwick will introduce you to what it is and how to make it useful to you in your environment.

Read More

Configure DBMail for SQLExpress on Windows Azure

August 12th, 2014

SQL Server Express is a very common version of SQL Server used when creating a website. In this article we will have a look at how you can configure DBMail in your SQL Server Express instance on a Windows Azure virtual machine. The majority of steps have not changed since SQL Server 2005 was first released.

Read More

SQL Server Support for SysPrep

June 17th, 2014

Sysprep was first supported with SQL Server 2008 R2 to help with your raid deployment of SQL Server environments. With the release of SQL Server 2014 improved support is available for SQL Server installations via Sysprep.

Read More

Performance Analysis of Logs (PAL) V2.5

May 29th, 2014

If you’re a SQL Server DBA then you probably need to at some stage undertake some performance analysis of your SQL Server environment. The latest Version of PAL is available for download from codeplex.

Read More

AlwaysOn Availability Groups: What not to do when adding databases

April 6th, 2014

SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. How many database can you reasonable add? it depends on the resources available and the workload, but you can come up with a reasonable estimate as Warwick explains

Read More

My Journey to becoming a Microsoft Certified Solutions Master

October 4th, 2013

In this post I am going to take you through my journey to becoming a Microsoft Certified Solutions Master.

Read More

SQL Server in the Cloud

June 2nd, 2012

Amazon RDS is providing you an offer, allowing you to have a look at and test out SQL Server in the Cloud for free for 12 months.

Read More

SQL Server Instance Database Sizing’s

January 25th, 2012

Quickly and easily reporting on all DB's in your SQL Instances on space usage is a requirement that is not that easy to achieve for multiple databases. It can be made simpler with the use of the .sql script that I have created that is available for download.

Read More

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.