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.
Read more »
Methods to avoid the SQL divide by zero error
October 21, 2019This article explores the SQL divide by zero error and various methods for eliminating this.
Read more »
How to Connect to a Remote MySQL Server Using SSH
October 18, 2019This 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.
Read more »
SET QUOTED_IDENTIFIER settings in SQL Server
October 17, 2019In 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.
Read more »
SQL multiple joins for beginners with examples
October 16, 2019In 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:
Read more »
An overview of the SQL table variable
October 16, 2019This article explores the SQL Table variables and their usage using different examples.
Read more »
Dynamic Data Masking In SQL Server
October 15, 2019Security 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.
Read more »
SQL Lag function overview and examples
October 15, 2019In the article SQL Server Lead function overview and examples, we explored Lead function for performing computational operations on data. This article gives an overview of the SQL Lag function and its comparison with the SQL Lead function.
Read more »
Working with XML Data in SQL Server
October 11, 2019XML (eXtensible Markup Language) is one of the most common formats used to share information between different platforms. Owing to its simplicity and readability, it has become the de-facto standard for data sharing. In addition, XML is easily extendable.
Read more »
SSIS XML Destination
October 11, 2019Until now, Microsoft has not included the XML Destination component in SQL Server Integration Services (SSIS). Many years ago, this component was requested on the Microsoft connect website, but it was closed as “Won’t fix.” For this reason, many workarounds and third-party components were created. In this article, we’ll talk about these components and some of the popular solutions for exporting data to XML using SSIS.
Read more »
Multi-AZ Configuration for AWS RDS SQL Server
October 10, 2019Amazon provides AWS RDS SQL Server as a managed relational database service. You can deploy databases instantly without worrying about underlying hardware platform, license cost, managing data centers. AWS RDS database instances are highly available. It provides a failover mechanism using the Mult-AZ deployments.
Read more »
A Walkthrough of SQL Schema
October 9, 2019This article gives an overview of SQL Schema and its usage in SQL Server.
Read more »
How to find the SQL Server version
October 8, 2019In this article, we will explore how to find the SQL Server version details with various methods.
Read more »
Overview of SQL Server Aliases
October 7, 2019This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
Enforce SSL connections in AWS RDS SQL Server
October 7, 2019This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
How to create and configure a linked server to connect to MySQL in SQL Server Management Studio
October 7, 2019This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »
Pseudo-Simple SQL Server Recovery Model
October 7, 2019This article gives an overview of the Pseudo Simple SQL Server Recovery Model. It also explores the conditions in which the database behaves in Pseudo mode.
Read more »
How to rename tables in SQL Server with the sp_rename command
October 7, 2019In this article, we will learn to rename tables in SQL Server. sp_rename is a built-in stored procedure which helps to rename user tables in the SQL Server. During the software development life cycle, we might be faced with various scenarios that required to rename the existing tables in the database. For example, the tables which are created in the SQL Server might be needed to be renamed, because of the software version upgrades, bug fixing or other various development requirements. These and similar reasons can make renaming tables important. So, in this article, we will particularly focus on how to rename the tables in SQL Server.
Read more »
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
October 4, 2019In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.
Read more »
Encrypted Backup and Restore in AWS RDS SQL Server
October 4, 2019In the article, Recover Data in AWS RDS SQL Server, we explored the process of native backup and restoration for the AWS RDS SQL Server database. It involves the following steps:
Read more »
Database Level DDL Triggers for Views, Procedures and Functions
October 4, 2019In this article, we will un-riddle the ways to make use of the data definition language trigger (DDL Trigger), in order to monitor the progressions made to the database programming objects, View, Procedure or Function with a few real-time examples.
Read more »
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
October 4, 2019In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.
Read more »
Piecemeal Database Restores in SQL Server
October 3, 2019This article explores the piecemeal database restore SQL Server feature and its benefits to minimize the database restoration.
Read more »
SQL Server Transaction Log Interview Questions
October 3, 2019In this article, we will discuss some important SQL Server Transaction Log interview questions that you may be asked during a SQL Server administrator or developer technical job interview.
Read more »
SQL Server Auditing Interview Questions
October 3, 2019In this article, we will discuss a number of common and important SQL Server Audit questions that you may be asked during the SQL Server database administrator interview. I advise you to check them out and get ready for the interview.
Read more »