SQL Server Blog

SQL Server 2005 Installation Failure on Windows Server 2003

December 10th, 2014

When Installing older versions of SQL Server on new hardware we need to be aware of limitations that could cause errors to be generated. In this article we will have a look at an error while installing SQL Server 2005 Slipstreamed with SP2 onto a Windows Server 2003 Server with multiple cores. Error 1053 results and how can we get around this to complete the installation? Read more ….

Read More

T-SQL Tuesday #61 – Giving Back

December 8th, 2014

T-SQL Tuesday #61 – Giving Back. In this months party we are talking about plans of giving back to the community for the next 12 months. A look in the future. Hopefully what I can achieve maches reality.

Read More

SQLSaturday 382 Brisbane

December 7th, 2014

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

Read More

The Computer ‘*’ is joined to a Cluster

November 19th, 2014

Clustering can be confusing and for some it may look like smoke and mirrors  with how it all work’s and hangs together. I recently was putting together a demo environment with a 2 node Windows Server Failover Cluster (WSFC). During the build of the cluster it seemed to all go well except on looking more closely, Node 2 in the cluster was being reported as offline by the Failover Cluster Manager. Node 2 was up and available and I could ping the server but it was having issues communicating with Node 1 through the Cluster.

Read More

SQLSaturday Pre-Con : BIML Bootcamp

November 11th, 2014

SQL Saturday #365 in Melbourne on February 7th, 2015 has included 3 Pre-Con events running on Friday 6th February, 2015. I will be joining Paul Schmidt (@VarigenceANZ), Peter Avenant (@BimlDownunder) and Reeves Smith (@SQLReeves) to bring you the first SQLSaturday Pre-Con in Australia for our BIML Bootcamp.

Read More

T-SQL Tuesday #60 – Something New Learned

November 10th, 2014

It is that time of the Month again for another T-SQL Tuesday Post. This time hosted by Chris Yates. In this article we are having a look at Something New that has been learned.

Read More

SQL Server 2005 Upgrade Advisor

October 20th, 2014

SQL Server 2005 Upgrade advisor is a must tool if you are still working with SQL Server 2000 and looking to upgrade. However when you go to use this tool, you may hit an issue with being able to run the tool and get any valid results for your environment. This quick blog will give you the steps to keep you going with investigating your environment.

Read More

Azure Virtual Machines

October 14th, 2014

The world of Cloud Computing is changing very quickly. Whether you are already using cloud services or looking at using cloud services to host your website or extend your SQL Server footprint into a hybrid environment the performance improvements in cloud resources from Azure is constantly improving.

Read More

T-SQL Tuesday #59 – My Hero

October 13th, 2014

T-SQL Tuesday #59 topic is My Hero. Have a read of my take on this topic for the month.

Read More

MVP Award

October 1st, 2014

This morning like so many other SQL Server community members around the world I received an email from Microsoft congratulating me on being award the Microsoft MVP Award – SQL Server for 2014. This is my first time being awarded this honor and I am humbled to be a recipient of this award. For my fellow first time award recipients I congratulate you all for the hard and tireless work you have been undertaking in the SQL Server community. Aside from myself and my fellow first-timers a big congratulations must also go out to the many more who received this award again. This is testament to the fact that there are so many people who are willing to provide to the SQL Server community to make it better for everyone.

Read More

SQLSaturday #352–Sydney

September 16th, 2014

Well SQLSaturday is on again in Sydney with SQLSaturday #352 being held on Saturday 25th October, 2014 at the University of Sydney. SQLSaturday provides a day of free SQL & BI training from some of Australia’s SQL Server Community enthusiasts.

Read More

Kerberos Authentication to your SQL Server Instance

September 1st, 2014

Kerberos Authentication protocol setup for your SQL ServerReporting Services environment can cause you some issues. In this article we are having a look at the steps that need to be followed to prevent your Double-hop issues happening.

Read More
0

Your Cart