PowerShell ISE Crashes
Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh...
2018-11-19
535 reads
Jason Brimhall
Monitor Database Offline Events
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend...
2018-11-15
125 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...
2018-11-13
6 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when...
2018-11-13
953 reads
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one's career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change....
2018-11-13
2 reads
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other...
2018-11-09
27 reads
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be...
2018-11-09
2,284 reads
Cannot Use the Special Principal – Back to Basics
Cannot use the special principal 'dbo'. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for...
2018-11-07
419 reads
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run...
2018-07-26 (first published: 2018-07-16)
2,486 reads
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,188 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers