-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

Archives: 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, 1,210 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, 678 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, 349 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, 8,634 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, 7,179 reads

Posted in WaterOx SQL on 17 October 2014

Untrusted Foreign Keys

Reading Time: 4 minutes

  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… Read more

1 comments, 223 reads

Posted in WaterOx SQL on 17 October 2014