Category Archives: Uncategorized

I hope you’ve seen the note from Andy Warren (Blog | Twitter) on a PASS Spring Event, and there’s another writeup from Kendal Van Dyke. The idea of growing PASS by offering another event, in addition to the Summit, that … Continue reading →

Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table like this: DECLARE @t_temp table (ID INT IDENTITY(1,1), Value VARCHAR(20))insert into @t_temp select ‘Win32’ UNION ALL select ‘Win32’ union ALL … Continue reading →

I’ve given quite a few presentations, one keynote with another to come, and attended many more. I’ve read a few books on how to get better, and then in an Edward Tufte seminar recently, I got another one. Dr. Tufte … Continue reading →

I saw a post recently asking if there was an easy way to find the port a client was using on a SQL Server since someone had multiple instances. I asked for some information since there are actually multiple ports … Continue reading →