Re-Inventing Humanity
Are we Human or Robots ? AI & ML shall definitely change the world some day in future. One thing is also sure, very soon we’ll also become machines...
2020-01-07
1 reads
Why I’m Learning Git via the Command Line Interface
I’ve learned a bit about Git in the last year: I’m now quite comfortable creating and managing Git Repos in Azure DevOps. I frequently do demos with SQL Change...
2020-01-03
Resolving Merge Conflicts in SQL Source Control – the Basics (video)
In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix...
2019-12-27
9 reads
Why You Should Take the 2020 State of Database DevOps Survey today (video)
In this six minute video, I explain why you should take the 2020 State of Database DevOps Survey. The survey is open for a few more days — we’ve...
2019-12-19
Database Reliability Engineering (22 minute video)
I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before. In this 22 minute whiteboarding session, I talk about why we need...
2019-12-18
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
3 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
1 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
21 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
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
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
How to find index usage by stored procedure?
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
Odd things with Report Builder (also tried VS 2019)
This is kinda hard to explain, maybe I can make sense of it. So...
PBM policy to check empty passwords
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...
Ask SSC