Day: November 19, 2013

Hartford – SQL Server User Group

admin

I am driving to the Insurance City to present to the Hartford SQL Server User Group on November 19, 2013. To-date, I have not been to Microsoft building in Farmington, CT. It should be quite an adventure. I am looking forward to seeing John Flannery and meeting members of his group. Here is the gritty details of the presentation that I will be covering that night. Topic: How isolated are your sessions? Abstract: Have you ever executed a T-SQL program that crashed due to an integrity error? Upon inspecting the…

DATEPART() Function – Second

admin

I am going to hold fast at writing of short articles or tidbits on Transaction SQL date/time functions. Most, if not all, modern day computer systems collect data which contains dates and times. Not only is it important to know when a sales order came in, but we should fulfill the request using some type of queue (LIFO). If if was a stack (FIFO) implementation, the first person may never get his order! Today, I will be exploring the DATEPART() function. This function has 15 different input parameters that can…