Free TechNet Resources

TechNet and MSDN contain tons of information regarding Microsoft Technologies like: Books Online, Webcasts, Podcasts, White papers, Virtual Labs, Forums and much more! These resources help IT professionals and developers to efficiently use Microsoft Products. This post provides a list of free TechNet Resources. ———-Best Bets———- 1. TechNet Flash newsletter The biweekly TechNet Flash IT … Read more…

Index Fragmentation in SQL Server and How to Manage it

In this article, we will be discussing about index fragmentation in SQL Server and how you can manage it. SQL Server automatically maintains indexes whenever insert, delete, or update operations are performed on the underlying data.   1. The Two Types of Index Fragmentation in SQL Server Though, in the cases where the underlying data … Read more…

Congratulations 2009 Microsoft MVP!

Today I have received a congratulation email from Microsoft announcing that I have been presented with the Microsoft Most Valuable Professional (MVP) Award for SQL Server! I am very happy about this award and I really feel honored. ——————————————————————————— Dear Artemakis Artemiou, Congratulations! We are pleased to present you with the 2009 Microsoft® MVP Award! … Read more…

The ADO .NET Entity Framework

During the development cycle of a database application, the developer may face issues having to do with the fact that the logical (relational) and related infrastructure may not match the application’s needs. This happens as relational schemas are often normalized in such a way, for being able to be shared across multiple applications.   Learn … Read more…

Exclusive access could not be obtained because the database is in use

About the Error Message: “Exclusive access could not be obtained because the database is in use” A very neat feature of SQL Server is the way it lets the DBA to control connections. To this end, you can explicitly control connections with specific commands and methods. Even though this is not usually needed, there are … Read more…

A transport-level error has occurred when sending the request to the server

This post’s purpose is to explain the above connectivity error and ways of resolving it. In some cases (upon “wrong” actions or network problems 🙂 we might get the following error in SQL Server: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 – No process … Read more…

Leadership Award

Today we had our company presentation regarding the financial results of the year 2008. One of the sessions of this meeting were the Employee Awards for 2008. To my pleasant surprise I have received the Leadership Award for the year 2008 “in recognition of accomplishments far exceeding company expectations” and for gaining and applying technical … Read more…