A row has no row number
It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...
2011-05-05
3,973 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Titanic Cloud
The outage at Amazon's Web Services recently affected a lot of different companies. However not everyone was affected. The reach of the cloud and the competition for attention means that while we have to learn to expect failures, they are not necessarily evenly distributed.
2011-05-05
194 reads
2011-05-05
2,418 reads
2011-05-04
2,690 reads
Cascading Human Error
The recent Amazon AWS outage was blamed on human error. Steve Jones notes that the more interconnected our systems are, the more likely that a human error might cause cascades between the systems.
2011-05-03
299 reads
T-SQL Tuesday #18 Coming Next Week
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...
2011-05-03
690 reads
2011-05-03
2,537 reads
Foreign Keys Help Performance
I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...
2011-05-02
1,260 reads
The Intelligence Cloud
More cloud talk today as the Air Force is building a new intelligence sharing system in the cloud? Why the cloud? Is the cloud really better?
2011-05-02
268 reads
2011-05-02
2,360 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers