Implicit Conversion Fail

Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don’t quite follow decent practices when designing the database or when writing queries or both.

File Maintenance – Cleaning Up Old Files

We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or flat files that are created from one process or another.  And based on this need/desire, we have all come up with a method to help with achieve that goal.

12 Days Of Christmas and SQL

In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will generally begin on Christmas day

New Backup Behavior in SQL 2014

As has been well publicized, today is the official Release To Manufacturing date for SQL Server 2014.  You can read more about all of that here. Something that hasn’t received much word is a new […]

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Reviewing Peers Brokers   […]

Day 3 – Reviewing Peers

This is the third installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Burning Time Remember back in the […]

12 Days of Christmas 2013 Day 2

This is the second installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement Recently I was able to observe […]

On the Twelfth Day…

Bacon wrapped frog legs (twelve of them) for Christmas.  No more drumming for these guys!! What could be better than bacon wrapped frog legs?  Oh yeah, more Virtual lab setup. We will delve into setting […]

On the Eleventh Day…

Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set. Today we will continue to discuss the building of […]

On the Tenth Day…

Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We are now into the final three […]