Issue Adding Node to a SQL Server Failover Cluster – Greyed Out Service Account – How to Resolve

Hi friends! In this post, which is related to SQL Server failover clustering, we will talk about how you can resolve the issue of not being able to add a node to a Server failover cluster, due to the fact that one of the service accounts (i.e. SQL Server or SQL Server Agent, or both) … Read more…

How to Fix SQL Server Agent Not Showing in a Failover Cluster

Hi friends, in this post, we will discuss about how you can fix the issue, where SQL Server Agent might not be showing up in a SQL Server Failover Cluster Instance (FCI). SQL Server Agent not showing in Failover Cluster If you have a SQL Server failover cluster, and you cannot see SQL Server Agent … Read more…

Tip of the Week No.9 – SQL Server Service Account Info using T-SQL

Hi friends! This week’s tip, is about how you can easily retrieve, SQL Server service account info, using T-SQL.   Tip of the Week #9 An easy way to find the service accounts for the main SQL Server services such as Database Engine and SQL Server Agent, is to execute the below T-SQL statement within SSMS: … Read more…

SQL Server replication requires the actual server name to make a connection to the server – How to Resolve it

When working with SQL Server replication and you try to add a new subscription under a local publication, under certain circumstances you might end up with the error message: Cannot connect to … SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name (Replication.Utilities).   … Read more…

How to Resolve: The feature “Scale-out deployment” is not supported in this edition of Reporting Services

Under certain circumstances, when upgrading SQL Server Reporting Services Standard Edition, for example from SSRS 2012 or 2014 to SSRS 2017 or 2019, you might get the following error message when trying to start the Reporting Services service: “The feature “Scale-out deployment” is not supported in this edition of Reporting Services“. But first, let’s discuss … Read more…

Tip of the Week No.6 – About SQL Server Temporary Tables

Check our Tip of the Week, about SQL Server Temporary Tables.   Tip of the Week #6 Local temporary tables in SQL Server, are defined by using the # (single hash) sign and they are only available for the session in which they were created in. After the session ends, local temporary tables are automatically … 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…

How to Install SQL Server 2019 Express and the Latest Version of SSMS

In this article, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS).   What is SQL Server Express Edition? SQL Server Express Edition, is a special, … 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…

SQL Server Versions Currently Supported and their End Dates

When working with SQL Server, not only as Database Administrator but also as Developer, you need to know the SQL Server versions currently supported by Microsoft, as well as their extended support end dates, in order to plan ahead. And planning ahead does not only mean planning possible SQL Server instance migrations, but also, plan … Read more…

What are SQL Server Always On Availability Groups?

SQL Server AlwaysOn Availability Groups is a technology that was initially released by Microsoft with SQL Server 2012. The main concept, is that you have your data available in more than one sites at the same time. To this end, you have groups of databases that have primary replicas and secondary replicas. These replicas are hosted … 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…