2018-09-21 (first published: 2016-01-04)
6,352 reads
Site Owners
2018-08-10 (first published: 2015-10-05)
4,915 reads
Simple Talk is hiring a full-time editor
Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!
2017-08-01 (first published: 2017-07-28)
4,722 reads
The Future is Now - An Internet of Things Infographic
A look at the positive and negative aspects of IoT in this infographic.
2017-02-01
248 reads
2017-01-03
2,386 reads
Learning SQL Server 2016
Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.
2016-10-28 (first published: 2015-06-22)
14,421 reads
Write for SQLServerCentral - Bonus for Azure
We're always looking for articles, but here are a few ones that I'd like to see written up.
2016-04-29 (first published: 2014-09-04)
1,987 reads
2015-11-09
114 reads
Learning the Query Store
Links and references to understand what the Query Store is in SQL Server 2016.
2015-09-28
2,823 reads
Learning Stretch Database
References and links about the Stretch to Azure feature in SQL Server 2016.
2015-09-21
1,379 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
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