<Denis Gobo’s mode on> Suppose you have an empty table:   SELECT COUNT(*) FROM SampleTable --- 0   What would be the result of the following query:   DBCC CHECKIDENT('SampleTable', RESEED, 1) INSERT SampleTable(j) SELECT 1 SELECT SCOPE_IDENTITY()   <Denis Gobo’s mode ...

 When you run NUnit/C# unit tests against your local instance, you are a dbo. As such, you are not getting any errors caused by missing permissions. However, you can impersonate another user, and run your unit tests in the context of that other user. The following test harness demonstrates the ...

Tech Ed 2008 included some major announcements for database development folks. One of the biggees was this - and announcement that Database Edition is going to support DB2 development! Gert and the team have been working hard to expand the underlying architecture and functionality of Database Edition (making it extrememly difficult for ...

Well, I have just finished a series of articles about unit testing on simple-talk.com, and some techniques were not included, just to keep the articles short. Still problems such as reproducing a lock timeout and unit testing the retry after it (lock timeout) are interesting, at least to me, so I am continuing. You will need the ...

''My name is Andy Leonard. I tweet.'' ''Hi Andy, we love you.'' It's true, I am a bona fide Twitter-holic. If you use the service you may have noticed disruptions lately. Frank La Vigne (recently married - congratulations Frank!) blogged about it. The Twitter developers are blogging about it. And they have raised the ire of Mr. Scoble, who ...

The transcript of the first few minutes of the .Net Rocks Show on Database Testing is in the new issue of CoDe Magazine! Coincidentally, I was presenting on the topic of Database Testing in Roanoke, VA a couple weeks back when the Roanoke Valley .Net User Group received their copies of CoDe Magazine. Robin Edwards (aka Geekette) asked at ...

I'll be presenting Testing the Database to the Roanoke Valley .Net User Group Thursday 3 April 2008. If you read this blog and you're in the area, stop by and introduce yourself! :{> Andy

In late February I recorded an interview on Database Testing with the cool guys at CSTechCast! :{> Andy

I am honored to be the guest of a .Net Rocks! show on Database Testing! Richard Campbell, Carl Franklin, and I recorded the show last night and I had a lot of fun! Richard and I commiserated about the ''DBA condition'' in the enterprise. Everyone shared ''war stories'' about projects. A good time was had by all. I have to thank ...

Now that our 5-month old son - Riley Cooper - is on the mend, I am hitting the speaking trail again! 09 Jan 2008: I'm presenting Testing The Database to the Triangle .Net User Group (TRINUG) Wednesday evening in Research Triangle Park, NC (location details). 12 Jan 2008: I'm presenting Incremental Loads With SSIS - by far my most popular SSIS ...