Speaking at SQL Saturday South Florida 2024
I’m heading to SQL Saturday South Florida 2024 next week. This is my second time attending the event and if you’re in the Miami area (or want to take...
2024-06-20
30 reads
The Next Phase & A Fresh Start
As of June 1, I am no longer an employee at 3Cloud. I am now officially on long term disability. This marks the first time since I graduated from...
2024-06-20
39 reads
How do you restore a SQL Server 2000 database in the year 2024?
A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported...
2024-07-05 (first published: 2024-06-20)
408 reads
Refreshed in Tuscany
I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t all for work, but it was a long stretch. I spent a good portion of...
2024-06-19
25 reads
The Community is YOU, Not Any Organization
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
36 reads
Polyglot Persistence
I’ve seen the term polyglot persistence floating around Redgate a bit recently in the marketing department. I haven’t really seen this term anywhere, and I wonder if you have....
2024-07-05 (first published: 2024-06-17)
141 reads
Six Months!
Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...
2024-06-17
41 reads
Speaking at dataMinds Connect 2024
I’m very excited to announce I’ve been selected as a speaker for dataMinds Connect 2024, Belgium’s (and maybe/probably/most likely mainland Europe’s) best and greatest Microsoft data platform conference. My...
2024-06-17
22 reads
Async stats update causing blocking
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...
2024-07-03 (first published: 2024-06-16)
121 reads
Level Up Your SQL Skills: The Best Intermediate to Advanced Courses
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a career game-changer. Companies crave professionals who can wrangle data, uncover insights, and drive decision-making. If...
2024-06-16
105 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
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers