Category: Database

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 …


Managing snapshots in AWS Redshift clusters

This article gives an overview of configuring AWS Redshift snapshots for scheduled data backup, data archival, as well as disaster recovery. Introduction AWS Redshift is one of the data repositories offered by AWS. It’s a columnar data warehouse service that is generally used for massive data aggregation and parallel processing of large datasets on the …


Install MongoDB on Windows – SQL in Sixty Seconds #091

SQL Server is my passion and I have been keeping busy most of the time in my career doing. While SQL Server is my primary expertise, I also focus on MariaDB, PostgreSQL, MySQL and many other relational databases. However, in the real world, it is not always possible to work on the relational database. There …