In this article, you will learn about Azure SQL Database - Great Choice for Modern Cloud Applications.

Moving Your SQL Workload to the Cloud

This tutorial lists the top 50 SQL Server Interview questions and answers asked in SQL Server interviews, and includes SQL Server Q&A for freshers and experienced SQL developers.

SQL (Structured Query Language) is a language to access RDBMS. Here is a list of most popular SQL interview questions and answers.

In this article, you will learn about exception handling in SQL Server.

A SQL cursor is a database object that retrieves data from result sets one row at a time.The cursor in SQL can be used when the data needs to be updated row by row.

In this article you will learn about Cursors in SQL Server.

This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should ...

SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.

A SQL trigger is a database object just like a stored procedure or we can say it is a special kind of Stored Procedure that automatically fires when an event occurs in a database. Learn what is a t...

This article explains the row_number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these...

In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.

In this blog, you will learn the difference between TRUNCATE, DELETE and DROP SQL commands.

In this article, you will learn about triggers.

Learn learn how to use pivot and unpivot in SQL with code example.

This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.

This article explains what cursors are in SQL Server and how to use Cursors in SQL with examples. A SQL cursor is a temporary work area created in system memory when a SQL statement is executed.

Learn the difference between SQL Union and Union All. Code example Union vs Union All in SQL.

In this article, you will learn about a detailed description of the primary key in SQL server.

In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.

SQL Server Management Studio (SSMS) is a Windows client app that allows database developers and database administrators to configure and manage SQL Server and Azure SQL databases. Learn how to dow...

In this article, you will learn about how to display information about events.

This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.

I shared my personal experience on how can we fix corrupted databases using a third party product called stellar.

In this article, you will learn about being a woman in the sql community.