Tag: John F. Miner III

DATETIMEFROMPARTS() – Date/Time Function

admin

I am fixed on writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

SMALLDATETIMEFROMPARTS() – Date/Time Function

admin

I am steadfast in writing another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

DATEFROMPARTS() – Date/Time Function

admin

I am determined to write another short articles or tidbits on Transaction SQL date/time functions. In software engineering, the presentation layer, the business logic layer, and the data access layer might be written using different technologies and on different servers. For instance, Web Forms (ASP.NET) might be used in the presentation layer, Web Services (C#.NET) might implement the business application layer, and SQL Server (TSQL) might constitute the data access layer. With this design, the application (presentation tier) might have the end user choose month, day and year from a…

DATEPART() Function – Time Zone Offset

admin

I am decisive to write another 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 be passed to…

DATEPART() Function – Subseconds

admin

I am firm in my decision to write another 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…

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…

DATEPART() Function – Minute

admin

I am going to plug away 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…

DATEPART() Function – Hour

admin

I am going to perpetuate my 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 be…

DATEPART() Function – Day of week

admin

I am going to endure the journey of writing more 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…