Database Maintenance in SQL Server 2005 Express – Integrity
September 2nd, 2011
Following on from my Blog on SQL Server Agent for SQL Server 2005 Express, this post is to run you..
Read More
Database Maintenance in SQL Server 2005 Express – Recoverability
August 28th, 2011
The recoverability of your databases is probably the most important thing you need to be thinking about when you are..
SQL Server Agent for SQL Server 2005 Express
August 28th, 2011
With the prevalence of DotNetNuke DNN out there in the community and the large numbers of people utilising hosted solutions..
SQL Server 2008 SP3 CTP
August 24th, 2011
Microsoft has released Service Pack 3 CTP for you to download as of 22 August 2011. The download of SP3..
SQL Server 2008 R2 SP1 CU1
July 22nd, 2011
Microsoft released the first Cumulative Update – CU1 for Service Pack 1 on the July 18 2011. Cumulative Update 1..
SQL Server 2008 R2 SP1 RTM
July 14th, 2011
Microsoft has released Service Pack 1 RTM for you to download as of 11 July 2011. If you want to..
Alter Index Vs DBCC IndexDefrag Vs DBCC DBReIndex
June 13th, 2011
DBCC IndexDefrag & DBCC DBReIndex are deprecated features in the next version of SQL Server. This blog has a look..
SQL Server Compression Estimator Tool
May 12th, 2011
On Monday 9th May 2011 the release of the SQL Server Compression Estimator Tool was made available on Codeplex for..
SQLDiag Configuration Tool
May 1st, 2011
A new tool became available on the 27th April 2011 and is available for download from Codeplex . This tool..
Failed :(0) Alter failed for server “ComputerName\Instance”;
April 20th, 2011
Being on-call I received an alert for a client with the following message – ‘The following jobs(s) failed to execute..
Reading large SQL Server error log files
February 27th, 2011
SQL Server error logs can grow quite large due to an issue or from infrequent cycling of the log file. If these log files get to large then you are not able to read the contents either through SSMS or a file editor. This blog takes you through how to read the log using xp_readerrorlog.
SQL Server 2005 SP4 RTM
December 20th, 2010
SQL Server 2005 SP4 RTM was made available on December-17-2010. If you want to stay up to date with your..
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.
Search
Recent Posts
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQL Server 2025 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized