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…

T-SQL Tip: Inserting Leading Characters to a String

This post, is actually a T-SQL tip, on how to easily insert leading characters to a string. The Scenario for Inserting Leading Characters Consider that  you have a fixed-length table column for which you want to add leading characters, so that all its records, values with the same number of characters. How to Insert Leading … Read more…