Jul 08, 2020

Quick overview on PowerShell Operators. Details explanation coming soon.

Jan 11, 2018

Being a SQL Server DBA , while dealing with reporting and automation stuffs, it is quite needed to insert the data into SQL Server table using shell or batch scripts Here , we are going to use powershell to insert the data using a commandlet in Powershell called Invoke-SQLCmd. There are many other options also to do the same but we are focusing Invoke-SQLcmd to perform this in this session.

Oct 18, 2017

SQL Server 2016 is an intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics.Click to know more from Microsoft. 

Oct 18, 2017

Here you goes to understand the evolution of quorum configuration in Windows Cluster.

Oct 18, 2017

SQL Server DBAs used to face situation to install Visual Studio in various scenarios. Earlier till SQL Server 2008R2, Visual Studio used to come along with the SQL Server binary files (BIDS) which makes it easy for the installation purpose. But from SQL 2012, we need to install it using the SSDT(SQL Server Data Tools ) which needs to be installed separately.

Oct 18, 2017

In using extended properties, you can add text, such as descriptive or instructional content, add input masks, and add formatting rules as properties of objects in a database or of the database......

Oct 04, 2017

SQL Server registers the owner of a database as the one who is creating the database. In our environment with lot of servers having database owners as the employees who has already left the organization. Many of the jobs were failing due to the database owner issue and we have to develop a script that needs to be run across the sql servers in our domain.

Jul 04, 2017

The term BLOCKS AND LOCKS is quite common in SQL Server terminologies and is one of the usual stuff every DBAs has to come across during his daily life. DBAs are smarter enough to find the lock details and kill the culprits also. But in some cases, where there are hundreds of lock chains in a database , it would be difficult to find out which lock is actually causing the root issue holding up all the rest of the locks.

Aug 01, 2017

Fix to the below error in SQL Server. 

​

"The changes you made require the following tables to be dropped and recreated.You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be recreated"

Jul 03, 2017

To find host names of servers from a list of server ips using POWERSHELL

Situations may arise where we may need to find the server host names\FQDN from a set of ip addresses. This script helped me to get the required info easily at my finger tips.

Jul 11, 2017

Query to find the fragmentation level of individual tables. in a sql server database.