Turn Rows into Columns in Excel
Have you ever had to take a long column of data in Excel and turn it into a column? There...
2010-11-22
364 reads
Have you ever had to take a long column of data in Excel and turn it into a column? There...
2010-11-22
364 reads
Hey folks, Just a quick preview that we’re hard at work again on a new book with Wiley publishing focused...
2010-11-21
500 reads
Hey there folks! I am sorry it has been about a week without an entry.I have been on planes all...
2010-11-21
325 reads
After the great time everyone had at the PASS Summit this past week I am getting asked more and more...
2010-11-21
361 reads
Hey folks, I recently had the privilege of joining my hometown user group South Florida SQL Server User Group for...
2010-11-08
369 reads
I had some fun last week presenting to the Space Coast User Group in Melbourne as well. They were so...
2010-11-08
327 reads
In life there are not many guarantees. For DBA’s and developers there are a few:
1. Backups will become corrupted but...
2010-11-01
395 reads
For those of you who have seen our team present, we always do our best to make it really informative,...
2010-10-28
1,025 reads
I don’t mean a LaRock aka SQLRockstar, but an actual rock.
I was at dinner last week after our all...
2010-10-26
376 reads
Hey Gang,
Sorry for the absence. I have been offline for a bit dealing with some family stuff. All if good...
2010-10-26
372 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