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.

Overview of DBCC INPUTBUFFER and sys.dm_exec_input_buffer DMF

November 7, 2019 by Rajendra Gupta

This article gives an overview of the DBCC INPUTBUFFER and its replacement sys.dm_exec_input_buffer system dynamic management function .

SQL While loop: Understanding While loops in SQL Server

November 6, 2019 by Ben Richardson

The SQL While loop is used to repeatedly execute a certain piece of SQL script.

Exploring the SandDance Visualizations extension in Azure Data Studio

November 6, 2019 by Rajendra Gupta

Azure Data Studio is an open-source, cross-platform and lightweight data management tool. We can use it for on-premise SQL Server, Azure SQL database and Azure SQL data warehouse. Previously we knew this tool as SQL Operations Studio.

SQL JOIN TABLES: Working with Queries in SQL Server

November 6, 2019 by Ben Richardson

In this article, you will see how to use different types of SQL JOIN tables queries to select data from two or more related tables.

A handy SQL Notebook for the purposes of troubleshooting in Azure Data Studio

November 5, 2019 by Rajendra Gupta

This article prepares a handy SQL Notebook for DBAs. You can use this notebook to troubleshoot performance issues and for getting SQL Server instance details.

Resolve and Troubleshoot SQL Blocking chains with root sessions

November 5, 2019 by Jignesh Raiyani

In this article, we will study how to recognize and resolve the SQL blocking chain by determining and troubleshooting the root cause.

SQL Carriage Returns or Tabs in SQL Server strings

November 4, 2019 by Rajendra Gupta

This article explores inserting SQL carriage return AKA line break and tab in a string along with SSMS behavior while copying data to excel, notepad.

The Partial SQL Sever Database Backup

October 30, 2019 by Rajendra Gupta

This article explores the partial backup SQL Database strategy in SQL Server and its usages for read-only filegroups.

SSIS Flat Files vs Raw Files

October 29, 2019 by Hadi Fadlallah

In this article, we will give an overview of using Flat Files and Raw Files in SSIS, then we will illustrate some of the differences between using these two types.

SSIS Script Component Overview

October 29, 2019 by Hadi Fadlallah

SSIS Script component is a prominent strength of SQL Server Integration Services since it allows developers to implement any complex logic and utilize libraries from the powerful .NET framework or third-parties.

Data Import from Amazon S3 SSIS bucket using an integration service (SSIS) package

October 28, 2019 by Rajendra Gupta

This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.

SQL WHILE loop with simple examples

October 25, 2019 by Esat Erkec

SQL WHILE loop provides us with the advantage to execute the SQL statement(s) repeatedly until the specified condition result turn out to be false.

Geo Replication on Transparent Data Encryption (TDE) enabled Azure SQL databases

October 24, 2019 by Ranga Babu

In this article, we will review how to set up Geo-Replication on a Transparent Data Encryption (TDE) enabled Azure SQL database.

Implementing SQL data types

October 23, 2019 by Bojan Petrovic

This article is about many different SQL data types that we use when working with SQL Server. We will start with a quick overview and go through some stuff like categories of data types, what objects we can work with, and how to create our own custom data types.

Overview of the Collate SQL command

October 22, 2019 by Ranga Babu

In this article, we will review the Collate SQL command. First, let us see what collation in the SQL Server is.

Prepare ZIP or RAR files in SQL Server Using xp_cmdshell (T-SQL)

October 21, 2019 by Jignesh Raiyani

Microsoft SQL Server offers the ability to export data into CSV, Excel, PDF and other formats with the help of xp_cmdshell in T-SQL.

Methods to avoid the SQL divide by zero error

October 21, 2019 by Rajendra Gupta

This article explores the SQL divide by zero error and various methods for eliminating this.

How to Connect to a Remote MySQL Server Using SSH

October 18, 2019 by Marko Zivkovic

This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.

SET QUOTED_IDENTIFIER settings in SQL Server

October 17, 2019 by Rajendra Gupta

In this article, we will explore QUOTED_IDENTIFIER behavior, default value, and comparison with a different value. Set options at connection level control query behavior in SQL Server. The query might behave differently with different set options and their values.

SQL multiple joins for beginners with examples

October 16, 2019 by Esat Erkec

In this article, we will learn the SQL multiple joins concept and reinforce our learnings with pretty simple examples, which are explained with illustrations. In relational databases, data is stored in tables. Without a doubt, and most of the time, we need a result set that is formed combining data from several tables. The joins allow us to combine data from two or more tables so that we are able to join data of the tables so that we can easily retrieve data from multiple tables. You might ask yourself how many different types of join exist in SQL Server. The answer is there are four main types of joins that exist in SQL Server. First of all, we will briefly describe them using Venn diagram illustrations:

An overview of the SQL table variable

October 16, 2019 by Rajendra Gupta

This article explores the SQL Table variables and their usage using different examples.

Dynamic Data Masking In SQL Server

October 15, 2019 by Ben Richardson

Security has been one of the prime concerns of database developers since the inception of database management systems. Various data protection schemes have been introduced to provide secure access to sensitive data.