Read our high-quality articles on SQL Server administration. Learn how to efficiently administer the world’s biggest DBMS, that is SQL Server.
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…
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…
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…
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…
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…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #3 Since SQL Server 2016 and later, TempDB system database can be configured via SQL Server 2016 installation wizard. For example, you can set the number of data files and growth settings, as well as set multiple volumes … Read more…
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…
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…
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…
A few days ago, a friend asked me where are SQL Server statistics stored. Are they stored in one of SQL Server’s system databases or are they stored in each database individually? In this short tip, we will take a look into this and answer the question, but first, let’s talk about SQL Server statistics. … Read more…
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…
A common question I usually get from fellow SQL Server community members, is how to update SQL Server Reporting Services (SSRS) 2017? This is a good question, because since SQL Server 2017 and later, SSRS is no longer part of the SQL Server installation media. To this end, SSRS 2017 and later can be found … Read more…
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…
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…
This short post, discusses about installing SSIS on a SQL Server Failover Cluster Instance and how you can resolve the error message: The instance selected for installation is already installed and clustered on computer [ComputerName]. To continue, select a different instance to cluster. Reproducing the Error Message If you have already deployed a SQL … Read more…