A Fine Slice Of SQL Server
Kevin Wilkie doesn’t want to spend that extra money:
Now that we’ve loaded our Costs Dashboard with all sorts of goodness, let’s take it a step further and make it even more useful. The goal: track unused warehouses to help manage spend and reduce clutter.
Read on to see how you can do this.
Leave a CommentLast week, I asked y’all how frequently you ran your full backups, corruption checks, index maintenance, and stats updates. The results after over 1,000 responses:
Click through for the results and some of Brent’s thoughts.
Leave a CommentJon Vöge comes continues looking at Power BI writeback:
This blog has previously covered the basics of native Microsoft Fabric / Power BI write-back with Translytical Task Flows.
In my first post on the subject, we created a simple Comment/Annotation solution, allowing the user to input free text comments on Data Points directly in Power BI.
However, Translytical Task Flows do not only support Free Text as an input type for the users of your reports. All of the new & updated Power BI Slicer visuals work with Translytical Task Flows, and we can use List and Button slicers for users to add categorical data to our task flows too.
Read on to see these other options in action.
Leave a CommentKellyn Gorman continues a series on PostgreSQL for Oracle DBAs:
As an Oracle DBA venturing into the world of PostgreSQL, one of the most important areas to get comfortable with is performance tuning. While Oracle’s Cost-Based Optimizer (CBO) is a well-known powerhouse that many DBAs have learned to both respect and wrestle with, PostgreSQL offers its own sophisticated query planner that behaves differently. Understanding these differences is key to becoming proficient with PostgreSQL as we step into tuning.
Read on to gain an overview of what options are available on the PostgreSQL side and how they differ from what’s available in Oracle.
Leave a CommentAaron Merrill shares some news:
It’s been almost 3 months since we announced OneLake security at FabCon 2025 in Las Vegas, and while the interest has not slowed down, we’ve also been working behind the scenes to improve the feature and address your feedback. In this blog post, we’ll go through some of the latest updates on OneLake security including further support for OneLake shortcuts, improved RLS authoring, and updated permissions to manage OneLake security.
Read on to see what has changed.
Leave a CommentI’ve written previously about auditing or cracking SQL Server login passwords either online (inside the instance itself) or offline (exporting the hashes and using a specialized cracking tool).
Last week, Microsoft’s Pieter Vanhove published a blog post that covers What’s new in SQL Server 2025 security.
This is one of the few instances in which I’d prefer things be slower in the database.
Leave a Comment