Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it...
2024-07-12 (first published: 2024-06-27)
216 reads
What topics do you want to see presented at a future SQL Saturday (or other event)? Steve Rezhener has built a survey that you can take. Take the survey...
2024-07-12 (first published: 2024-06-25)
90 reads
Where I work, we will be migrating data from one set of databases into another. I will be making a copy of the destination databases to allow us to...
2024-07-10 (first published: 2024-06-25)
370 reads
There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
265 reads
I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from views into a respective fact or dimension. Such a...
2024-07-08 (first published: 2024-06-08)
773 reads
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-07-08 (first published: 2024-06-21)
222 reads