A few days ago I started writing an article that it would provide a set of useful tips on SQL Server topics that are met in the everyday life of DBA/Database Developer. The article is now completed and you can find it below! It is organized in the following categories: Solutions…
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…
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…
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…
MCTS: SQL Server 2008, Database Development
Today I managed to pass the Microsoft Exam 70-433 – TS: Microsoft SQL Server 2008, Database Development and thus I got my third MCTS certification on SQL Server 🙂 This exam was all about database development using SQL Server 2008. While studying for the exam, I had the chance to…
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.…
24 Hours of PASS!
I got asked to present a one-hour SQL Server development session during the “24 Hours of PASS” event which starts on September 2, 2009, 00:00 GMT. The “24 Hours of PASS” is a series of live one-hour webcasts broadcast over a 24 hour period that focus on various SQL Server…
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…
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…
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…
Screencast: Using Inheritance in the ADO .NET Entity Framework
Welcome to another screencast dedicated to SQL Server 2008 Programmability! This screencast again features the ADO .NET Entity Framework. The screencast demonstrates how the developer can create an entity data model in Visual Studio 2008, and goes one step further, thus demonstrating a simple way of using inheritance in the…
Renaming Windows Logins in SQL Server
When a DBA creates Windows Logins in SQL Server, the format of these logins is: [Domain or Server Name][Windows Username] [Domain] can also be the local Server name if the user is a local Windows User. In the case where the Server name changes and the Windows Login names remain…
Screencast: How to Create an Entity Data Model
Welcome to my first screencast dedicate to SQL Server 2008 Programmability! This screencast features the ADO .NET Entity Framework; a new feature of Microsoft .NET Framework 3.5 providing the developer with fast, robust and scalable data access. SQL Server 2008 fully supports the ADO .NET Entity Framework, allowing developers to…