Blog Posts

Script to Install the Tools I Use on My Jumpbox

• by Tracy Boggiano

• Database Superhero’s Blog

I wrote a blog post a few months ago about the tools I use on my jumpbox you can read here.  Since then, I have
The post Script to Install...

2023-01-24

So, you're considering pursuing a certification exam

• by Will Assaf

• SQL Tact

Part 1 of 2. This blog post is co-authored by Ajayi Anwansedo, PhD and William Assaf, who met and worked together at The Futures Fund, a STEM non-profit which offers introductory coding and...

2023-01-24 (first published: 2023-01-23)

1 reads

Starting the Flyway PoC–Environment

• by Steve Jones

• The Voice of the DBA

I’ve had a goal to redo my demo environments and get them set up to work for a variety of customers in different places. I decided to do this...

2023-01-24 (first published: 2023-01-23)

Unpivot a matrix with multiple fields on columns in Power Query

• by Meagan Longoria

• Data Savvy

I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power...

2023-01-24

2 reads

Daily Coping 23 Jan 2022

• by Steve Jones

• The Voice of the DBA

Today’s coping tip is to eat healthy today with some nourishing food. A few days before think I was getting ready for my daughter to leave for university. I...

2023-01-23

EightKB 2023

• by Andrew Pruski

• The DBA Who Came In From The Cold

EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...

2023-01-23

What is calling my T-SQL scalar function (millions of times)?

• by Matthew McGiffen

• Matthew McGiffen DBA

In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...

2023-01-23

When to have multiple data lakes

• by James Serra

• James Serra's Blog

A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you...

2023-01-23

Daily Coping 20 Jan 2023

• by Steve Jones

• The Voice of the DBA

Today’s coping tip is to take a different route today and see what you notice. I’ve had this tip come up a few times and each time I’ve enjoyed...

2023-01-20

Daily Coping 19 Jan 2023

• by Steve Jones

• The Voice of the DBA

Today’s coping tip is to switch off tech an hour before bedtime. I read at night often, so this is a challenging one. However, I decided to give this...

2023-01-19