I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
364 reads
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
364 reads
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-04-11
328 reads
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
844 reads
Whoa. I’m way behind in my blogging.
For the month of May, my MVP choice is Bob Pusateri (B|T).
Bob is a...
2016-10-06
445 reads
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...
2016-09-22
455 reads
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would...
2016-09-27 (first published: 2016-09-19)
1,320 reads
The April MVP nomination is Chris Yates (B|T).
Chris is one of those individuals that always have a positive outlook on...
2016-04-28
877 reads
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
490 reads
The March nomination is Gareth Swanepoel (B|T).
If you don’t know Gareth you should make it a point to get to know...
2016-03-31
771 reads
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to...
2016-03-29
890 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