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...
Let’s assume a scenario that a new user joins the department and he needs access to some set of applications. To achieve this he needs to be added to a particular Active directory group. User can do it himself via...
I got this error during one of the activity when i was not able to perform it because my user was not part of sudoers file. The error details were given as “User is not in the sudoers file. This...
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...
Most of the industry folks think, every new deal/project won by any organization is result of their smart sales team. However, there are multiple teams who contribute behind the scene to bring in new projects/deals for your organization. Presales is...
I explained how to installed RedHat Linux on a virtual machine in my last article. I was not able to connect to this Linux server from PuTTY terminal that was installed on my host machine. Everytime i tried to connect...
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...
Ubuntu is a complete Linux operating system, freely available with both community and professional support. Ubuntu gives us two flavour of installation. One is desktop version another one is Server version. Here i will explain step by step process to...
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...
