The Reliable DBA
One of the important qualities for a database is being reliable. However, as your organization grows, you might need to ensure that your account for your people as well.
2023-06-23 (first published: 2018-03-13)
251 reads
Editorials
Who's Responsible?
If mistakes are made, employees can be held financially responsible by some companies. Do we need to worry about this in our industry?
2023-06-21 (first published: 2017-08-29)
203 reads
Highly Skilled
The highly skilled people are changing and getting jobs. A recent report notes this is of concern to executives and hiring practices may be changing. Steve has a few hints for how you can grow your own career and find new opportunities.
2023-06-19
230 reads
Same Language, Different Words
I had to come to the Redgate office in Cambridge this past week for a department onsite. As a result, my wife and I were able to come early for a few days adventuring together, the first trip we've taken by ourselves in nearly seven years. As a large family with six kids, it takes […]
2023-06-17
134 reads
Free Tools, Does Innovation Matter?
Today we have a guest editorial from Brian Walker, the developer for SQLFacts. He discusses the value from his toolkit and why it can be useful for developers.
2023-06-16
278 reads
Actively Choosing Compatibility
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
2023-06-14
1,661 reads
Using the Lightweight Tools
This week Steve is interested in whether the newer lightweight environments, like VS Code and Azure Data Studio, are capturing your interest.
2023-06-12 (first published: 2019-12-19)
862 reads
Software Flexibility (Avoiding the next hack)
As computer scientists, it often feels like our job is to tell the business user, "No, we can't do that because the software you asked for, and we built, doesn't allow it ..." Then, after a long and relatively silly meeting where your soul dies a little, the business user typically gets 80% of what […]
2023-06-10
100 reads
2023-06-09
156 reads
Creating Test Data
This editorial was originally published on Jan 9, 2020. It is being re-run as Steve is out of town. Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer […]
2023-06-07 (first published: 2020-01-09)
494 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