Excellence in SQL Server

If you have a number of jobs that need to run one after another then you could setup individual schedules for each job. The problem here ...

This is the third blog about DR. Whilst contracting at a major international investment bank, I was involved in their DR testing. Every 6...

In part 1 of "DR a simulated disaster # 1", I blogged about a simulated DR with reduced staff. That was a stressful day. Recovering fro...

A few years ago whilst being an FTE at a medium sized financial company, the CEO and the CIO decided to simulate a disaster to test our D...

I was asked the other day how to make sure that all the SQL Server Agent jobs on a production server are the same on the DR server. This ...

SQL Server automatically creates a clustered index on a primary key column/s. You can change this to be a non clustered index if required...

Have you ever had to find out what happened to your SQL Server. Who deleted that data? What event triggered something to happen. Sometime...

Recently I temporarily lost about 60 to 70% of my vision. Everything was blurry and reading/writing was really difficult. What I noticed...

I really like what I have been able to do with my Power BI Desktop prototype. I have now extended its functionality to start a SQL Server...

Have you ever wondered about what trace flags are enabled on your SQL Server. With all the different 'best practices' for tempdb with -T1...

A friend asked me about automating their processes for providing financial information. It was all done in Excel and the input of data w...

Currently I am looking at a database that is getting corrupted regularly. The table in question has over 1.3 billion rows with no cluster...

When you test potential changes to a query, how do you test it to make sure it is reliable and repeatable. One of the most common mistake...

I started doing an installation of SQL Server 2014 on Windows Server 2016 Datacenter. The SQL Server installation iso had been downloaded...

Not many people like writing documentation. DBA's especially. So when you have to document information on your SQL Servers how do you go ...

Having been asked to help build development and test environments in AWS for a client who is looking at moving all of their on premise da...

From recollection, filestream was a feature introduced in SQL Server 2012. I just wonder if it will go the way of some other now abandone...

A rarely used part of SQL Server is its' full text search capabilities. Honestly, it is quite a basic implementation of FTS but it can do...

Steve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...