Check our collection of high-quality articles, on a variety of SQL Server 2008 topics. The collection is being regularly updated with new articles.
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…
In this article, we will be discussing about the OUTPUT clause in SQL Server, and how we can use it for creating data archiving mechanisms. What is the OUTPUT Clause in SQL Server? The OUTPUT Clause in T-SQL as described in the relevant MS Docs article, “returns information from, or expressions based on, each … 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. SQL Server 2008 T-SQL Enhancements Webcast’s Agenda 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 … Read more…
Along with the new data types DATE, TIME and DATETIME2 in SQL Server 2008, new and enhanced functions are also included. New Date Functions Added in SQL Server 2008 and Later The new data functions originally added in SQL Server 2008 are : SYSDATETIME SYSUTCDATETIME SYSDATETIMEOFFSET SWITCHOFFSET TODATETIMEOFFSET A more thorough explanation follows: SYSDATETIME This … 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! The Scenario about Installing 32-bit SQL Server 2005 Reporting Services on a 64-bit machine/Windows OS Well, here’s the story: I recently installed … 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 Inheritance in ADO .NET Entity Framework. Inheritance allows creating entities having as base type … Read more…
DBAs and Database Developers always need to test new database-related work before migrating it to Production Environments. To this end, Test/Development Environments are usually set up in order to allow for testing new administration and programmability features of DBMSs (in our case SQL Server 🙂 Though, by only having such an environment set up is … Read more…