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..
Read More
Microsoft Tech-ED Australia 2011 – Registrations
June 8th, 2011
Microsoft Tech-ED Australia 2011 which is being held on the Gold Coast, QLD from Aug 30 – Sep 2 is..
SQLQuery Stress
May 23rd, 2011
SQLQueryStress is a performance testing tool, which has been designed to allow you to load test individual queries. This tool..
Performance Analysis of Logs Tool
May 23rd, 2011
Are you a SQL Server DBA that from time to time has encountered some sort of performance issues with your..
SQL Server 2008 R2 SP1 CTP
May 18th, 2011
Microsoft has released Service Pack 1 Community Technology Preview for you download as of 22 April 2011. If you want..
SQL Server 2008 R2 Test Data Load Using VS2010
May 16th, 2011
In this blog I am going to give you an insight into how easy it is to generate random data..
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..
Microsoft tech-ed 2011 – Potential Unleashed
May 7th, 2011
Australia's Microsoft Tech-Ed event is on again on the Gold Coast from August 30 – September 2 2011.
Guest user in the MSDB database in SQL Server
May 6th, 2011
Microsoft has released a new KB article on not disabling the guest user in the MSDB. This has been released to counter the recommendations found in BOL.
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..
Windows Server 2008 Cluster Disks Issues
March 3rd, 2011
When building a Windows Server 2008 Stretch cluster you may experience some issues when adding some clustered disk. In this blog I discuss how to get around this issue and how to use cluster.exe to achieve the desired outcome with a working Cluster.
I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.
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