SQLAndy

Blog Post

Merry Xmas 2009

Hope you’re enjoying a break from the routine and spending quality time with family. Xmas for me is a time...

2009-12-24

681 reads

Blog Post

One Hit Wonders of the 80’s

Happened to channel surf across this on TV, found the list - http://blog.vh1.com/2009-04-01/100-greatest-one-hit-wonders-of-the-80s-read-the-list-2/. Many of the links seem to point to...

2009-12-24

829 reads

Blog Post

Wireless Video

Have not tried this yet, but had it bookmarked to share, the TruLink Wireless USB to VGA will send video...

2009-12-23

723 reads

Blog Post

Keyboard Shortcuts

I’m perusing things I’ve in the ‘blog about someday’ category of my list and found this one – a very nice...

2009-12-22

595 reads

Blogs

The First Steps: Understanding the Basics of FinOps

By

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

By

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

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

By stan

Hi, ssms is free here.   I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

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 REPLACE

See possible answers