Starting to Use Powershell
I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of...
2014-01-30
1,779 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
The DBA is Dead
Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.
2014-01-29
483 reads
Servicing SQL Server in the Future
There hasn't been a service pack for SQL Server in a long time. Without knowing the plans for the future, Steve Jones asks you to express your own opinions.
2014-01-28
217 reads
Management at Scale
Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.
2014-01-27
194 reads
Powershell in a Month Day 13 – Remote Control
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-27
1,049 reads
Common Checks
This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.
2014-01-24
220 reads
Too Much Choice
More information and choice are generally good things, but there can be problems. Steve Jones notes that we can't let freedom paralyze us.
2014-01-23
123 reads
Powershell in a Month Day 12 – A Practical Interlude
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-22
866 reads
Software in 2014
What's the state of software in 2014. After reading Tim Bray's analysis, Steve Jones presents his.
2014-01-22
218 reads
Using multiple CTEs in one query
This is a fairly simple thing to do, but I had to look it up the other day and thought...
2014-01-22
1,397 reads
Blogs
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...
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...
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