Skip to main content

Return Codes, Exit Codes, and %errorlevel%

Gah! The one thing that always gets me with working with so many different programming langauges (C#, T-SQL, Perl, VB, DOS) is that they each tend to refer to the same thing with a slightly different name. (If you read Perl: same foo, different bar). Today when stepping out of T-SQL land and into DOS, […]

Google Reader

I read a lot of blogs everyday. Not every article, but I like to at least skim the headlines and read the ones that really interest me. There’s a lot of interesting things to be learnt by reading outside your immediate field of work too. Anyway, Its hard to check up on ~200 blogs every […]

Granting SQL Server 2005 Profiler Access

If you were a DBA of SQL Server 2000, you’d be familiar with the frustration that encouraging developers to use SQL Profiler as part of performance testing meant you needed to grant the sysadmin privilages. Security best practises mean you should only grant users the minimum permissions needed, and certainly not everyone should be trusted […]

Snippet: Drop all connections to a database

If you want to drop all the connections on you sql server that are accessing a particular database, here’s some code: USE master go DECLARE @dbname sysname SET @dbname = ‘name of database you want to drop connections from‘ DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS […]

SQL Server 2005 @ Tech Ed 2006 Webcasts

As part of Tech Ed 2006, Microsoft has a number of live webcasts on SQL Server 2005, including Encryption, Reporting Services, Analysis Services, and Integration Services. Check out the full list of live webcasts. If you’ve missed earlier webcasts, some of them are appearing as On-Demand Webcasts that you can watch at your leisure. You […]