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.

Export a SSMS Query Result Set to CSV

Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.

The simplest way is to select all results and then copy & paste them into whichever… Read more

1 comments, 159 reads

Posted in WaterOx SQL on 19 August 2014

Live 360 Discount Code & Helping Digby!

Join me at SQL Live 360 this November!

I am hugely excited to have been selected to present at Live 360, November 17 – 21 in Orlando, FL.

Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current… Read more

0 comments, 112 reads

Posted in WaterOx SQL on 5 August 2014

Null Values in SQL Server

Walk & Talk #001 – Unknown or Null Values

Ride with us in this video as we head to Richmond, Virginia to present to their user group.

This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.

Through this video we talk about and… Read more

1 comments, 118 reads

Posted in WaterOx SQL on 21 July 2014

Whitelist a Set of IP Addresses in SQL Server

Blacklist vs Whitelist

Are you on the Whitelist?

I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.

If not, the easiest way I can summarize them is as follows:

A blacklist is a list of what can not access something you… Read more

1 comments, 176 reads

Posted in WaterOx SQL on 14 July 2014

How Critical is a Demo?

Do you always need a demo?

Is a demo always needed?

One of my more popular presentations I have been doing as of late is my “The Spy Who Loathed Me – An Intro to SQL Server Security” one. What is intriguing as that is is completely demo… Read more

1 comments, 110 reads

Posted in WaterOx SQL on 3 July 2014

Announcing SQL Summer Camp

A new way to train in SQL Server.

 

I had an idea a few years back about a training event unlike any other. One where you could bring family, all have fun, and yet still learn about SQL Server from top people in the industry. After years of working… Read more

1 comments, 151 reads

Posted in WaterOx SQL on 2 June 2014

We’re All Mad Here!

The title says it all!

I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited to be going back, and add another tick mark to the list of events we have been to. In reviewing recent and upcoming events though, I have come… Read more

1 comments, 129 reads

Posted in WaterOx SQL on 9 May 2014

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption]

SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290

As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.

Enterprise Edition

Read more

1 comments, 1,252 reads

Posted in WaterOx SQL on 22 April 2014

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, 264 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,234 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, 421 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, 111 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, 212 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, 281 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, 121 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, 217 reads

Posted in WaterOx SQL on 5 October 2012