Date/Time Functions – GETDATE()

admin

I am going to stick at writing 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! I will be exploring functions that return the current system date and time in a defined…

Date/Time Functions – CURRENT_TIMESTAMP()

admin

I am going to keep going 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! I will be exploring functions that return the current system date and time in a defined…

Date/Time Functions – SYSUTCDATETIME()

admin

I am going to carry on 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! I will be exploring functions that return the current system date and time in a defined…

Date/Time Functions – SYSDATETIMEOFFSET()

admin

I am going to continue 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! I will be exploring functions that return the current system date and time in a defined data type…

Date/Time Functions – SYSDATETIME()

admin

I am going to start a 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! I will be exploring functions that return the current system date and time in a defined data type…

Portsmouth – SQL Server User Group

admin

I am delighted about the opportunity to present to the Seacoast SQL Server User Group on October 28, 2013. I have not been to New Hampshire since SQL Saturday #146. It will be great to see Mike/Jack again and chat with the user group next week. Topic: Effective Data Warehouse Storage Patterns Abstract: Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI). Unexpected information growth in your…

Charlotte – Pass Summit 2013

admin

I just returned to New England after 4 days in Charlotte at Pass Summit 2013. I analogize the conference to going out to eat every hour, some presentations I truly enjoyed; Others did not suit my pallet. Overall, I would rate the event as a total success. Here are some presentations I viewed in chronological order that were definite highlights during my trip.

  I do have a few grips about the event. Most can not be helped by the event organizers. First, the conference hotel rate was all…

Math Functions – RAND()

admin

I am going to wrap up my short articles on non-trigonometric Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. Today, I will be exploring the RAND() function. This function takes an optional seed number in integer format. It returns a pseudo-random float value from 0…

Math Functions – LOG10() vs POWER()

admin

I am going to gain ground on completing my short articles on non-trigonometric Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. Today, I will be exploring the LOG10() and POWER() functions. The common logarithm of number x is the power y to which 10 would…

Math Functions – EXP() vs LOG()

admin

I am going to forge ahead and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the natural logarithm LOG() and exponential EXP() and functions. The natural logarithm is based on the transcendental constant e…