2021-12-06
328 reads
Editorials
Holiday Fun for Your Career
The Advent of Code is live, and Steve finds it to be a fun way to take a break during your day.
2021-12-04
294 reads
When to Use a Database
While relational developers and administrators might always want to use a database, that might not be the case for those that analyze data. Steve suggests you help them see the value of a database platform.
2021-12-03
487 reads
Building a Production Database
Lessons learned from building a database caught Steve's eye, and he has a few comments.
2021-12-01
616 reads
2021-11-29
198 reads
It's All About the Gratitude
I'm writing this the day after the US holiday of Thanksgiving. Lots of things are said about Thanksgiving, positive, negative, in between. The core concept of the holiday is to take a moment to take stock of what you have. It's a good idea. Every so often, look around and acknowledge, depending on anyone's situation, […]
2021-11-27
106 reads
2021-11-26
194 reads
2021-11-24
260 reads
The Complexity of Modern Systems
Building software is hard, and our systems are very complex these days.
2021-11-22
375 reads
PASS Data Community Summit 2021 Report
The 2021 virtual PASS Data Community Summit was held from November 8th through the 12th. PASS Summit has always been the biggest yearly conference for database professionals, and this year’s virtual conference had over 18,000 individuals registered! If you signed up for the event, you may now stream the sessions on-demand. This is an exclusive […]
2021-11-20
351 reads
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