Excellence in SQL Server

Over the years i have worked or consulted to a lot of organisations. One of the more frustrating things to see is disparate development,...

I am not going to lecture anybody about having PI or sensitive data from production on any of your non prod servers. Over the years I...

Whilst doing a routine check of some SQL Servers I came across the following login failure message. Login failed for user...

On production SQL Servers I usually like to deadlock trace flags -T1204 and -T1222 as startup parameters. When I review SQL Servers and I...

When most DBA's think of monitoring they think of monitoring their SQL Server database servers. They may have tools such as SQL Sentry,...

I was asked to look at a logical database design just for a sanity check and make sure it all made sense. It was a good design with...

This is the continuation of previous blogs on creating a Unifi wireless network. Now that we have all of our equipment and cables we can...

This is the continuation of previous blogs on establishing a wireless network with QoS and internet management capability. We are looking...

In my previous blog I wrote about my friends need for better control and granularity over their wireless network and the best solution...

A friend of mine has a holiday house about 2 hours out of the city in a valley. No mobile phone reception and only a satellite modem for...

What do you do when you are asked to deal with sensitive data. I was asked by the legal department of a mortgage provider to investigate...

Whilst contracting at an online share trading company, I noticed that 15 minutes before the market opened the senior DBA had a scheduled...

When I started work at a music subscription download service, they had multiple databases. After I sat back for a few weeks it became...

It was a normal work day. Then all of a sudden, nobody could login to the web sites. This affected thousands of customers. There was an...

What would you do if you started a job at a company with the following SQL Server production farm. 16 SQL Servers - none of which are...

I got a call out of the blue from a financial services organisation. They contacted me through a friend of a friend etc. They had found a...

This is the second part of building a private cloud SQL Server infrastructure. The first part was the SQL Server design where there were...

I worked on a project for a very large financial organisation that effectively was building a private cloud SQL Server infrastructure....

Recently I read about the outage at Basecamp 3 that occurred when they ran out of integers. https://m.signalvnoise.com/update-on-basecamp...

For a medium sized law firm I was asked to take over the weekly database monitoring for 16 production SQL Servers. The person who ran...