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
Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Recovering Data from a Backup with SQL Data Compare
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
Data Lakehouse defined
By James-Serra
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk...
Forums
@@TRANCOUNT = 2?
Just a curiosity question... When executing a DML statement in autocommit (normal) mode, the...
MS SQL Group by
SELECT YEAR(A.AppointmentDate) AS [Year], ATS.[Description] AS AppointmentSource, MONTH(A.Appointmentdate) AS MonthNumber, COUNT(A.AppointmentID) AS NumberOfAppointments FROM...
Unable to manage subscription.
I am working on troubleshooting an issue with the report server. I am able...
Ask SSC