The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
281 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
Additional Use for sp_statement_completed
Another discussion in Gothenburg (such a great group of people) around Extended Events lead to a (admittedly, tiny) idea for an additional use for sp_statement_completed. The basics for sp_statement_completed...
2024-10-09 (first published: 2024-09-23)
392 reads
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the...
2024-09-25 (first published: 2024-09-16)
154 reads
2024-09-21
165 reads
Missing Columns in Extended Events Live Data Explorer
Let me be extremely clear up front, this is not my original work. I saw this post on DBA.StackExchange.com and I wanted to share and promote it. Nice work...
2024-09-18 (first published: 2024-09-02)
148 reads
AWS RDS PostgreSQL Restore to a Point in Time
One of the single biggest reasons to go with a Platform as a Service (PaaS) offering like AWS RDS are the things it does for you, like making it...
2024-09-13 (first published: 2024-08-26)
123 reads
What Are the Most Common Blockers to Adopting SQL Server Extended Events?
Yeah, stupid long title. It’s a question I put to several different AI engines. I’m curious what the aggregated knowledge of the internet has to say on the topic...
2024-09-09 (first published: 2024-08-19)
320 reads
State of the Database Landscape Survey 2024
Hello all! This post is nothing but a simple request. Please, if you have a few spare minutes, meander on over to this link and fill out the State...
2024-09-04 (first published: 2024-08-13)
165 reads
Observing Extended Events
Sure, you can right click on a running session for Extended Events and open the Live Data window, but are there other ways of observing what Extended Events is...
2024-08-28 (first published: 2024-08-12)
211 reads
Outside Interests
I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital […]
2024-08-24
78 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
Alamat BCA KCP Palmerah Telp:0821°7555°651
Telp/Wa 62 8217555651 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama,...
Alamat BCA KCP Menara Palma Telp:0821-8200-203
Telp/Wa 62 8218200203 Ariobimo Sentral, Gedung Menara Palma, Jl. Hr. Rasuna Said Ground Floor,...
Alamat BCA KCP GAMA Telp:08218200233
Telp/Wa 62 8218200233 Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers