AWS RDS Restore To A Point In Time
The single most important part of backups are not backups. The single most important part of backups are restores. It doesn’t matter a lick if you have 100, flawless...
2022-08-29
2 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
AWS RDS Backups
One of the things I love the most about Platform as a Service when it comes to data is the fact that you get RDS backups, built in. Go...
2022-08-22
1 reads
Extended Events for Anything but Query Tuning: Object Changes
I hear this one all the time: How do I find out who implemented object changes? I also get: Can I see the query that caused object changes? Let’s...
2022-08-22 (first published: 2022-08-08)
286 reads
Thank You Tim!
Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...
2022-08-12 (first published: 2022-07-26)
238 reads
Thank You Andy!
I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...
2022-08-02
9 reads
Database Fundamentals #32: Create Unique Constraints with T-SQL
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
54 reads
Thank You Wendy!
I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...
2022-07-19
12 reads
Sabbatical!
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
3 reads
Thank You Allen!
I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...
2022-07-12
103 reads
Extended Events for Anything But Query Tuning: xml_deadlock_report_filtered
One of my favorite little bits of information about Extended Events is the fact that everyone running a full instance of SQL Server has deadlock information available to them,...
2022-07-11
12 reads
Blogs
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
Full-Text Search in SQL Server: A Comprehensive Guide
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
Reading JSON Data with Python
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Forums
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
using Openrowset to access delta files in ADLG2
Dears, I was told that I cannot access delta files in SQL Server Managed...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers