Excellence in SQL Server

Whilst reviewing some queries recently I was using the text column from sys.dm_exec_sql_text using the plan_handle from...

In our consulting travels we don't see a lot of databases that use schemas. Schemas provide a logical grouping, so associated tables can...

A clients servers were having performance issues. As part of the background information we were told that the hosting provider had been...

Do you have a standard naming convention? Most application databases have standard prefixes for tables (tbl_), views (vw_), user stored...

Whilst rewriting a lot of T-SQL code to allow a client to change their report delivery mechanism, what we found is that the current...

The default retention for SQL Server error logs is 6. This may cause issues if there are a number of SQL Server restarts, you could lose...

As part of on going development I was required to run all the database scripts for a new database. This was just less than 300 scripts...

The task is to refactor a large SQL Server database design with over 1100 tables, 3500 stored procedures, 600 views and 500 functions....

We came across a strange issue with a remote application using RDS (Remote Desktop Services). The date and time on one users remote...

The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set...

As I have written about previously, we are in the process of migrating a large amount of SSIS packages to AWS and also upgrading...

We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise...

There are a number of queries widely available that will look at the DMVs and tell you what indexes you may be missing. This is a great...

After weeks of trying I have given up. I have tried everything to get a Docker SQL Server Windows container running on a Windows 10 Pro...

This week I went to the Azure Discovery Day at Microsoft in Sydney. The event was well attended and efficiently run. The presentation...

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose...

Whilst deploying some reports to a new Sharepoint installation I noticed that the global ReportName variable (Globals!ReportName)...

I was asked the other day was there any way to improve the performance of a large number of rows being inserted. My immediate thought was...

Recently we were asked to build a SQL Server cluster. My initial thought was to use some other technology to provide high availability...

We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where...