In this Article we Learn about store procedures and User Defined Function in SQL Server with Example.In previous article,we discussed about T/SQL and Cursor.

If you are using SQL DB in Azure and don’t have your critical database geo-replicated, you are opening yourself up to potential issues in the event of a disaster. By configuring geo-replication you...

In this article, I have created a sample XML format. Using nodes() method to shred XML into multiple rows, which propagates parts of XML documents into row sets.

In this article, we will be creating a hybrid sync group that contains both Azure SQL database & SQL Server Instance.

In this article, I will explain some of the rationale for material view usage along with a specific example that takes advantage of the SQL MERGE statement to incrementally reconcile changes to a t...

Split and convert a delimited string to a table with their position in SQL Server. The string contains words separated (delimited) by comma will be split into Table values.

Analyzing The Size Of Database And Size Of Table. In this article, I am going to explain two SQL queries to find the size of the database and size of a table.

This section covers most of the essential SQL Server scripts of DBA which we can use on a daily basis in the development of any BI project. CREATE DATABASE, CREATE SCHEMA, create table, ALTER DATAB...

All About Primary Key And Its Basics. In this article, we will learn about general SQL queries and their functioning.

In this article, I have listed shortcuts that I usually find helpful while working with SQL Server Management Studio.

In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.

Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase. Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries...

We will see how to create an external data source in SQL Server 2016/2017 and then we will create an external table with Parquet file format. Later, we will push the data to the external table. Aut...

Hello Learners. Thank you so much for the support for my first article “Learn About Sql Server Architecture”. Hope you all are doing well.

This is my very first article on the understanding SQL Server Architecture. I tried to make this as simple as possible. I just want to share what I learnt. If there is any error or wrong informatio...

Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would surmise that, in most cases, installing the service pack is a non-event. No flashing light...

The server name is important because it is the server where you’re developing the database. If you’re working locally then by default here you’ll see your server name which is installed in your mac...

This article explain about how to achieve add aggregate function in dynamic pivot in single table without create temporary tables.

In this article, we will discuss SQL Server And Relational Database.

In this article, we are going to see how business users or we can utilize the tabular model for data analysis and visualization in Excel.