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.

Can an EKM Save The World of Data?

Reading Time: 4 minutes

Quis custodiet ipsos custodes?

Who will guard the guards themselves? – Latin

Let’s talk a little about how data is most commonly leaked from a database.

The user.

Now to be really frank and honest, there is not much we can really do about loss of… Read more

1 comments, 5,546 reads

Posted in WaterOx SQL on 10 March 2015

Data Size – LEN() vs DATALENGTH()

Reading Time: 3 minutes

How long is your data?

 

No. It isn’t just the way you use your data that counts, the data size counts too

Ok, let’s get talk a little about some SQL Server basics. Specifically a couple of useful T-SQL functions.

Let’s talk about determining the… Read more

6 comments, 5,557 reads

Posted in WaterOx SQL on 4 March 2015

Gimme A Break! Taking Mental Health Days

Reading Time: 3 minutes

Do you feel like this when you get to work?

  Burnout!

You have been stressing over the big project you have to get done.

You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk.

You start up your system,… Read more

1 comments, 774 reads

Posted in WaterOx SQL on 26 February 2015

Enough Is Enough! Why Do We Have To Be At Risk?

Reading Time: 2 minutes

When Do We Say Enough Is Enough?

Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s personal data. You know, the stuff that can be… Read more

10 comments, 6,953 reads

Posted in WaterOx SQL on 7 February 2015

When Do You Ask for Help?

Reading Time: 3 minutes

Being on the edge of a cliff is a common feeling when running a small business

Stepping Back

I am taking this moment to step back to try to process a few things myself in this post to hopefully gain some clarity.

These are my ramblings… Read more

1 comments, 143 reads

Posted in WaterOx SQL on 30 January 2015

DoD STIGs – Database Security Requirements Guide

Reading Time: 24 minutes

What are the Database SRG DoD Stigs?

The Database Security Requirements Guide, or SRG, is published as a tool to help you improve the security of your information systems.

They were originally intended for use with the Department of Defense Information Systems, but actually contain some… Read more

3 comments, 63 reads

Posted in WaterOx SQL on 27 January 2015

Friends of Redgate 2015

Reading Time: 2 minutes

It’s official, I am in Friends Of Redgate for 2015!

Ok, the last few months have been an absolute whirlwind of activity for me. Back in October I was recognized by Microsoft by joining the ranks of the SQL MVPs out there, and now Redgate has… Read more

0 comments, 124 reads

Posted in WaterOx SQL on 27 January 2015

Identify Primary Keys That Are Not Identity Columns

Reading Time: 3 minutes

Primary Keys help keep your database in balance

Continuing the thoughts of knowing what is going on in your database let’s talk a little bit about primary keys.

Primary Keys

A primary key is one that uniquely identifies a given row in a given table. They… Read more

1 comments, 263 reads

Posted in WaterOx SQL on 13 January 2015

Have We Devalued SQL Server Consulting?

Have we given too much away?

SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s.

Has the value of SQL Server Consulting Diminished?

This is fantastic for anyone who works in SQL… Read more

1 comments, 204 reads

Posted in WaterOx SQL on 21 November 2014

Have We Devalued SQL Server Consulting?

Reading Time: 3 minutes

Have we given too much away?

SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s.

Has the value of SQL Server Consulting Diminished?

This is fantastic for anyone… Read more

1 comments, 38 reads

Posted in WaterOx SQL on 21 November 2014

12 Things To Check With SQL Server To Prepare For Winter

Reading Time: 8 minutes

Winter is coming! Is your SQL Server ready?

There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!”

“Oh my gosh!” you think,… Read more

1 comments, 52 reads

Posted in WaterOx SQL on 14 November 2014

12 Things To Check With SQL Server To Prepare For Winter

Winter is coming! Is your SQL Server ready?

There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!”

“Oh my gosh!” you think, “I’d better pay attention… Read more

1 comments, 654 reads

Posted in WaterOx SQL on 14 November 2014

Versioning In Your SQL Database

What Is The Point of Versioning?

How do you know change occurs in your database?

Now, I’m not talking about version control, I am talking about stamping your database with a version number so you can keep track of how many modifications may be made in an environment not completely… Read more

1 comments, 6,232 reads

Posted in WaterOx SQL on 7 November 2014

Versioning In Your SQL Database

Reading Time: 4 minutes

What Is The Point of Versioning?

How do you know change occurs in your database?

Now, I’m not talking about version control, I am talking about stamping your database with a version number so you can keep track of how many modifications may be made in… Read more

1 comments, 52 reads

Posted in WaterOx SQL on 7 November 2014

When Things Align Unexpectedly

Reading Time: 4 minutes

Things are happening

or: Learning to Not Look a Gift Horse in the Mouth

The stars seem to have aligned. I am sitting in my hotel room in Seattle waiting for the Microsoft MVP Summit to start as a precursor to the PASS Summit later this… Read more

1 comments, 49 reads

Posted in WaterOx SQL on 2 November 2014

When Things Align Unexpectedly

Things are happening

or: Learning to Not Look a Gift Horse in the Mouth

The stars seem to have aligned. I am sitting in my hotel room in Seattle waiting for the Microsoft MVP Summit to start as a precursor to the PASS Summit later this week.

Just a few… Read more

1 comments, 167 reads

Posted in WaterOx SQL on 2 November 2014

Changing Your SQL Server Name

Is the name of your SQL Server correct?

Why Worry About The Server Name In SQL?

When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.

Reporting services can break, Connections… Read more

1 comments, 271 reads

Posted in WaterOx SQL on 31 October 2014

Changing Your SQL Server Name

Reading Time: 2 minutes

Is the name of your SQL Server correct?

Why Worry About The Server Name In SQL?

When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.

Reporting… Read more

1 comments, 54 reads

Posted in WaterOx SQL on 31 October 2014

Find all triggers in a SQL Server Database

Reading Time: 2 minutes

What Are Database Triggers?

Do you know what triggers lurk in your database?

Triggers can be implemented to enforce business rules or referential data integrity in database applications.

There are even triggers that allow data modifications to multiple base tables of a view. I have actually… Read more

3 comments, 36 reads

Posted in WaterOx SQL on 24 October 2014

Find all triggers in a SQL Server Database

What Are Database Triggers?

Do you know what triggers lurk in your database?

Triggers can be implemented to enforce business rules or referential data integrity in database applications.

There are even triggers that allow data modifications to multiple base tables of a view. I have actually used this in the… Read more

3 comments, 6,953 reads

Posted in WaterOx SQL on 24 October 2014

Older posts