As we all know that SQL Server analysis service (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business r...

In this article, I will give one of the solution to overcome “The given key was not present in the dictionary” exception in MySQL.

In this article, we will learn using Window Ranking Function With UPDATE Statement.

In this article, I am going to tell about dropping of indexes in view in SQL Server.

If you are like me, you use the SSMS GUI for various things. Though I tend to use scripts for the management of most things, I do check on the database growth rates of files using the GUI interface.

I had to work with composite primary keys recently while working on a project for a client. More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) ha...

In this session, we will briefly discuss how to load data from one table to another table and Excel sheets at the same time using SSIS package.

A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part 4, I am going to talk about the changes that are coming in vNext of SQL Server.

In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.

This post contains SQL Server tips for applying paging in SQL that can be used in real-world applications for long-running processing with better performance

In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.

In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables t...

Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you ...

In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.

In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics ...

When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you...

In this article, you will learn how to remove duplicate rows in SQL Server using CTE.

Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest...

This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.

I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.