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
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
2013-08-05
115 reads
DBAs and the Fear of Time Off
Rodney Landrum on why many DBAs find it hard to ask for, and take, their due DBAcations.
2013-05-27
263 reads
To Specialize or Not to Specialize: that is the $132,000 Question
In a guest editorial, Rodney Landrum reflects on his career path as a an information-hungry generalist.
2012-05-28
256 reads
SQL Server 2012: Creative Thinking for a Creative New Licensing Model
It seems inevitable that many customers will end up paying more to get the same features they have today, under the new SQL Server licencing model, unless they respond to Microsoft's creativity with some of their own.
2012-02-06
250 reads
A Cast of Thousands
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
2011-08-01
138 reads
If you could stop working tomorrow, would you still do SQL?
Rodney landrum wonders what, if anything, you would do in SQL, or any other beloved technology, if you did not have to?
2011-03-21
232 reads
Life Without a Net
Today we have a guest editorial from Rodney Landrum that talks about life in the past, when we couldn't look up everything on the Internet.
2010-11-02
220 reads
Hunting and Gathering
A guest editorial from Rodney Landrum looks at how we get advice from others in the wild, wild world of the Internet.
2010-03-26
149 reads
Slipping out of the DBA trenches
Today we have a guest editorial from Rodney Landrum who wonders how DBA Managers, removed from the front lines, can keep up to date and retain their edge. Is it inevitable that, slowly but inexorably, they will feel the 'blunting of the blade'?
2010-01-05
160 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