Main Limitations of SQL Server Express Editions

SQL Server Express Editions are a handy solution for small businesses with small databases with no special requirements about performance, high availability, encryption, etc. This article discusses about the main limitations of SQL Server Express Editions. What are the Main Limitations of SQL Server Express Editions? The Express Editions of SQL Server, even free, as … Read more…

What are Exactly Orphaned Users in SQL Server?

In this article, we will be discussing about orphaned users in SQL Server.   What is an Orphaned User in SQL Server? An orphaned user in SQL Server, is a user that exists in a database (Database-Security-Users) but for any reason, does not have a corresponding login in the instance’s security (master database).   Why … Read more…

Operating System Requirements for all SQL Server Versions and Editions

SQL Server is the world’s most powerful data platform and it is constantly evolving. From release to release significant new features are added. Besides the features and functionality, one of the typical question DBAs have is which are the Operating System requirements for each version and edition of SQL Server. In this post you can … Read more…

Selected Tweets of Year 2015!

Another year has passed…as always, full of everything! Events, articles, direct communication with you, my fellow SQL Server community members, via different online and offline channels, software and book releases and many other activities! Among my blog and journal articles, user group/conference events, tweets and software and book releases, I feel that two of my … Read more…

My eBook Series on SQL Server Performance, Administration and Development

Earlier this month I have released the third and last book of my “ebook series” on SQL Server administration, development and performance. Through this three-book series, I share my experiences with SQL Server on the below areas: Tuning Administration Development and Data Access Feel free to check it out! SQL Server eBook Releases:   Title: … Read more…

My eBook Titled “Developing with SQL Server” is Now Out!

Yesterday, I released my third book on SQL Server, titled ‘Developing with SQL Server’ and it is dedicated to SQL Server development but don’t worry, there are more books to come! 🙂 This book is for database developers and architects who develop SQL Server databases and related database processes. The book features tens of articles … Read more…

Microsoft SQL Server MVP for the 7th Year in a Row!

Today, a while ago, I have received that special email from Microsoft informing me that I was awarded with the Microsoft Most Valuable Professional (MVP) Award: ————- Dear Artemakis Artemiou,Congratulations! We are pleased to present you with the 2015 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their … Read more…

Selected Tweets of Year 2013!

Another year has come to an end. Being faithful to the “tradition” of posting the last day of every year my selected tweets for the year that ends, here I am again, posting the “Selected Tweets of Year 2013!”. 2013 was remarkable, especially when it comes to Community. Interacting with you, the SQL Server Community … Read more…

Monitoring Locking in SQL Server

SQL Server 2005 or later has a specific dynamic management view (DMV) which provides detailed information regarding the active locks within the SQL Server instance that is, locks that have been already granted or they are waiting to be granted. The DMV is called: sys.dm_tran_locks. The following T-SQL query uses sys.dm_tran_locks in order to return … Read more…

Massively Detaching and Re-attaching Databases in SQL Server

In this article, we will be discussing about massively detaching and re-attaching databases in SQL Server.   Why massively detaching and re-attaching all the databases in a SQL Server instance? There are cases where you might need to massively detach and re-attach all the databases in a SQL Server instance. Such scenario can be a … Read more…