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 to common issues Basic string … Read more…
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…
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…
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…
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 try and learn more on … Read more…
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…
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 topics. The event is free … Read more…
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…
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…
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…
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 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…
We all know the saying: “A picture is worth a thousand words”. Well, what about a video? A screencast maybe? 🙂 Today I am initiating a series of screencasts dedicated to SQL Server Development and Administration – mainly for SQL Server 2008. Blogging is great of course and I will sure continue doing it as … Read more…
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…
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…
