Analyze and Tune SQL Server Statistics

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that?

New Amazon X2iedn High-Memory Instances

Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and more memory per core than you can get in Azure’s managed SQL offerings.

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover:

How to navigate PostgreSQL documentation
The essential things you need to know about PostgreSQL documentation
Other useful learning resources to help make your journey to using PostgreSQL easier

Please register to watch the recording.

Getting Started with Power Query M Language in Excel

This article introduces M language concepts and examples of using M to manipulate data in Excel.

Post-migration Validation and Optimization Guide

SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.

Profiler and Server Side Traces

Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.

Introduction to Using Bitbucket and CI/CD for Your App

If you have been in the DevOps space, you should know about version control and must have worked with 0ne. But, have you heard of BitBucket? No? Well, this tutorial is for you.

The pros and cons of multicloud networking

Multicloud isn't always a sign of cloud maturity. In this post, we cover the pros and cons of multicloud networking and why you need a strategy to succeed.

“Oops, I Lost My Indexes in Azure SQL DB.”

I got an interesting request for consulting, and I’m going to paraphrase it: We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but… we just deployed a new version of our code. Our deployment tool made the database schema match our source control, which… dropped the indexes Azure had created. How do we get them back?

AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks

Microsoft has an exam related to Artificial Intelligence: Exam AI-900. It's related to the Microsoft Azure AI Fundamentals. Are there recommended materials to help pass this exam?