Beyond Avatars: How Gravatar is Transforming Online Identity
Seven things every WordPress user should know about Gravatar
2024-08-08
15 reads
Blog Posts
Clearer Writing at Your Fingertips: Introducing Write Brief with AI (Beta)
From the team at Jetpack AI comes a new tool that will improve your writing in a flash.
2024-08-08 (first published: 2024-08-06)
22 reads
DevOps Days Minneapolis–Best Practices for Database Deployments
Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...
2024-08-08
15 reads
Classifications and sensitivity labels in Microsoft Purview
I see a lot of confusion on how classifications and sensitivity labels work in Microsoft Purview. This blog will help to clear that up, but I first must address...
2024-08-07 (first published: 2024-07-24)
372 reads
Simple Talks–Episode 3
The third episode of Simple Talks is out. This is the new Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links...
2024-08-07
70 reads
T-SQL Tuesday 177: Managing database code
I am excited to host the T-SQL Tuesday blog party for August 2024. I’ve done this many times, but I always remember when I was new to the community...
2024-08-07
21 reads
Updating dbatools–Fixing the Certificate Failure
I was trying to update my dbatools install to test something and go this error. I fixed it with a little help. The Fix The short answer from Chrissy...
2024-08-07 (first published: 2024-07-24)
517 reads
How much space can I expect to recover from a rebuild after dropping a column?
In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to...
2024-08-05
8 reads
SQL Server Cross Platform Availability Groups and Kubernetes
Say we have a database that we want to migrate a copy of into Kubernetes for test/dev purposes, and we don’t want to backup/restore. How can it be done?...
2024-08-05 (first published: 2024-07-26)
325 reads
The Redgate Summit: New York
The final 2024 Redgate Summit in the US takes place in a few weeks, on Aug 21. Redgate Summit: The Database Landscape is coming to the Microsoft Office at...
2024-08-05
17 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers