I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,457 reads
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,457 reads
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,860 reads
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,430 reads
And we’re off. We opened with a video of people saying “Connect, Share, Learn” and “This, is Community”
Rob Farley & Buck...
2011-10-14
1,331 reads
Bill Graziano has come out on stage, looking marvelous, in a traditional kilt and stockings. Thanks Bill.
For those who don’t...
2011-10-13
1,089 reads
This is Day 2 of the Summit proper. But for me, this is the fifth day of the Summit and...
2011-10-13
1,016 reads
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note....
2011-10-12
987 reads
I’m working on updating my book, Query Performance Tuning Distilled, so that it reflects the new things available in SQL...
2011-10-05
1,821 reads
No, I’m not talking about hubs and switches. I’m talking about people. Networking is a major component of an event...
2011-10-03
1,149 reads
Just a reminder that there are a few seats left for SQL In The City: LA on the 29th of...
2011-09-30
1,520 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
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