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 …
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, …
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. …
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 …
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 …
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 …
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, …
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 …
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 …
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 …