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, 120 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, 541 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, 5,839 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, 97 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, 133 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, 6,517 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,949 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, 26 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, 101 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, 129 reads

Posted in WaterOx SQL on 18 September 2014

Export a SSMS Query Result Set to CSV

Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.

The simplest way is to select all results and then copy & paste them into whichever… Read more

1 comments, 732 reads

Posted in WaterOx SQL on 19 August 2014

Live 360 Discount Code & Helping Digby!

Join me at SQL Live 360 this November!

I am hugely excited to have been selected to present at Live 360, November 17 – 21 in Orlando, FL.

Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current… Read more

0 comments, 160 reads

Posted in WaterOx SQL on 5 August 2014

Null Values in SQL Server

Walk & Talk #001 – Unknown or Null Values

Ride with us in this video as we head to Richmond, Virginia to present to their user group.

This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.

Through this video we talk about and… Read more

1 comments, 162 reads

Posted in WaterOx SQL on 21 July 2014

Whitelist a Set of IP Addresses in SQL Server

Blacklist vs Whitelist

Are you on the Whitelist?

I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.

If not, the easiest way I can summarize them is as follows:

A blacklist is a list of what can not access something you… Read more

1 comments, 259 reads

Posted in WaterOx SQL on 14 July 2014

How Critical is a Demo?

Do you always need a demo?

Is a demo always needed?

One of my more popular presentations I have been doing as of late is my “The Spy Who Loathed Me – An Intro to SQL Server Security” one. What is intriguing as that is is completely demo… Read more

1 comments, 146 reads

Posted in WaterOx SQL on 3 July 2014

Announcing SQL Summer Camp

A new way to train in SQL Server.

 

I had an idea a few years back about a training event unlike any other. One where you could bring family, all have fun, and yet still learn about SQL Server from top people in the industry. After years of working… Read more

1 comments, 208 reads

Posted in WaterOx SQL on 2 June 2014

We’re All Mad Here!

The title says it all!

I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited to be going back, and add another tick mark to the list of events we have been to. In reviewing recent and upcoming events though, I have come… Read more

1 comments, 171 reads

Posted in WaterOx SQL on 9 May 2014

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption]

SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290

As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.

Enterprise Edition

Read more

1 comments, 2,370 reads

Posted in WaterOx SQL on 22 April 2014

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp Read more

1 comments, 336 reads

Posted in WaterOx SQL on 15 April 2014

When Data Should Walk Out The Door

What would you do?

What would your reaction be if, one day, all that old data you’ve been holding onto for years suddenly got up and walked out?

I’m not talking about unsecured data being hacked, personnel issues, malware in your network, or even HVAC systems with too much access… Read more

1 comments, 1,301 reads

Posted in WaterOx SQL on 18 March 2014

Older posts