Yesterday, I got a request from our customer that need to run a SQL Server Query using PowerShell command. After looking on the Google 😀 I found the Script from Romanian Coder. Basically, the script is using System.Data.SqlClient Namespace on NetFramework 4.8. Below is the complete script to Run a SQL Server Query in PowerShell: … Read more
Recently, I got the error below when re-installing Microsoft SQL Server 2016 Reporting Services on my server: The catalog database file exists. Select a files-only mode installation. The catalog temporary database file exists. Select a files-only mode installation. When clicking the first failed test, “Reporting Services Catalog Database File Existence”, I got the following detail: … Read more
As you know Microsoft SQL Server 2017 is now coming to Linux system. On this Guide, Microsoft explains How to installing Microsoft SQL Server Package, Administering and securing Microsoft SQL Server, and many more. If you are looking an answer for some question below, you can start by downloading this Free Guide. Can I use … Read more
This post will show you how to use the SQL Server Configuration Manager to change the start up option of SQL Service and to change the service account for SQL Server Database Engine, SQL Server Agent, SQL Server Browser and for the other SQL Server services. Before you continue, there are two limitations and restrictions … Read more