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)
244 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Three Mile Island And Your Databases
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
100 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
12 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
87 reads
Query Tuning, Why Bother?
Today Grant wonders why we spend so much time trying to learn about query tuning.
2022-07-23
300 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
21 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
6 reads
Time To Recharge
Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday. I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll […]
2022-07-16
141 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
109 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
25 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers