Flyway with Multiple Folders
A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few...
2023-06-19 (first published: 2023-05-31)
147 reads
Blog Posts
Power BI – Empowering Users to Disable Tooltips
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your stakeholders with a variety of tooltips that offer deeper insights. They love the tooltips, and...
2023-06-19 (first published: 2023-06-05)
238 reads
Tales From The Field Weekly Wrap Up for the Week of 06-12-2023 Cooking, Father's Day, & the Shrinking Household
Hello Dear Reader! This past week was a busy one. As we've started to settle into the new house we are transitioning from eating out or having meals delivered,...
2023-06-19
36 reads
Under Promise and Overdeliver
If you under promise and overdeliver then you will always have happy clients.
2023-06-19
26 reads
A New Word: Astrophe
astrophe n the feeling of being stuck on Earth. Us geeks are supposed to love space, right? Science Fiction? The Moon is a Harsh Mistress? Star Trek/Star Wars/Lost in...
2023-06-16
39 reads
Heading to That Conference
I’ve been working with Ryan Booz a bit more and as we’ve talked over the last few weeks, he has asked me a few times if I’ve booked travel...
2023-06-16
17 reads
Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data
Information security and privacy are key in today’s data-driven world. Sensitive data needs to be protected from unauthorized access. With column masking in SQL Server and Azure SQL, you...
2023-06-16 (first published: 2023-06-01)
355 reads
Using Data Masker on Chinese Surnames
A customer had a question recently on masking Chinese characters. I thought that was interesting, so decided to test this out. This is a short post on using SQL...
2023-06-16 (first published: 2023-05-26)
163 reads
Avoid “Constants” in T-SQL
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
400 reads
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,...
2023-06-14 (first published: 2023-05-31)
625 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers