When Do You Take a Full Backup?
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-15
777 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
Tricky Questions
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
2011-08-12
434 reads
2011-08-11
2,104 reads
Data Matters
Data is important, but today Steve Jones notes that what we do with it is even more important.
2011-08-10
113 reads
Two Types of Tail Log Backups
In a recent thread I noted that a tail log backup is essentially a regular log backup, but made with...
2011-08-10
4,156 reads
The Window Is Shrinking
Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.
2011-08-09
134 reads
Hardware Hacking
Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?
2011-08-08
146 reads
2011-08-05
308 reads
The Woes of Cloud Computing
Steve Jones talks about the problems you might face when moving to cloud computing and the fact that you ought to be prepared to move at some point.
2011-08-04
160 reads
A Really Bad Day
I was out of town for work one day, literally on the other side of the country, in a car...
2011-08-03
867 reads
Blogs
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
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