SQL Server 2008

Upcoming CDNUG Event – Microsoft and Openness / Clustering in SQL Server 2008

Cyprus .NET User Group (CDNUG) brings another event to you, by/for the Community! This month’s event features two sessions: Microsoft and Openness Clustering in SQL Server 2008 The first session, with speaker Andreas Hadjipanayi (Technical Account Manager at the local Microsoft Office in Cyprus) discusses how Microsoft has become more open…

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…