Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
I was working in a project where I came to know client was using MSDN licenses on production environment. Though they have MS SQL Server license available but those SQL Server licenses were not applied on this production server. This...
Last week, I had a requirement to check the row counts of all the tables present in a database. I used attached article to get the row counts of all tables. We get row counts of all tables using system...
SQL Server Agent is very useful in automating any database activities. By default, it is not installed along with SQL Server on Linux server. You need to manually install it after installing SQL Server. Here I will explain step by...
I have shown you how to install SQL Server on Redhat Linux Server in my last article. Here I will explain step by step process to install SQL Tools on RedHat Linux 7.3 server. Installing SQL Tools will install sqlcmd...
Earlier SQL Server used to run only on Windows platform till SQL Server 2016 version. Now we can host our applications on Linux based SQL Server Instances. Here I will explain step by step process to install SQL Server on...
Last week, I had a requirement to check the row count of all tables having a specific schema of databases. I did some search on this because my database has thousands of tables and it was not possible to run...
We had successfully installed SQL Server on this server but we have received error “MMC could not create the snap-in” during launching SQL Server Configuration Manager after a week. I did some google search to fix this issue but nothing...
We must Install .NET framework 3.5 as prerequisite to install SQL Server on Windows Operating System. We need to manually install it before starting SQL Server installation. You can also deploy it by using group policy. Earlier we used to...
SQL Server Agent runs scheduled SQL Server jobs and is very useful to automate database tasks. Here i will show you how to install SQL Server Agent on Ubuntu Linux server. We will use offline method to install SQL Server...
I have described step by step process to install Ubuntu 16.04 Server and Offline installation of SQL Server 2017 on Ubuntu server in my last articles. Here I will explain step by step process to install SQL Server tools (sqlcmd...
Starting with SQL Server 2017, we can run & deploy our applications on Linux based SQL Server Instances. I have already explained step by step method to install SQL Server on Redhat Linux without any internet connection in my last...
I got Microsoft SQL Server error 15433 during fixing orphaned users on a SQL Server Instance where AlwaysON Availability Group was configured. Our application was facing connectivity issue post AOAG failover and not able to connect to database whereas everything...
I was struggling with unwanted modifications of SQL Server configurations by random SQL Server sysadmin logins who were part of our SQL Server Instance. Every time we cannot monitor what has been changed and who are doing it on your...
We have Alwayson Availability Group configuration for our SAP systems. We faced SAP connectivity issue when application team tried to do a failover/HA testing and connect to database post failover, they were failed to connect to the current primary replica...
