During a routine SQL Server patching process on SQL Server some error messages appeared in the SQL Server Error Logs.    As a result SQL Server was not able to  start up &nbs… Read More

Database Slotting Strategies As many organizations are in the process of upgrading and migrating their databases, we as DBAs need to make sure the database has an ideal target environment. T… Read More

Definition of SSIS Script Task SQL Server Integration Services (SSIS) is a collection of tools for performing data connectivity. It’s used to simplify data storage and address complic… Read More

Introduction to T-SQL Substring T-SQL substring is the function that acknowledges the user to extract a substring from the provided string as per the user’s requirement so it can deri… Read More

Introduction to SSIS in Azure SSIS is an abbreviated form of SQL Server Integration Services, which works as a feature pack in Azure and is defined as an add-on that delivers the modules it… Read More

Most of the T-SQL applications are very useful and also support both Microsoft SQL server and also azure SQL data. Let’s consider example SQL components like data types or operators… Read More

Some AWS  RDS SQL Server limitations - Some ports are reserved for Amazon RDS, and you can't use them when you create a DB instance. - Amazon RDS for SQL Server doesn't support importi… Read More

We are moving SQL Databases and SSIS packages from one system to other. I have received several SSIS packages from other company and trying to configure those and getting errors when executi… Read More

Problem : DBCC UPDATEUSAGE for multiple databases Hello, We have problem with our SQL databases. We got advice from our software developer company to run this command (look below). The probl… Read More

Question: I'm migrating some SQL Server databases to Openshift Containers. The SQL Server is set up with persistent disk , with a dedicated persistent disk partition for the SQL Server defau… Read More

In this blog post, I will share frequently most asked top interview questions on sql server for experienced and freshers to get the right job. Find the list below:- Keep reading on Inte… Read More

Question: I'd like to find all SQL Server Agent Jobs with a certain string within the Command section . There's been a change in reference to a database table, therefore I need to review all… Read More

Using the below script we can take all databases backup with one command!!You can check my other post BACKUP STATUS to know the current DB backup status. exec sp_msforeachdb 'use [?];IF ''?… Read More

SQL Server Interview Questions and answers SQL Server Interview Questions and answers for beginners and experts. List of frequently asked SQL Server Interview Questions w… Read More