Monitor Exceptions in Your Database

Erland Sommarskog explains how you can set up an Extended Events session that collects exceptions occurring on your server, accompanied by a view and a stored procedure that permits you to look at the data collected by the session. By the end of the article, you will be able to adapt what you’ve learned to your needs and avoid bug reports from users.

Lift-and-Shift to the Cloud with SQL Server on Azure Virtual Machines

Get the combined performance, security, and analytics of SQL Server with the flexibility and hybrid connectivity of Azure.

Basics of Working with JSON in SQL Server

Kenneth Igiri helps you get started with JSON in SQL Server. You will learn different functions that are easy to understand and implement in order to manipulate JSON formats inside SQL Server.

How to Auto-Format Your Python Code with Black

If you write a small program, you can probably get away without formatting your code. However, as programs get increasingly complex, they get harder and harder to understand. Davis David explains how you can auto-format your Python code with the Black tool.

Adjusting Pod Eviction Time in Kubernetes

One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones are spun up on a healthy node. The default time that it takes from a node being reported as not-ready to the pods being moved is 5 minutes. Andrew Pruski demonstrates how you can adjust the pod eviction time when you only have one pod in a deployment.

Rewriting Multi Statement Table Valued Functions

In this video, Erik Darling demonstrates how you can rewrite more complicated multi-statement table-valued functions and often experience much better performance as a result.

Python Caches Integers

To gain a performance boost and avoid reallocation of frequently used integers, Python creates singleton instances of small integer values and uses them by reference. Arpit Bhayani explains in detail how these integers work.

How to Secure Passwords in PowerShell Scripts

In this video, Patrick Gruenauer explains how to encrypt passwords in Powershell scripts.

Working with JSON Data in Python

Simran Singhal demonstrates how to parse Nested JSON Data in Python and how to read and write JSON Data in File.

Upcoming Virtual Events

Introduction to Azure Data Studio - Eric Flamm

Tuesday, June 02. 17:00 UTC.

Power Automate Image Analytics - Ben Watt

Tuesday, June 16. 17:00 UTC.

 

We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just Developer educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, BI, and DBA PASS Insights newsletters.