2012-04-05
2,700 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
2012-04-04
627 reads
2012-04-04
2,087 reads
Too Many Bricks, Too Much Data
Too much data can be as much of a problem as too little. Today Steve Jones talks about some problems that we have in working with lots of data and how we might address the issues. Those that do well, will succeed in the future.
2012-04-03
194 reads
Skipping April Fools
No April Fool's jokes from SQLServerCentral this year and Steve explains why today.
2012-04-02
283 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
938 reads
Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,376 reads
2012-04-02
3,219 reads
Backup and Restore
Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
2012-03-30
214 reads
Spring SQL Server Connections / DevConnections
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...
2012-03-30
2,683 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