SQL Server PolyBase external tables with Azure Blob Storage
January 15, 2021In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.
Search Results for: INSERT
Power BI: Importing data from SQL Server and MySQL
January 12, 2021Microsoft Power BI is a data analytics and visualization tool that can be used to visualize data in the form of different types of reports, without writing a single line of code.
Learn MySQL: The Basics of MySQL Stored Procedures
January 8, 2021In this article, we are going to learn about the stored procedures in MySQL. In this article, I am covering the basics of the stored procedure that includes the following
SQL Server ORDER BY performance tips
January 5, 2021In this article, we will explore how the ORDER BY statement affects the query performance and we will also learn some performance tips related to sorting operations in SQL Server.
Implement an Amazon Aurora Serverless cluster
January 4, 2021In this 4th article for the Amazon Aurora series, we will discuss and implement an Amazon Aurora Serverless cluster.
Creating database objects in Azure Data Lake Analytics using U-SQL
December 30, 2020This article will help you create database objects in Azure Data Lake Analytics using U-SQL.
Logging messages from Azure Functions to Azure SQL Database
December 25, 2020In this article, I am going to explain how to create a serverless application using Azure Functions and use Azure SQL Database to log messages generated by the function. In this world of cloud-based applications, it is very important that you are aware of how to create and design serverless applications. An important aspect while […]
Import data from MongoDB to SQL Server using SSIS
December 25, 2020In this article, we will explain how to install MongoDB on the Windows operating system, how to install and configure the ODBC driver and connector that allows us to import data from MongoDB to SQL Server using SSIS.
T-SQL scripts to update statistics based on the row modification
December 24, 2020In this article, we are going to learn how we can develop a T-SQL script to update statistics of tables based on the row modification. It is always a challenging task to perform maintenance on a table that has billions of rows. During the early years of my professional career, I was assigned a project […]
Rewind or Forward the Amazon Aurora Cluster with MySQL compatibility using backtrack feature
December 24, 2020In this article, we will explore the useful backtrack feature for Amazon Aurora clusters.
Introduction to the SQL Server Agent
December 15, 2020In this article, I am going to explain in detail about the SQL Server Agent service. This is a windows service that enables database developers and database administrators to schedule jobs on the SQL Server machine. The jobs can be simple T-SQL scripts, stored procedures, SSIS packages or SSAS databases. This service is available on […]
Web Scraping for SQL Machine learning using R scripts
December 14, 2020In this article, we will explore Web Scraping using R Scripts for SQL Machine Learning.
Understanding Change Tracking in SQL Server using Triggers
December 9, 2020In this article, I am going to explain what change tracking is in SQL Server and why do we need it. I will also illustrate the same using some practical examples using triggers in SQL Server. Change tracking as the name suggests, is a mechanism that helps us to identify the changes in the database […]
A case study of SQL Query tuning in SQL Server
December 8, 2020Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach […]
Import data from PDF files using R Scripts SQL Server
December 8, 2020In this article, we will read and import data from a PDF file using the R scripts SQL Server.
Identify unused SQL databases
December 8, 2020In this article, I am going to show how we can identify unused SQL databases. In our organization, after release deployment, we receive the database refresh requests. To refresh the database, we were instructed to perform the following tasks:
Extract column information using the Extract function in Power BI
December 3, 2020In this article, you will see how to use the Extract function in Power BI to extract information from columns in a Power BI dataset.
Import and Export data using R and SQL Server
December 3, 2020Data professionals get requests to import, export data into various formats. These formats can be such as Comma-separated data(.CSV), Excel, HTML, JSON, YAML, Tab-separated data(.TSV). Usually, we use SQL Server integration service ETL packages for data transformations, import or export data.
Implementing a Modular ETL in SSIS
November 24, 2020In this article, I am going to demonstrate about implementing the Modular ETL in SSIS practically. In my previous article on Designing a Modular ETL Architecture, I have explained in theory what a modular ETL solution is and how to design one. We have also understood the concepts behind a modular ETL solution and the […]
Query Tuning with SQL Server 2019
November 23, 2020In this article, we will talk about the query tuning features that were announced with SQL Server 2019.
Explore the SQL query table hint READPAST
November 14, 2020SQL Server creates an optimized execution plan based on the available inputs such as statistics, indexes. By default, it chooses a cost-optimized execution plan and executes the query. Sometimes, we use SQL queries table hints to override the default mechanism. Developers popularly use WITH (NOLOCK) query hint in a Select statement to avoid blocking issues.
An Overview of User-defined SQL Server Types
November 3, 2020In this article, we will explore User-defined SQL Server Types and their usage.
Learn SQL: SQL Injection
November 2, 2020SQL Injection is a well-known technique used to attack SQL-based applications. In this article, we’ll focus on examples showing how you could exploit database vulnerabilities using this technique, while in the next article we’ll talk about ways how you can protect your application from such attacks.
T-SQL scripts to identify unused database files
October 30, 2020In this article, I am going to show how we can automate the report of unused database files using T-SQL.
Explore secrets of the SQL Server tempdb database
October 29, 2020In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases. When we take into account all of these features of the tempdb, there is […]