The feature you are trying to use is on a network resource that is unavailable

Under certain circumstances, it might happen when trying to add a feature to an existing SQL Server installation (i.e. adding SQL Server Integration Services), to get the following error message: “The feature you are trying to use is on a network resource that is unavailable“. The above error message, might be referring to Microsoft SQL … Read more…

SQL Server Installation and Setup Best Practices

Installing SQL Server, especially on standalone servers, is a relatively easy process. However, efficiently installing SQL Server, is a whole different story. Via this article, I will be sharing with you, some useful tips regarding SQL Server Installation and Setup Best Practices. The list of best practices presented in this article, is not exhaustive, but … Read more…

How to Find the OS Version of your SQL Server Machine – Single vs Many Machines

Finding the Windows OS version of a single SQL Server machine is easy. There many ways you can do it. However, what about when you work with hundreds of SQL Server instances? How can you efficiently generate a report with the OS versions? This article discusses some of the methods you can use to find … Read more…

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 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…

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…