2003-06-17
3,083 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
In the Real World - Lost Data Chains
How do you deal with problems in the real world? What steps should you follow? A new series looking at actual experiences at work. This one looks at a weeklong adventure in troubleshooting SQL Server applications.
2003-06-16
4,960 reads
2003-06-16
6,564 reads
2003-06-13
5,966 reads
2003-06-12
4,994 reads
DB2 A Worthy Competitor?
Recently Steve Jones spent a week working with IBM's DB2 database. Read about his thoughts and impressions of this SQL Server competitor.
2003-06-02
6,190 reads
Is the Schema Still Needed?
Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?
2003-05-21
5,221 reads
A Sneak Peak at Windows 2003
Microsoft has been running 2 day seminars on Windows 2003 across the country as well as at selected Enterprise Partner sites. Steve Jones recently attended one and has a first look at the next generation of Windows Servers.
2003-05-15
5,088 reads
Getting Your Server Information
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
2003-04-21
7,067 reads
What's In A Review?
Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.
2003-04-14
3,217 reads
Blogs
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...
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...
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