Database Backups: Things You Need To Do Now
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,164 reads
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,164 reads
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,730 reads
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways...
2011-12-14
1,932 reads
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,169 reads
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,699 reads
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did...
2011-12-06
1,581 reads
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,600 reads
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,323 reads
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server...
2011-11-21
2,016 reads
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the...
2011-11-18
1,481 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