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.

Sentiment Analysis with IA

Learn how to use Python and AI to perform a sentiment analysis on text.

The Need for DevSecOps

DevOps is great, but Steve thinks we need to ensure we include security is a part of what we do when building and deploying software.

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.

Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps

In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.

Community at PASS Summit

Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]

A Staffing Disaster

An Azure datacenter had a failure after an incident, partially because they didn't have enough people. Steve notes that staffing is a challenge in many ways.

Sending Multiple Attachments in Email from Azure Data Factory Pipeline

This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.

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.