Audit SQL Server Extended Stored Procedures Usage
In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.
Knowing Your Total Reward
When you agree to work for a company, you should understand all your compensation.
Returning 0's in a SUM (SQL Spackle)
Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
Using a Service Account in Microsoft Fabric
Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.
When Companies Fail
The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.
Troubleshoot Chained SQL Server CTE
This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.
Tech Debt Perils
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
Data Lake Implementation – Data Lake Zones and Containers Planning
The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.
Are We Dinosaurs?
Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers