Software Patents
Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.
2017-11-07 (first published: 2014-01-30)
159 reads
Editorial
The DBA is Dead
Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.
2014-01-29
478 reads
Servicing SQL Server in the Future
There hasn't been a service pack for SQL Server in a long time. Without knowing the plans for the future, Steve Jones asks you to express your own opinions.
2014-01-28
214 reads
SQL Best practices, policies and code-smells.
Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.
2014-01-27
492 reads
Management at Scale
Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.
2014-01-27
192 reads
Common Checks
This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.
2014-01-24
220 reads
Too Much Choice
More information and choice are generally good things, but there can be problems. Steve Jones notes that we can't let freedom paralyze us.
2014-01-23
121 reads
Software in 2014
What's the state of software in 2014. After reading Tim Bray's analysis, Steve Jones presents his.
2014-01-22
216 reads
Uncontrolled Code
Excel is used quite often to build software, or at least, it's worksheets and formulas simulate software. Steve Jones notes there are lots of problems with this practice.
2014-01-21
272 reads
Redundant Redundancy
When DBAs too often find themselves trading sleep for Megabytes, it's time for a different approach to detection and alerting of disk space problems. So argues Rodney Landrum.
2014-01-20
118 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
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...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
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