Check our collection of high-quality articles on a variety of SQL Server topics. The collection is being regularly updated with new articles.
I have been writing software since I was 10. I enjoy the challenge of solving different problems with the use of simple, yet powerful software tools. My latest initiative in the last few years was SQLArtBits, and before that, Artemiou Data Tools. Via Artemiou Data Tools and SQLArtBits, I have released useful SQL Server tools. … Read more…
This article provides different SQL Server index rebuild scripts. Script 1: Rebuild all indexes in a SQL Server database with specifying the Fill Factor: –Rebuild all indexes in a database –Note: You need to specify the fill factor USE [DatabaseName] GO EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 90)”; GO Script 2: … Read more…
Wow! Another year has passed! Another great year! Full of SQL Server power! Events, blogging, community building, software, webcasts, discussions, tweets, guest article writing, book writing, and more! Besides the intensive blogging and article writing, another major contribution this year, was the transformation of my blog “The SQL Server and .NET Hub” to the “SQLNetHub” portal. SQLNetHub … Read more…
I have started SQLNetHub initially with the name “The SQL Server and .NET Blog” back in 2008 with a passion for SQL Server and the technical community. Today, 9 years later, after hundreds of articles, many webcasts, public speaking, and more, and with even more passion for SQL Server, Azure and related technologies, SQLNetHub is evolving … Read more…
This Article about Locking and Blocking in SQL Server is from my eBook “Tuning SQL Server (Second Edition)” Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The majority of modern relational database management systems (RDBMSs) make use of lock-based concurrency. Lock-based concurrency is the approach based on which the Database Engine of a … Read more…
We are all beginners. We are not experts or gurus. There is no such thing. This is just an illusion. In the end of the day, we are all beginners who constantly learn and evolve. The majority of articles I publish on my blog target topics that could be characterized as intermediate and sometimes advanced. … Read more…
Another year has passed…as always, full of everything! Events, blog posts, articles on well-known online SQL Server journals, software tools, and of course direct communication with you, my fellow SQL Server community members, via all available online and offline channels! This year was very important for me. Besides my blogs and user group events, I … Read more…
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, … Read more…
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…
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…
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…
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…
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…
Software is evolving and certainly SQL Server is not an exception to the rule. Every few years we need to upgrade our databases in order to run on a newer version of SQL Server and take advantage of significant new features that will enhance the operations of our organization. However, upgrading a database to a … Read more…
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…