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.

They Can Do What? – SHUTDOWN

Reading Time: 1 minutes

Many times the DBA is faced with the dilemma of granting excessive access to an application or user so it can ‘just work’.

This can cause a lot of problems. There are commands that can be given from T-SQL that can do a lot of damage… Read more

3 comments, 112 reads

Posted in WaterOx SQL on 29 April 2015

How Many SQL Log Files Do You Keep?

Reading Time: 2 minutes

Ever have this happen?

You (on vacation): I’ll have another piña colada please. Yes, in the coconut. Thanks! Hmm, my phone is ringing…..Hello?

Work: There are problems! The database is messing up and being really slow!

: Well, email me the latest log file from SQL… Read more

1 comments, 103 reads

Posted in WaterOx SQL on 22 April 2015

Quickly Check If SSL For SQL Is Enabled

Reading Time: 2 minutes

To quickly check SSL is configured on your SQL Server you can run the following query.

SELECT session_id, encrypt_option
FROM sys.dm_exec_connections

This query dumps the information about the connections to your SQL Server and any of them using a secured connection will have a ‘True’ value… Read more

1 comments, 202 reads

Posted in WaterOx SQL on 15 April 2015

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, 6,241 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,998 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, 819 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,995 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, 161 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, 124 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, 147 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, 280 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, 225 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, 52 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, 68 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, 669 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,255 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, 67 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, 60 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, 181 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, 297 reads

Posted in WaterOx SQL on 31 October 2014

Older posts