Infographic: An Introduction to Entity Framework

Hi folks! In this post, I’m sharing with you a useful infographic I created for my Online Course “Entity Framework: Getting Started (Complete Beginners Guide)“. This infographic, provides a quick overview of the Entity Framework in .NET, it describes what it is, how it works and what are its workflows that allow you to build … Read more…

Microsoft SSIS Service failed to start. Configuration system failed to initialize

About the “Microsoft SSIS Service failed to start” Issue It happened at some point to encounter problems with SQL Server Integration Services 11.0 (SSIS) not being able to start. This occurred on a Windows 2008 R2 server that has been regularly patched. After checking in Windows Event Viewer, I found the exact error message which … Read more…

SQL Server Index Rebuild Scripts

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…

Selected Tweets and Retweets of 2017

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…

Let’s Build Together a Great SQL Server and .NET Community

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…

Locking and Blocking in SQL Server

This article is from my book: 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 RDBMS ensures that no actions of committed transactions are lost. This is … Read more…

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.   Main Limitations of SQL Server Express Editions The Express Editions of SQL Server, even free, as expected, have … 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…