Storage Benchmarking with DiskSpd
As I mentioned in my storage benchmarking post, storage performance is one of the critical infrastructure components underneath a mission-critical...
2015-04-09 (first published: 2015-04-01)
18,295 reads
As I mentioned in my storage benchmarking post, storage performance is one of the critical infrastructure components underneath a mission-critical...
2015-04-09 (first published: 2015-04-01)
18,295 reads
Today at 11am Central time I will be presenting a new session entitled “Journey to Being a Consultant” for the...
2015-04-08
527 reads
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...
2015-03-23
461 reads
Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to...
2015-03-23
409 reads
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...
2015-03-16 (first published: 2015-03-09)
5,232 reads
I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be...
2015-03-13
535 reads
This Thursday I will be joining an open discussion with Tegile Systems and the Lincoln SQL Server Users Group on...
2015-03-04
474 reads
I am pleased to be presenting a highly interactive session tomorrow evening that is a full end-to-end setup and management...
2015-03-03
423 reads
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...
2015-02-23
1,373 reads
I just returned home from this year’s SQL Cruise in the Caribbean. WOW!
This trip was our first SQL Cruise, but it...
2015-02-19
803 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