This article explores an SSIS package for importing multiple Excel files data into SQL Server tables.
Read more »
Microsoft Time Series in SQL Server
December 12, 2019The next topic in our Data Mining series is the popular algorithm, Time Series. Since business users want to forecast values for areas like production, sales, profit, etc., with a time parameter, Time Series has become an important data mining tool. It essentially allows analyzing the past behavior of a variable over time in order to predict its future behavior.
Read more »
Learn SQL: INSERT INTO TABLE
December 12, 2019In the previous article, we’ve created two tables, and now we’re ready to use the SQL INSERT INTO TABLE command and populate these tables with data. In order to do so, we’ll prepare statements in Excel and then paste these statements into SQL Server and execute them. We’ll also check the contents of both tables before and after these commands using the SELECT statement. So, let’s start.
Read more »
Different methods to identify the SQL Server version number
December 11, 2019In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the hotfixes and CUs of SQL Server 2008 R2 and earlier versions.
Read more »
An overview of native differential backups in AWS RDS SQL Server
December 9, 2019This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.
Read more »
An overview of the SQL Server Profiler
December 9, 2019In this article, we will describe SQL Server Profiler and how it can be used. In addition, we will mention the tools that are integrated with it- plans about its deprecation, and what are the alternatives?
Read more »
An overview of SQL Server data types
December 9, 2019In this article, we will give an overview of various SQL Server data types.
Read more »
Sequence Containers in SSIS packages
December 6, 2019This article explores the Sequence container in SSIS package with examples.
Read more »
Query Performance Issues on VARCHAR Data Type Using an N Prefix
December 6, 2019In 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.
Read more »
An overview of the SQL Server Update Join
December 5, 2019This article explores the SQL Server Update Join statement in T-SQL for SQL Server.
Read more »
Learn SQL: CREATE DATABASE & CREATE TABLE Operations
December 5, 2019Welcome 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).
Read more »
Forwarded Records Performance issue in SQL Server
December 5, 2019This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server.
Read more »
SQL Server Schema Compare extension in Azure Data Studio
December 5, 2019This article explores the SQL Server Schema Compare extension in the Azure Data Studio.
Read more »
Audit and Alert SQL Server Jobs Status Changes (Enabled or Disabled)
December 4, 2019In 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.
Read more »
SSIS Foreach Loop vs For Loop Container
December 4, 2019In 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.
Read more »
Overview of SSIS Precedence Constraints
December 3, 2019This article explores the SSIS Precedence Constraints, along with examples and scenarios.
Read more »
The Table Variable in SQL Server
December 3, 2019In 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.
Read more »
Importing Data into SQL Server from MySQL using SSMS
November 29, 2019This 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.
Read more »
Using SSH keys to connect to a remote MySQL Server
November 28, 2019In 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.
Read more »
An overview of SSIS Pivot and SSIS Unpivot Transformations
November 28, 2019This article explores an SSIS Pivot transformation and SSIS Unpivot transformation for creating Pivot and Unpivot data tables.
Read more »
Using multi-value parameters in SSRS
November 27, 2019This article covers the usage and detailed features of the multi-value parameter in SSRS.
Read more »
SQL Table Variable Deferred Compilation in SQL Server 2019
November 25, 2019In 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:
Read more »
SSIS Balanced Data Distributor Overview
November 22, 2019In this article, we will give a brief overview of SSIS Balanced Data Distributor (BDD). In addition, we will give some examples and illustrate alternatives.
Read more »
Overview of Data Profiling tasks in SSIS
November 21, 2019The 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.
Read more »
Overview of SQL Server 2019 General Availability and installation
November 19, 2019Introduction
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.
Read more »