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.

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, 156 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, 6 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, 8 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, 599 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,093 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, 6 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, 7 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, 116 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, 162 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, 8 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, 5 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,694 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, 5,997 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, 5 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

12 comments, 8 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, 45 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, 114 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, 9 reads

Posted in WaterOx SQL on 30 September 2014

Video: Walk & Talk #002 – RTO

Recovery Time Objective (RTO)

What is it and why does it matter?

I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server.

Location: American Chestnut Land Trust – South Side Trail: Gravatt Lane (0.72 miles… Read more

1 comments, 5 reads

Posted in WaterOx SQL on 18 September 2014

Video: Walk & Talk #002 – RTO

Recovery Time Objective (RTO)

What is it and why does it matter?

I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server.

Location: American Chestnut Land Trust – South Side Trail: Gravatt Lane (0.72 miles… Read more

1 comments, 140 reads

Posted in WaterOx SQL on 18 September 2014

Older posts