2026-02-16 (first published: 2006-10-06)
384 reads
2026-02-16 (first published: 2006-10-06)
384 reads
Windows is changing its security, which will affect SQL Server.
2026-02-14
346 reads
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were […]
2026-02-13
63 reads
Steve discusses privacy and data that is publicly available on the Internet.
2026-02-11
85 reads
There have many many times when a company or individual has thought that DBAs aren't needed. Steve doesn't think that has ever been true, nor will it be anytime soon.
2026-02-09
213 reads
There is a temptation, especially in technology, to mistake momentum for maturity.
2026-02-07
119 reads
2026-02-06
108 reads
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
2026-02-04
86 reads
2026-02-02
152 reads
I'm very humbled and honored to be able to type this next sentence. My friend, Buck Woody, sometimes gives me book recommendations. Except, with Buck, you have to understand, it's not really a recommendation. It's an assignment. There'll be a test later. You had best have studied. Failing, well, let's not discuss that, it's too […]
2026-01-31
72 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
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