SQL Server Blog

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

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

Site Redirection with DNN Extension URL Providers

August 12th, 2014

Recently I have been doing a lot of work with my new site and need to do some consolidation work of my old Blog site to have all of my previous blogs redirected to my new site to allow me to keep the links and rankings that had been accumulated on the old site. My friend Bruce Chapman (B|T) wrote a nice little DNN extension – DNN Url Redirect Provider is available for download from codepex.

Read More

T-SQL Tuesday #57 – SQL Family and community

August 11th, 2014

Thank you Jeffrey Verheul (B|T) for hosting this month’s T-SQL Tuesday party. For those of you that do not know T-SQL Tuesday was started by Adam Machanic (B|T) in 2009. If you feel like hosting 1 of these monthly events drop Adam a line. This months topic is SQL Family and community.

Read More

SSRS 2008 R2 Menu Drop Downs

August 8th, 2014

Recently I was working with an instance of SQL Server Reporting Services 2008 R2 and noticed that when logged in using an account that is a member of the Browser Role, that there are some drop down menu items available on Report folders, Reports that were showing the following options being available for me to do:

Read More

T-SQL Tuesday #56 – Index Assumptions

July 8th, 2014

In this months T-SQL Tuesday #56 article I am talking about some assumptions made around Indexing in a SQL Server environment. Indexing is a good practice to undertake but sometimes assumptions around the benefits of those indexes can cause other issues in your environment.

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.


Your Cart