How to Change the Font and Size of Grid or Text Results in SSMS

This is a quick but useful tip, on how to change the font and size of Grid or Text Results in SSMS.   For changing the font and/or size of Grid results in SQL Server Management Studio (SSMS): Within SSMS, navigate to the “Tools” menu, then “Options”, “Fonts and Colors” and select to “Show settings … Read more…

New Free Service: SQL Server OS Requirements Info

Hi friends! Today we announce another new free online service just for you, the SQL Server Community! This new service is titled “SQL Server OS Requirements Info“, and as the name implies, by using this service, you can quickly retrieve useful information, about the OS requirements for any version and edition of SQL Server! You … Read more…

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 friends! 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

In this article, we will be discussing about the error message: “Microsoft SSIS Service failed to start. Configuration system failed to initialize”.  We will talk about what this error message means, as well as, how you can resolve it.   About the “Microsoft SSIS Service failed to start” Issue It happened at some point to … 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…

Selected Tweets of Year 2016!

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…