Looking Forward to the PASS Data Community Summit 2023
Steve takes a moment to think ahead to the PASS Data Community Summit 2023 and what he's looking forward to at the event.
2023-09-01
109 reads
Editorials
The IT Jobs AI Can't Do
This was a provocative title: 6 ITOps Skills That Will Never Be Automated. In a time when AI use is growing quickly and many people fear for their jobs, it's nice to see someone writing about areas that AI will struggle to handle. Ironically, lots of these articles are written by writers without much technical […]
2023-08-30
223 reads
2023-08-28
287 reads
Be Prepared
I've been reading about the fires in Maui and the horrible loss of life there. My heart goes out to all involved. I hope, if you can, you donate to a good charity to help those poor people. It also inspired me to do another check on our emergency supplies and equipment. No, we don't […]
2023-08-26
100 reads
Removing Weak Security from SQL Server
The password options for BACKUP at deprecated, which Steve thinks is a good thing.
2023-08-25
175 reads
2023-08-23
160 reads
A Real World Clash with AIs
Protesters disable AI vehicles, setting up a clash between digital AIs and the real world.
2023-08-21
181 reads
Using AI with Data Tasks
Steve isn't sure that AI is that helpful with data tasks. It can be, but likely in specific areas rather than helping us with everything and taking our jobs.
2023-08-19
75 reads
Taking Advantage of Conferences
Conferences have been a part of Steve's career for a long time. He talks about how he'd taken advantage of the opportunities he's had.
2023-08-18
71 reads
Code Building Code
Using code to help you write code is a time honored tradition in software development.
2023-08-16 (first published: 2019-04-09)
564 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