A Fine Slice Of SQL Server
In this video (part 1 of a new series), I explain what a window function is, as well as the components of window functions.
It’s taken a couple of months for me to get back on the video production wagon. This video serves mostly as the classroom primer for what will be primarily a demo-heavy series.
Leave a CommentUmut Tekin picks up on a thread:
Recently, I read Laurenz Albe’s blog about case insensitive string search. He recommended case insensitive collations saying, “it won’t be any more expensive (and maybe more intuitive) than the current techniques of using
upper()or thecitextextension are today”. In other words, a custom collation can be used instead of citext to achieve case insensivity with a lower performance penalty. Today we will be testing it.
Click through for the results of those tests.
Leave a CommentJon Vöge compares two options:
We’ve previously on this blog covered Power Apps write-back for Power BI/Fabric comprehensively, and in the past months we’ve taken a stab at the Fabric Native solution: Translytical Task Flows.
However, when comparing the different options, which solution actually comes out on top?
Read on as Jon contrasts the two options and explains when you might want to use each.
Leave a CommentMeagan Longoria hides (or shows) a page:
Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set to whatever page was open when you last saved the report. But we don’t have to settle for manually checking these things before we deploy to a new workspace (e.g., from dev to prod). If our report is in PBIR format, we can run Fabric notebooks to do this for us.
Click through for a notebook and an explanation.
Leave a CommentErik Darling continues a series on transaction isolation levels. If you haven’t been watching this series, I’d recommend checking out his channel and catching up, as he’s spent a good amount of time on transaction isolation levels and what, exactly, that means in a relational database management system like SQL Server.
Leave a CommentAndreas Wolter describes a bug in SQL Server’s auditing capabilities:
Last week, I was contacted by an IT Leader from Saudi-Arabia who previously found several CVE’s in Oracle and Microsoft SQL Server. He wanted my opinion on a newly discovered security issue in SQL Server Auditing.
Interestingly, his findings directly overlap with a topic I wrote about just last month: Using Data Classification to Audit Data Access.
Emad Al-Mousa identified two vulnerabilities in the SENSITIVE_BATCH_COMPLETED Audit Action Group. Microsoft Security Response Center (MSRC) acknowledged the issue but classified it as low priority – meaning it may not be addressed until a major release, if at all.
Read on to see what the issue is and how you can trigger it today. Andreas also includes a workaround that will work in the meantime.
Leave a Comment