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.

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutes

I had a project once that was using change data capture (CDC)...

The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting.

Read more

0 comments, 74 reads

Posted in WaterOx SQL on 27 May 2015

004 – Cracked Foundation - WaterOx Consulting

Reading Time: 4 minutes

Do You Have a Cracked Foundation? in WOxPod!, episode # 004 –...

The post 004 – Cracked Foundation appeared first on WaterOx Consulting.

Read more

1 comments, 143 reads

Posted in WaterOx SQL on 22 May 2015

SQL F.A.D. – Daily Identity Reset - WaterOx Consulting

Reading Time: 3 minutes

Sometimes you have to do some things considered pretty strange in your...

The post SQL F.A.D. – Daily Identity Reset appeared first on WaterOx Consulting.

Read more

1 comments, 107 reads

Posted in WaterOx SQL on 20 May 2015

003 – The Data Guild - WaterOx Consulting

Reading Time: 5 minutes

Are you an Apprentice DBA? in WOxPod!, episode # 003 – The...

The post 003 – The Data Guild appeared first on WaterOx Consulting.

Read more

0 comments, 176 reads

Posted in WaterOx SQL on 15 May 2015

SQL F.A.D. – Average Transactions Per Day - WaterOx Consulting

Reading Time: 2 minutes

Sometimes Fast & Dirty is OK. Other times, not so much. Sometimes...

The post SQL F.A.D. – Average Transactions Per Day appeared first on WaterOx Consulting.

Read more

2 comments, 2,892 reads

Posted in WaterOx SQL on 13 May 2015

002 – SQL Server 2016 - WaterOx Consulting

Reading Time: 1 minutes

It is official! The next version of SQL Server will be SQL...

The post 002 – SQL Server 2016 appeared first on WaterOx Consulting.

Read more

0 comments, 179 reads

Posted in WaterOx SQL on 8 May 2015

Identity Removal - WaterOx Consulting

Reading Time: 2 minutes

Men In Black are not the only ones that can remove an...

The post Identity Removal appeared first on WaterOx Consulting.

Read more

3 comments, 4,183 reads

Posted in WaterOx SQL on 6 May 2015

They Can Do What? – SHUTDOWN - WaterOx Consulting

Reading Time: 1 minutes

Many times the DBA is faced with the dilemma of granting excessive...

The post They Can Do What? – SHUTDOWN appeared first on WaterOx Consulting.

Read more

3 comments, 163 reads

Posted in WaterOx SQL on 29 April 2015

How Many SQL Log Files Do You Keep? - WaterOx Consulting

Reading Time: 2 minutes

Ever have this happen? You (on vacation): I’ll have another piña colada...

The post How Many SQL Log Files Do You Keep? appeared first on WaterOx Consulting.

Read more

2 comments, 5,042 reads

Posted in WaterOx SQL on 22 April 2015

Quickly Check If SSL For SQL Is Enabled - WaterOx Consulting

Reading Time: 2 minutes

To quickly check SSL is configured on your SQL Server you can...

The post Quickly Check If SSL For SQL Is Enabled appeared first on WaterOx Consulting.

Read more

1 comments, 225 reads

Posted in WaterOx SQL on 15 April 2015

Can an EKM Save The World of Data? - WaterOx Consulting

Reading Time: 4 minutes

Quis custodiet ipsos custodes? Who will guard the guards themselves? – Latin...

The post Can an EKM Save The World of Data? appeared first on WaterOx Consulting.

Read more

1 comments, 6,283 reads

Posted in WaterOx SQL on 10 March 2015

Data Size – LEN() vs DATALENGTH() - WaterOx Consulting

Reading Time: 3 minutes

  No. It isn’t just the way you use your data that...

The post Data Size – LEN() vs DATALENGTH() appeared first on WaterOx Consulting.

Read more

6 comments, 6,061 reads

Posted in WaterOx SQL on 4 March 2015

Gimme A Break! Taking Mental Health Days - WaterOx Consulting

Reading Time: 3 minutes

  Burnout! You have been stressing over the big project you have...

The post Gimme A Break! Taking Mental Health Days appeared first on WaterOx Consulting.

Read more

1 comments, 859 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, 7,104 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, 175 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, 162 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, 166 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, 309 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, 241 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, 61 reads

Posted in WaterOx SQL on 21 November 2014

Older posts