Upcoming CDNUG Event, May 13th: Microsoft SharePoint Feature Areas

At Cyprus .NET User Group (CDNUG), we focus on Microsoft .NET and SQL Server technologies (for more information please read about CDNUG). We organize regular monthly events on the above technologies which, of course, are free to the public.This month’s event (May, 2009) is dedicated to Microsoft SharePoint Technologies.See below for event-specific details:——————————————————————–Topic: Microsoft SharePoint … Read more…

tempdb growth

As its names implies, the tempdb database contains temporary data that is created during SQL Server operations, therefore, the tempdb growth is one significant issue that needs to be properly managed in SQL Server. Temporary data stored in tempdb system database Temporary data stored in temdb may include: temporary user objects (i.e. temporary tables, cursors), … Read more…

INETA Europe on Twitter!

INETA Europe is now on Twitter! For keeping yourself up-to-date with all the latest activities of INETA Europe you can start following INETA Europe on Twitter! http://twitter.com/INETA_EU By following INETA Europe on Twitter you have the chance to directly get information about the latest events and contests supported by INETA Europe and much more!

Where are temporary tables stored in SQL Server?

Many people ask: “Where are temporary tables stored in SQL Server?” and that’s a very good question. There are many cases where we need to create temporary tables in SQL Server and for various reasons. Such reasons may include: Breaking the logic of a large and complex SQL Statement in smaller portions of code. Increase the … Read more…

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…

SQL Server 2008 Service Pack 1

SQL Server 2008 Service Pack 1 was just released yesterday (April 7, 2009). Along with the fixes for known bugs, this Service Pack also adds some new functionality to SQL Server 2008 mainly from the DBA’s perspective. What’s new Microsoft has added new functionality to SQL Server with this service pack. The main new features … 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

This article, in an introduction to ADO .NET Entity Framework, Entity Data Model and gives an overview of this great technology.   The Problem ADO .NET Entity Framework Solves 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 … Read more…

uCertify PrepKit (070-443) Review

I was recently asked to review one of the products of uCertify company. uCertify provides IT certification preparation PrepKits for a large number of vendors. To this end, I was given a copy of PrepKit 070-443 which is for the corresponding Microsoft Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server … 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…

I am an INETA Country Leader

Today I have officially received the role of the INETA Country Leader for Cyprus. It was an honour for me to receive this role as it will allow me to further promote the .NET community activity in Cyprus. The main responsibility of this role is to supervise INETA User Groups in Cyprus and to promote … Read more…