A Cheap Fix?
Does it make sense to set up another instance of SQL Server just for a power user? Is it a good use of resources? Steve Jones comments today on this DBA tool for enhancing performance.
2010-03-04
157 reads
Editorials
Usage Based Pricing
Software pricing is a controversial topic, but Steve Jones found an article saying many enterprises would prefer usage based pricing. Do you think it's better?
2010-03-03
188 reads
Be Responsible
When getting help online, you need to be professional and a part of that is being responsible. Steve Jones reminds us today that we have to be careful about what we post.
2010-03-02
541 reads
Overusing Identities
Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.
2010-03-01
332 reads
Reaching for the Clouds
This past week's news had a lot of news about cloud computing and Steve Jones comments on a few database related items.
2010-03-01
90 reads
Timing is Everything
For this Friday poll, Steve Jones asks about storing time values. Should they always be in UTC? Does that solve more problems than it creates?
2010-02-26
319 reads
Dude, Your Fly is Open
A guest editorial from Tim Mitchell today talks about the way you handle problems. Other people's problems. A professional way of pointing out mistakes is the best policy.
2010-02-25
303 reads
Data Dashboards
Google recently unveiled a dashboard to allow users to manage the data that Google stores about them. Including removing search data! Steve Jones comments on the possibility of implementing this for other companies.
2010-02-24
401 reads
Multiple Mirrors
Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.
2010-02-23
333 reads
FizzBuzz
Can most programmers not program? A new test, the FizzBuzz test, is being used to weed out candidates. Steve Jones comments on the types of FizzBuzz questions he's used in T-SQL.
2010-02-22
1,455 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
An SSIS Upgrade
Comments posted to this topic are about the item An SSIS Upgrade
Question of the Day
Encoding URLs
I have this data in a 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