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.

Friends of Redgate 2015

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 added me to the… Read more

0 comments, 55 reads

Posted in WaterOx SQL on 27 January 2015

Identify Primary Keys That Are Not Identity Columns

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 are a requirement to… Read more

1 comments, 109 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, 181 reads

Posted in WaterOx SQL on 21 November 2014

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, 17 reads

Posted in WaterOx SQL on 21 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, 31 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, 623 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,153 reads

Posted in WaterOx SQL on 7 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, 21 reads

Posted in WaterOx SQL on 7 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, 22 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, 132 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, 211 reads

Posted in WaterOx SQL on 31 October 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, 28 reads

Posted in WaterOx SQL on 31 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, 18 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,803 reads

Posted in WaterOx SQL on 24 October 2014

Untrusted Foreign Keys

  What is a Foreign Key?

Do you trust your foreign keys?

A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.

For example, if you have an order and a customer table, there is probably a logical relationship between the 2… Read more

1 comments, 6,141 reads

Posted in WaterOx SQL on 17 October 2014

Untrusted Foreign Keys

  What is a Foreign Key?

Do you trust your foreign keys?

A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.

For example, if you have an order and a customer table, there is probably a logical relationship between the 2… Read more

1 comments, 17 reads

Posted in WaterOx SQL on 17 October 2014

I Must Be Doing Something Right – MVP Award

I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.

For those that know what this whole MVP thing is there isn’t much more to say other than the headline:

I must be doing something right!

and

Yay!

 

For… Read more

14 comments, 39 reads

Posted in WaterOx SQL on 30 September 2014

I Must Be Doing Something Right – MVP Award

I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.

For those that know what this whole MVP thing is there isn’t much more to say other than the headline:

I must be doing something right!

and

Yay!

 

For… Read more

12 comments, 67 reads

Posted in WaterOx SQL on 30 September 2014

Video: Walk & Talk #003 – RPO

What is the RPO?

And why does it matter?

Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server.

Location: Jefferson Patterson Park

More info: http://www.jefpat.org/

Read the full article here

The post Video:… Read more

1 comments, 129 reads

Posted in WaterOx SQL on 30 September 2014

Video: Walk & Talk #003 – RPO

What is the RPO?

And why does it matter?

Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server.

Location: Jefferson Patterson Park

More info: http://www.jefpat.org/

Read the full article here

The post Video:… Read more

1 comments, 35 reads

Posted in WaterOx SQL on 30 September 2014

Older posts