MSSQL

It is a very critical step to correctly determine SQL Server Data Types when designing tables to prevent unnecessary growth of the database. The space …

  In this article I will describe how to declare variables in TSQL. We can declare variables in a few different ways. • Declare a …

We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete files with a specified extension in a folder. I …

We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data …

  Last night, a customer started to receive error messages about one of the Replica in an AlwaysOn Availability Group configuration. Error messages were related …

We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of running a sql server job. I …

We had a job adding a new node to a Cluster the other day. During this process, I encountered the error you would see in …

We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete the maintenance plan history. I will share links to …

You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With …

  ERROR: DCOM was unable to communicate with the computer “server_name.domain_name” using any of the configured protocols; requested by PID     5cac (C:\Windows\system32\ServerManager.exe). Event …