Sequence Containers in SSIS packages

December 6, 2019 by Rajendra Gupta

This article explores the Sequence container in SSIS package with examples.

Query Performance Issues on VARCHAR Data Type Using an N Prefix

December 6, 2019 by Jignesh Raiyani

In this article, we’ll discuss data type VARCHAR and query performance issues associated with utilizing the lower level VARCHAR data type. CHAR, VARCHAR and NVARCHAR are data types that support storing information in text format in a SQL Server database. These data types allow a wide assortment of character sets in the defined field or column in the database table.

An overview of the SQL Server Update Join

December 5, 2019 by Rajendra Gupta

This article explores the SQL Server Update Join statement in T-SQL for SQL Server.

Learn SQL: CREATE DATABASE & CREATE TABLE Operations

December 5, 2019 by Emil Drkusic

Welcome to the first article in the Learn SQL series. In this part, we’ll start with two essential commands in SQL: Create Database and Create Table. While both are pretty simple, they should be used first before you start working anything with data (unless you use some template database).

Forwarded Records Performance issue in SQL Server

December 5, 2019 by Rajendra Gupta

This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server.

SQL Server Schema Compare extension in Azure Data Studio

December 5, 2019 by Rajendra Gupta

This article explores the SQL Server Schema Compare extension in the Azure Data Studio.

Audit and Alert SQL Server Jobs Status Changes (Enabled or Disabled)

December 4, 2019 by Jignesh Raiyani

In this article, we will talk about how to track enabled or disabled SQL jobs in SQL Server using T-SQL. Users with the Sysadmin role have the default permissions to modify the information of any jobs in SQL Server. If a user is not in this role and wants access to this activity, then the user needs to be given the SQLAgentOperatorRole in the msdb database.

SSIS Foreach Loop vs For Loop Container

December 4, 2019 by Hadi Fadlallah

In this article, first, we will briefly describe foreach loops and for loops. Then, we will give an overview of SSIS Foreach Loop Container and For Loop Container. Finally, we will compare these two containers.

Overview of SSIS Precedence Constraints

December 3, 2019 by Rajendra Gupta

This article explores the SSIS Precedence Constraints, along with examples and scenarios.

The Table Variable in SQL Server

December 3, 2019 by Esat Erkec

In this article, we will explore the table variable in SQL Server with various examples and we will also discuss some useful tips about the table variables.

Importing Data into SQL Server from MySQL using SSMS

November 29, 2019 by Jignesh Raiyani

This article shows the best way to import a copy of your MySQL database table to SQL Server using the SQL Server import data feature. We’ll demonstrate how to perform data import and export using a query with the assistance of SQL Server Management Studio.

Using SSH keys to connect to a remote MySQL Server

November 28, 2019 by Marko Zivkovic

In this article, it will be described how to connect to remote MySQL Server on Linux OS using SSH key pairs. Windows OS will be used as a host from which will be established a connection using PuTTY as a client. Besides using PuTTY as a client for establishing the connection to remote machines, it will be used to generate and use secure shell – SSH keys as well.

An overview of SSIS Pivot and SSIS Unpivot Transformations

November 28, 2019 by Rajendra Gupta

This article explores an SSIS Pivot transformation and SSIS Unpivot transformation for creating Pivot and Unpivot data tables.

Using multi-value parameters in SSRS

November 27, 2019 by Esat Erkec

This article covers the usage and detailed features of the multi-value parameter in SSRS.

SQL Table Variable Deferred Compilation in SQL Server 2019

November 25, 2019 by Rajendra Gupta

In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Let’s have a quick recap of the table variable:

SSIS Balanced Data Distributor Overview

November 22, 2019 by Hadi Fadlallah

In this article, we will give a brief overview of SSIS Balanced Data Distributor (BDD). In addition, we will give some examples and illustrate alternatives.

Overview of Data Profiling tasks in SSIS

November 21, 2019 by Hadi Fadlallah

The Data Profiling task in SSIS is an important task that can be used to assess the quality of data sources. Unfortunately, this component is not widely used by many business intelligence developers.

Overview of SQL Server 2019 General Availability and installation

November 19, 2019 by Rajendra Gupta

Introduction

On November 4th, 2019, during the Ignite conference at Orlando, Microsoft released the General Availability of its flagship product Microsoft SQL Server 2019. SQL 2019 provides various enhancements to its core database engine and offers integration with Big data (Apache Spark, Data Lake), Machine learning, Linux/container compatibility with Kubernetes.

SQL Variables: Basics and usage

November 18, 2019 by Esat Erkec

In this article, we will learn the notions and usage details of the SQL variable. In SQL Server, local variables are used to store data during the batch execution period. The local variables can be created for different data types and can also be assigned values. Additionally, variable assigned values can be changed during the execution period. The life cycle of the variable starts from the point where it is declared and has to end at the end of the batch. On the other hand, If a variable is being used in a stored procedure, the scope of the variable is limited to the current stored procedure. In the next sections, we will reinforce this theoretical information with various examples

Query Amazon Athena external tables using SQL Server

November 15, 2019 by Rajendra Gupta

This article covers the following topics:

Overview of the Amazon Athena
Query CSV file stored in Amazon S3 bucket using SQL query
Create SQL Server linked server for accessing external tables

Read SQL Server error logs using the xp_readerrorlog command

November 14, 2019 by Rajendra Gupta

This article explores the xp_readerrorlog command for reading SQL Server error logs using T-SQL.

SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS

November 14, 2019 by Hadi Fadlallah

In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and preventing an out of memory exception. We describe how to load data in batches to avoid placing a large amount of data into memory.

Performing CRUD operations with a Python SQL Library for SQL Server

November 13, 2019 by Ben Richardson

This article covers how to connect a Python application to Microsoft SQL Server using a 3^rd party Python SQL library. The library that we are going to use is called “pyodbc”, which is freely available. We will use “pyodbc” to perform CRUD (Create Read Update and Delete) operations on a Microsoft SQL Server database.

SQL DDL: Getting started with SQL DDL commands in SQL Server

November 8, 2019 by Ben Richardson

This article explains SQL DDL commands in Microsoft SQL Server using a few simple examples.

Manage Unicode Characters in Data Using T-SQL

November 7, 2019 by Jignesh Raiyani

In this article, I’ll provide some useful information to help you understand how to use Unicode in SQL Server and address various compilation problems that arise from the Unicode characters’ text with the help of T-SQL.