New Book on Query Optimizer
Benjamin Nevarez (blog) has been working really hard on a book on the Query Optimizer. It just got finished in...
2010-10-26
597 reads
The Scary DBA
Another Must See Session
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
440 reads
SQL Rally Voting
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
607 reads
Who You Learn From
Less than two weeks to go until the PASS Summit. I’m excited. I’ve managed to cram a ton of activities...
2010-10-25
676 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,434 reads
Upcoming Speaking Engagements
I’ve got a couple of more sessions before the big two at the PASS Summit. Tomorrow night, October 20th, I’ll...
2010-10-19
713 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-18
3,164 reads
Scary DBA Takes Over the World
Or, at least gets translated into Russian.
I realize I’m effectively a 10 year old, but, come on, HOW COOL IS...
2010-10-15
600 reads
Working the Door
You know those guys that work the door at clubs, seperating the wheat from the chaff, culling the herd, Choosing the Slain, sifting...
2010-10-14
713 reads
Speaking at SNESSUG
I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as...
2010-10-13
688 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
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...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
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
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