November 12, 2013 – Ramblings of a Crafty DBA

DATEPART() Function – Month

November 12, 2013April 20, 2016 admin

I am going to pick up speed with my series 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…

Providence – SQL Server User Group

November 12, 2013April 21, 2016 admin

I am driving thru America’s Renaissance City, Providence Rhode Island, to present to the Southern New England SQL Server User Group (SNESSUG) on November 13, 2013. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. 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…