Configure DBMail for SQLExpress on Windows Azure

By Warwick Rudd on 8/13/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.

IIS 6.0
SQL Server Express

Site Redirection with DNN Extension URL Providers

By Warwick Rudd on 8/13/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.

DNN Extensions
DNN Url Redirect Provider
Site Redirection
SQL Server Express

T-SQL Tuesday #57 – SQL Family and community

By Warwick Rudd on 8/12/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.

SQL Family
T-SQL Tuesday

SSRS 2008 R2 Menu Drop Downs

By Warwick Rudd on 8/9/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:

SQL Server 2008 R2
Reporting Services
SQL Server 2008 R2
SQL Server Reporting Services

T-SQL Tuesday #56 – Index Assumptions

By Warwick Rudd on 7/8/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.

Clustered Indexes
Non Clustered Indexes
T-SQL Tuesday

DNN 7.03.01 CMS Platform Upgrade

By Warwick Rudd on 7/3/2014

Every now and again I do a post about DNN as this is the platform that my site runs on. Some of you may be aware that recently there was a new version released on codeplex. Version 7.3.1 – Version Upgrade is available for download if you are running on a previous versions and would like to upgrade your site. If you would like an easy upgrade then you can follow along with the steps I have outlined in this post.

7.03.01 Upgrade
7.3.1 Upgrade
DNN 7.03.01
DNN 7.03.01 Upgrade
DNN 7.3.1 Upgrade

SQL Server Support for SysPrep

By Warwick Rudd on 6/17/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.

SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Service Packs
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Performance Analysis of Logs V2.5

By Warwick Rudd on 5/30/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.

Performance Analysis
Performance Analysis of Logs

SQL Server 2008 Service Pack Plans

By Warwick Rudd on 5/29/2014

Microsoft have announced the plans for the last Service Packs for SQL Server 2008 and SQL Server 2008 R2 to be released after the end of mainstream support for both of these versions come July 8, 2014. You can find out more about what this means for you.

SQL Server 2008
SQL Server 2008 R2
Service Packs
2008 R2 SP2
Service Packs
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 R2 SP3
SQL Server 2008 SP3
SQL Server 2008 SP4

Performance Eye for the SQL Guy – Part 5

By Warwick Rudd on 5/21/2014

With the release of SQL Server 2014, there are few features which can help improve with the performance of your SQL Server environments. Over this 5 part series I will take you through a high level overview of these features. Part 5 of this series are are looking at Managed Lock Priority & Single Partition Online Index Rebuild.

SQL Server 2014
Index Rebuild
Managed Lock Priority
Single Partition Online Index Rebuild
SQL Server 2014
Scroll to Top