Categorization of Blog Posts

Sometimes I get asked; “Hey Artemis, are you a SQL Server Administrator or a Developer?” I then answer: “none of the two” 🙂 I would rather prefer calling myself a Data Architect as I believe it is more accurate. In a relevant article I posted a year ago, I talked about the responsibilities of database … Read more…

Eliminating Blank Spaces in SQL Server Tables

In this article, we will be discussing about eliminating blank spaces in SQL Server table records and columns.   About Blank Spaces Blank spaces always needed special handling in many programming languages. This is not an exception in the case of the SQL programming language. In SQL Server, a variety of built-in string functions exist … 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…

Congratulations 2010 Microsoft MVP!‏

Today is a very special day! I am proud to announce that I received the MVP award for the second time in a row! ——————————————————————- Dear Artemakis Artemiou,Congratulations! We are pleased to present you with the 2010 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, … Read more…

Selected Tweets of Year 2009!

This is a rather different post than the usual. As the end of year 2009 approaches, I decided to publish a selected number of tweets I did, grouped into different categories. It was a great experience to communicate with the Community, among other, by using Twitter. Throughout tweeting it was possible to easily and directly … 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…

Product Review: SQL Object Level Recovery Native

One of the many privileges of being a Friend of Red Gate, is that you have the chance to evaluate the company’s products and provide feedback and suggestions. In this post, I provide my review for one of Red Gate’s latest tools; SQL Object Level Recovery Native.   What Does SQL Object Level Recovery Native … Read more…

MY-TG SQL Server Community Series‏ – Session Review (Sync Framework)

On September 19, 2009, I delivered a session with topic the Microsoft Sync Framework, during the Mysore SQL Server Community Series. The exact topic was: “Flexible data synchronization with Microsoft Sync Framework”. Further below I provide a short review for my session and I also provide the PowerPoint presentation along with the source code (C#) … 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…

Undocumented Stored Procedure sp_MSforeachdb

A really neat undocumented SQL Server stored procedure is sp_MSforeachdb. This stored procedure takes as parameters SQL commands which are then executed against all databases on the current SQL Server instance.   Simple Example of sp_MSforeachdb in SQL Server A simple example (“Hello World”-style 🙂 is the following which lists all the databases in the … Read more…

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 effortlessly create entity data models … Read more…