Cursors Without Performance Penalties
Imagine how coding might take place if cursors were as efficient as complex SELECT statements.
2020-04-01
363 reads
Editorials
2020-03-31
67 reads
Now Is a Good Time for Choices
The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]
2020-03-28
128 reads
Taking Stock of Your Career
With almost a quarter of 2020 gone, Steve notes it's be time to stock of your career.
2020-03-27
498 reads
A Data Controversy
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
149 reads
The Challenge of Contracting
The nature of work might be changing, and Steve has a few thoughts on thinking about your job as always contracting.
2020-03-25
116 reads
2020-03-24
110 reads
2020-03-23
240 reads
Azure Data Studio and Deployment Notebooks
Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]
2020-03-21
223 reads
What's the Cost of an Hour?
Outages can be expensive, and today Steve asks if you know just how expensive they are for your organization.
2020-03-20
124 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers