Most of my blog posts are an outcome of the work that I do over the weekend while holding the pager for my team. This blog post is no different. In this blog post, I will talk about the importance…

Blogging is something I love because it gives me a chance to share the ideas I have and the knowledge I have gained so far. Last week, one of our clients was doing some maintenance activity. Today’s blog post comes…

Microsoft just announced the public preview for Azure Soft Delete of Storage Blobs. From the documentation, “When turned on, soft delete enables you to save and recover your data when blobs or blob snapshots are deleted. This protection extends to…

Introduction Every new version of SQL Server ships with exciting new features. One of the simplest but important features is Automatic Tuning. Before covering this new feature, let’s analyze the old ways so we can understand what is really automated…

The basics If you’re a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data Lake and would like to understand what it’s all about and how to get started, this article is for YOU….

An interesting issue came across my desk this week. One of our clients has a number of PowerShell tasks running on SQL Server Agent job. One day, the jobs suddenly stopped working due to the error below: Message Executed as…

This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let’s start by explaining what data discovery and classification is and why is it important. Data discovery is not…

Problem There’s no doubt that storage is one of the key components to SQL Server performance and availability for both large and small SQL Server instances. With today’s increases in server and virtual server processing power and large-scale memory support,…

This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets. Sharding, at its core, is breaking up a single, large database into multiple smaller, self-contained ones. This is usually done by companies that need…

It’s already a fact: cloud is here to stay. As time goes by, we have a better understanding of how it really works as well as its real pros and cons. But here is the most important lesson: We don’t…