SQL Server Execution Plans Interview Questions

September 20, 2019 by Ahmad Yaseen

In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview.

Recover lost SA password

September 20, 2019 by Ranga Babu

In this article, we will review how to recover SA password by starting SQL Server in single user mode when you forget “sa” credentials or lose the access to the instances due to the following reasons:

Alternate Row Colors in SSRS

September 20, 2019 by Dinesh Asanka

Setting alternate row colors in SSRS (SQL Server Reporting Services) is an important visualization configuration for end-users so that they can easily view their reports. However, setting alternate colors in SSRS is not a click of a button configuration like in the Microsoft Excel.

Different ways to start a SQL Server single user mode

September 17, 2019 by Ranga Babu

In this article, we will review different ways to start SQL Server in single user mode.

Many DBA’s might have a situation like restoring a master database or other system databases from the backup that needs SQL Server to be started in single user mode. There are different ways to start SQL Server single user mode. Let us discuss them one by one.

Execute SQL Tasks in SSIS: Output Parameters Vs Result Sets

September 17, 2019 by Hadi Fadlallah

In the previous article, I gave an overview of Execute SQL Task in SSIS and we illustrated some of the differences between writing an expression to evaluate SqlStatementSource property and writing this expression within a variable and change the Execute SQL Task Source Type to variable.

T-SQL RegEx commands in SQL Server

September 17, 2019 by Rajendra Gupta

This article explores T-SQL RegEx commands in SQL Server for performing data search using various conditions.

Move or copy SQL Logins by assigning roles and permissions

September 13, 2019 by Jignesh Raiyani

This article speaks to, how to copy SQL Logins on the new server with Server Level roles and database-level permissions as existing Source to Destination SQL Server instance using a script.

Transparent Data Encryption (TDE) on Azure SQL database

September 13, 2019 by Ranga Babu

In this article, we will review on Transparent Data Encryption (TDE) on an Azure SQL database and how to enable Transparent data encryption using Asymmetric keys in Azure Key Vault.

Limit SQL Server Login Authentication scope using a Logon Trigger

September 13, 2019 by Jignesh Raiyani

This article contains the SQL Server login Authentication scope on the Security side. We will find the subtleties, how Login Authentication extension can be controlled SQL Server level Logon trigger.

SQL Server Transactional Replication on Linux

September 12, 2019 by Jignesh Raiyani

In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.

Microsoft Decision Trees in SQL Server

September 12, 2019 by Dinesh Asanka

Decision trees, one of the very popular data mining algorithm which is the next topic in our Data Mining series. In the previous article Introduction to SQL Server Data Mining, we discussed what data mining is and how to set up the data mining environment in SQL Server. Then in the next article, Microsoft Naïve Bayes algorithm was discussed. In this Article, Microsoft Decision Trees are discussed with examples. The Microsoft Decision Trees algorithm is a classification and regression algorithm that works well for predictive modeling. The algorithm supports the prediction of both discrete and continuous attributes.

Row Sampling Transformations and Percentage Sampling Transformations in SSIS packages

September 11, 2019 by Rajendra Gupta

This article explores Row Sampling Transformations in SSIS and Percentage Sampling Transformations in SSIS packages

Character Map Transformations in SSIS packages

September 11, 2019 by Rajendra Gupta

This article explores the Character Map Transformation in SSIS package with available configurations.

Restoring Transparent Data Encryption (TDE) enabled databases on a different server

September 11, 2019 by Ranga Babu

In this article, we will review how to enable Transparent Data Encryption (TDE) on a database in SQL Server and move the Transparent Data Encryption (TDE) enabled databases to a different server by restoring the backup.

SQL Server multi-statement table-valued functions

September 11, 2019 by Esat Erkec

In this article, we will learn multi-statement table-valued functions (MSTVFs) basics and then we will reinforce our learnings with case scenarios.

Overview of SQL LOWER and SQL UPPER functions

September 10, 2019 by Rajendra Gupta

This article gives an overview of SQL UPPER function and SQL LOWER function to convert the character case as uppercase and lowercase respectively.

Creating SQL Unit Testing Utility Procedures with tSQLt

September 10, 2019 by Haroon Ashraf

This article gives hands-on experience of writing basic utility procedures and creating their SQL unit tests using tSQLt an advanced SQL unit testing framework.

Creating your own SQL Server docker image

September 9, 2019 by Ranga Babu

In this article, we will review how to create custom SQL Server docker images and run the containers from the custom images, upload the custom images to the docker hub.

SQL Server Index Fill factor with a Performance Benchmark

September 9, 2019 by Jignesh Raiyani

In this article, we will study in detail about the how SQL Server Index Fill factor works.

Execute a SQL Task in SSIS: SqlStatementSource Expressions vs Variable Source Types

September 9, 2019 by Hadi Fadlallah

In this article, I will give an overview of Execute SQL Task in SSIS and I will try to illustrate some of the differences between writing an expression to evaluate SqlStatementSource property or writing this expression within a variable and change the Execute SQL Task Source Type to variable.

Upgrading to a new SQL Server edition

September 9, 2019 by Rajendra Gupta

This article gives an overview of different editions in SQL Server and also explains the process to upgrade SQL Server editions.

Overview of the SQL DELETE Column from an existing table operation

September 6, 2019 by Rajendra Gupta

In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.

Using a CHECKPOINT in SSIS packages to restart package execution

September 5, 2019 by Rajendra Gupta

In the article, SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server, we talked about the CHECKPOINT process for SQL Server databases. This article is about CHECKPOINT in SSIS package.

An overview of Error Handling in SSIS packages

September 5, 2019 by Rajendra Gupta

This article explains the process of configuring Error handling in SSIS package.

SSIS Conditional Split overview

September 4, 2019 by Dinesh Asanka

SQL Server Integration Services or SSIS is used as an ETL tool to extract-transform-load data from heterogeneous data sources to different databases. After extracting data from the different sources, most often there are a lot of transformations needed. One of the frequent transformations is SSIS Conditional Split.