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 over time. The major discussion … Read more…

Product Review: SQL Search – Searching for SQL Text Within SQL Server DB Objects

Some time ago Red Gate released SQL Search, a SSMS add-in that allows the user to search for fragments of text within database objects in a SQL Server instance! Yes, I know, this is cool! 🙂 There are many scenarios where the tool can come in handy. For example, imagine trying to perform a modification … Read more…

Using the OUTPUT Clause: A simple data archiving example

The OUTPUT Clause in T-SQL as described in MSDN SQL Server BOL, “returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement.“ The functionality provided by the OUTPUT clause is very powerful and can be used in many scenarios. One such a scenario is Data Archiving. Consider … Read more…

Mysore PASS Chapter SQL Server Webcasts Series

Newsflash: More free SQL Server training is on the way! The Mysore/Mandya Technology Group (MY-TG) organizes a series of SQL Server Webcasts which started on Saturday, September 12th, 2009 and will be taking place every Saturday for the next few weeks. To this end, every Saturday, two sessions are presented. Topics include SQL Server 2008 … Read more…

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 modification. For efficiently tracking dependencies … Read more…

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 supporting DATETIME2 Precision Table Value … Read more…

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 and time with the precision … Read more…

Live Webcast Announcement – SQL Server 2008 Programmability

One of the things that inspires me the most in SQL Server, is the continuous enhancement of its programmability features like Data Access (Entity Framework and Data Services support), Visual Studio Integration, LINQ, Sync Framework, Project “Velocity” and of course, T-SQL Enhancements. So I think that it is time for a Live Webcast! On Wednesday, … Read more…

SQL Server 2008 Collation Alignment with Windows Server 2008

SQL Server 2008 is fully aligned with the collations in Windows Server 2008.To this end, it has 80 new collations which are denoted by *_100 version references. The total number of variations for these collations exceeds 1400.The purpose of this enhancement is to provide users with the most up-to-date and linguistically accurate cultural sorting conventions. … Read more…

Installing 32-bit SQL Server 2005 Reporting Services on a 64-bit machine/Windows OS

Is it possible to install 32-bit SQL Server 2005 Reporting Services on a 64-bit Computer/Windows OS while keeping the 64-bit version of the rest of SQL Server features? The answer is yes! Well, here’s the story: I recently installed SQL Server 2005 on a 64-bit Windows Server 2003 OS.This was done within the context of … Read more…

The Entity Framework – Part 2 – Inheritance

As promised on my previous Entity Framework-related post I will try through a series of posts which will contain examples, to talk about the ADO. NET Entity Framework and all the cool features it provides the developer with. This post discusses about one of those features; Inheritance. Inheritance allows creating entities having as base type … Read more…