Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
509 reads
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
169 reads
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
201 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
274 reads
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
297 reads
This month’s topic: Let’s get all Posh – What are you going to automate today?
T-SQL Tuesday is a monthly blog party...
2017-09-11
291 reads
Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...
2017-08-28
999 reads
Beware the automated backup window when running native SQL Server backups in RDS
If you’ve ever fired up an RDS instance...
2017-08-04
2,272 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-06-13
326 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-05-25 (first published: 2017-05-09)
1,663 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers