Computed Columns and Divide by Zero
I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...
2012-02-07
4,488 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
Feedback and Big Data
Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.
2012-02-07
120 reads
2012-02-07
2,289 reads
Insider Security Threats
The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.
2012-02-06
106 reads
2012-02-03
237 reads
Old Dog, New Tricks
Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well.
2012-02-02
567 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,587 reads
2012-02-02
3,417 reads
A few quick time calculations
Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you...
2012-02-01
1,105 reads
Disk Drives in the Sky
Steve Jones talks today about storage innovations from the large cloud vendors and how that can relate to your job as a database professional.
2012-02-01
118 reads
Blogs
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
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...
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