I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...
2023-12-01 (first published: 2023-11-29)
13 reads
I know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS)....
2023-12-01 (first published: 2023-11-30)
67 reads
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...
2023-11-28 (first published: 2023-11-20)
203 reads
With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...
2023-11-27 (first published: 2023-11-16)
421 reads
One day, I shut down my computer, as I usually do nightly. This time, I shut it down on a Friday and turned it back on after a holiday...
2023-11-17 (first published: 2023-11-03)
158 reads
Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk you through setting up statistic updates and index maintenance using...
2023-11-06 (first published: 2023-10-19)
438 reads
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
369 reads
This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...
2023-08-16 (first published: 2023-08-15)
8 reads
First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...
2023-07-19 (first published: 2023-07-10)
435 reads