Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
2008-11-05
135 reads
Editorials
Participation
With Election Day in the US, Steve Jones talks about how you can make a difference. This editorial was originally published on Nov 4, 2008. It is being republished as Steve is out of town.
2008-11-04
77 reads
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week, including Service Pack 3.
2008-11-03
337 reads
Happy Halloween 2008!
Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.
2008-10-31
203 reads
The October 2008 Energy Update
The bimonthly update on the world of energy from Steve Jones talks about wind power.
2008-10-30
76 reads
2008-10-29
894 reads
Updating Aging Databases
Somehow, one is expected to be pleased that SQL Server 2005 is going to have another Service Pack. Why? For many DBAs, SQL Server 2005 is still a dangerous and radical upgrade. Phil Factor considers Microsoft's responsibilities...
2008-10-28
197 reads
Barriers to Entry, Database Weekly (Oct 27 2008)
Many people who spend time contributing to technical forums bemoan the increasing amount of time and energy they expend trying to help people who seem unwilling or unable to help themselves. At the same time, they say, the courtesy is deteriorating and the number of people willing to "stir things up" for the sake of it increases. Is there a solution to this?
2008-10-27
110 reads
Data Trust
How much do you trust companies with your data? Steve Jones finds a couple new web sites that offer great services, but is it worth the price?
2008-10-27
75 reads
Absolutely (Not?)
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
2008-10-24
170 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...
Webinar Series – SQL Server Indexing
I’m starting a webinar series about SQL Server indexing with the fine folks of...
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