Category: Database

Configure ODBC drivers for MySQL

In this article, I am going to explain ODBC drivers. We will go through the process to set up the ODBC driver for MySQL and use it to create an SSRS report. First, let me talk about ODBC drivers. The ODBC, also known as Open DataBase Connectivity, is provided by Microsoft that allows us to …


Quantum Computing With an Example of Coin – SQL in Sixty Seconds #094

Quantum Computing is the next wave in computing and it is very different from traditional computing. Lots of people often ask me what is Quantum Computing. I decided to build a short video based on Quantum Computing with an example of a coin. I use the coin as a prop to explain how Quantum computing …


Compress and split SQL database backups using WinRar

Recently, we have received a strange request from our customer. They want us to set up a schedule a backup job that generates a backup of SQL database, compress the backup file in multiple compressed archive files (WinRAR files.) We tried to explain to the customer that the SQL Server native backups are capable of …


SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE

Recently I found an interesting situation with one of my clients when working on Comprehensive Database Performance Health Check. It was about one particular statistics not getting auto-updated on the table. After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today. Real-World Scenario During the consultancy senior, …


Migrate SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database

In the previous article of this series, Migrate SQL workloads to Microsoft Azure: Databases trip to SQL Server on Azure VM, we went through the methods that can be used for assessing your on-premises SQL Server databases before the migration process then migrating it to a SQL Server instance hosted in a Microsoft Azure VM. …


How to Uninstall SQL Server 2019 Instance? – SQL in Sixty Seconds #093

Earlier this week, I had posted a video about how to install SQL Server 2019. I received lots of comments and feedback about this one. Many people said that they have realized that installing SQL Server 2019 is very easy but the real challenge is to uninstall SQL Server 2019 instance. Let us learn how …


Getting started with Amazon S3 and Python

In this article, I am going to explain what Amazon S3 is and how to connect to it using python. This article will be focused on beginners who are trying to get their hands on in python and working around the AWS ecosystem. AWS, as you might know, is one of the largest cloud providers …


How to Install SQL Server 2019? – Interview Question of the Week #287 – SQL in Sixty Seconds #092

Question: How to Install SQL Server 2019? Answer: This is one of the unique blog posts in the history of SQLAuthority where I am merging two of the blog post category together 1) SQL in the Sixty Seconds 2) SQL Interview Questions and Answers. Lots of people have asked me why I have not created …


Migrating SQL workloads to Microsoft Azure: Databases Trip to SQL Server on Azure VM

In the previous articles of this series, we built the bridge that leads us to the best way of migrating our SQL workload to Microsoft Azure, by showing how to create the databases migration strategy that contains a deep study of the current environment and the available options in Azure to replace the on-premises setup, …


SQL SERVER 2019 – Disabling Scalar UDF Inlining

I have been blogging for over 13 years and have been working with SQL Server Performance Tuning for an over a decade and everyone always ask me where do I get new content to write from every single day. My answer is very simple, I actually get new things to learn from my clients when …