Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...
2019-12-10
524 reads
What would you say you do here?
The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the...
2019-12-09
12 reads
Installing Redgate SQL Toolbelt with Chocolatey (video with transcript)
Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line. Spoilers: The command I show in...
2019-12-02
37 reads
My Git CLI Cheat Sheet
I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video. I find the Git CLI to...
2019-11-27
29 reads
Upcoming Free Webinars on Database Development and Operations
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
7 reads
2019-11-16
10 reads
2019-11-16
15 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
29 reads
2019-11-06
10 reads
2019-11-06
13 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...