SQL Server Programmability

Screencast: Object Dependencies in SQL Server 2008

SQL Server 2008 introduces among other new features and enhancements for accurately tracking Object Dependencies. This is very useful especially in cases where the user wishes to programmatically modify database objects having dependencies and therefore, he/she needs to resolve these dependencies before being able to proceed with the database object…

Webcast on SQL Server 2008 T-SQL Enhancements Now Publicly Available!

A few days ago I delivered a Live Webcast on Microsoft SQL Server 2008 Programmability and more specifically on T-SQL Enhancements. During the Webcast I talked about the following SQL Server 2008 Programmability features: Variables Declaration and Initialization Compound Assignment Operators Large UDTs DATE, TIME, DATETIME2 New & Enhanced Functions…

New Date-Related Functions in SQL Server 2008

Along with the new data types DATE, TIME and DATETIME2 in SQL Server 2008, new and enhanced functions are also included. These functions are: SYSDATETIME SYSUTCDATETIME SYSDATETIMEOFFSET SWITCHOFFSET TODATETIMEOFFSET A more thorough explanation follows: SYSDATETIME——————This function is like the GETDATE function with the difference that it returns the current date…