Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

WaterOx SQL

Chris Bell (MCITP) has been working with Microsoft technologies for over 20 years and using SQL Server for over 18 of those years. He is currently the Owner and Lead consultant for WaterOx Consulting, a Maryland based company focused on helping clients, that can’t afford or justify a full time data team, get the most from their SQL Server environments. For more information please visit WateroxConsulting.com.

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp Read more

1 comments, 53 reads

Posted in WaterOx SQL on 15 April 2014

When Data Should Walk Out The Door

What would you do?

What would your reaction be if, one day, all that old data you’ve been holding onto for years suddenly got up and walked out?

I’m not talking about unsecured data being hacked, personnel issues, malware in your network, or even HVAC systems with too much access… Read more

1 comments, 1,114 reads

Posted in WaterOx SQL on 18 March 2014

Counting Work Days

Don’t forget that most holiday’s aren’t work days.

Recently while working with a client I was faced with some seriously convoluted code to count the number of days between a couple of dates.

Usually this is not a big issue, a simple datediff() works, but this also had to take… Read more

1 comments, 315 reads

Posted in WaterOx SQL on 21 September 2013

Digby’s Top 10 reasons you need a DBA

Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.

  1. They can handle unexpected database growth with ease
  2. A DBA stays calm in a rapid growth situation

     

     

     

     

     

     

     

     

     

     

     

  3. They will get down and dirty with…

Read more

6 comments, 72 reads

Posted in WaterOx SQL on 21 May 2013

Optimizing Protected Indexes (was Indexing Encrypted Data)

Why bother encrypting?

Riddle me this batman? Why bother to Encrypt?

As a SQL Server DBA I am primarily responsible for making sure my client’s data is protected and available amongst other things. In many cases I have gone to clients and projects to find that sensitive data is not… Read more

4 comments, 144 reads

Posted in WaterOx SQL on 27 February 2013

Type 2 SCD with SQL Merge

I was going through some notes I had from previous projects and came across a sample script for created a Type 2 Slow Changing Dimension (SCD) in a database or data warehouse.
A Type 2 SCD is one where new records are added, but old ones are marked as archived… Read more

1 comments, 154 reads

Posted in WaterOx SQL on 25 January 2013

Gain exclusive control of a database

Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many connections that kept popping up, even after restarts, that they were not able to change the setting.

As a fix I provided the script below.

Basically it uses the active… Read more

1 comments, 74 reads

Posted in WaterOx SQL on 10 October 2012

10-minute SQL: Filtered Delete: join vs. sub-select vs. exist

I was doing some simple tuning of procedures for a client when I came across some delete statements that I wanted to look into some more. They were filtering based on values in a temp table.

In a majority of cases I have come across at clients a row is… Read more

0 comments, 123 reads

Posted in WaterOx SQL on 5 October 2012