Comments on Acceptable Behavior
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...
2012-04-27 (first published: 2012-04-23)
2,616 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
AlwaysOn Failover Bug
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,248 reads
SQL Server Log Backups
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,049 reads
Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,334 reads
TDE and Compression
I knew that enabling TDE would cause the information stored within to, effectively, be randomized, which means it would seriously...
2012-03-19
2,795 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,137 reads
Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
871 reads
Avoiding Bad Query Performance
There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:
That’s certainly not...
2012-02-07
1,205 reads
Meme Monday: Deadlines
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...
2012-02-06
1,208 reads
Learning, Networking & Wine
Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some...
2012-02-01
1,181 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers