Steve's SQL Server Blog

SQLCMD + SQLDIAG

I stepped in some cat food on my way to my computer. It was duck I believe. Darn #@! cat...

But nevertheless, today I played around with SQLCMD mode in Management Studio. 
When running the following script, the SQLDIAG STOP_ABORT immediately gets executed before the stored procedure has even started.

:!! SQLDIAG /R /Q /O"C:\SQLDIAGResults"
:!! SQLDIAG START

EXEC my_proc
GO

:!! SQLDIAG STOP_ABORT

A small workaround I found as I thought it might help if a wrap the execution of the proc: put the exec proc statement in a try and cath block

:!! SQLDIAG /R /Q /O"C:\SQLDIAGResults"
:!! SQLDIAG START

BEGIN TRY 
    EXEC my_proc
END TRY

BEGIN CATCH
    SELECT
        ERROR_NUMBER() AS ErrorNumber,
        ERROR_SEVERITY() AS ErrorSeverity,
        ERROR_STATE() AS ErrorState,
        ERROR_PROCEDURE() AS ErrorProcedure,
        ERROR_LINE() AS ErrorLine,
        ERROR_MESSAGE() AS ErrorMessage;
END CATCH;
GO

:!! SQLDIAG STOP_ABORT

A try and catch statement never hurts does it...

Simple SQL Server Database Schema Printer (ASP.NET)

Check this out: A webpage that gets all the tables, their column names, column data types and other information from an SQL Server database.

SQL Server 2008 Exams

The new SQL Server 2008 MCTS exams are expected in august 2008. Need to find a spot in my brain to fit that in.

Read more

Next Belgian SQL Server User Group evening on Thu, March 27

SQL Server, ears, noses and throats

I grew up between resistors, capacitors, solder and oscilloscopes. It was obvious I followed my old men footsteps so I went to a high school where I could choose to study electronics. (Later on I studied clinical chemistry but did not finish it because of illness).

Although I was not a bad student I never became good at it (electronics that is). But it learnt me to see and understand the interaction between hardware and software. A few days ago someone told me I am desperately in need of a vacation because I dreamt of an electric shaver with sensors, a data logger with an embedded SQL Server which pushed data about rotations and so on to another SQL Server when connected to his cradle to power up. And from there on import the data in a mini datawarehouse with Reporting Services reports on top. Now I can see it's somewhat ridiculous (but not really).

This is where my next "project" comes in I dream about...I wonder what hospitals do with the data from the patients personal charts like temperature, blood pressure and so on. Does it get logged into a database? Let's say it would be in a database, what do they do with that data in a perspective view of all patients? That keeps one thinking huh? I mean, reports would be nice to have in a hospital with +500 beds to figure out which floor e.g.: hart diseases, ottorhinolarynologie (ear, nose, and throat). Even more, what about connecting all those databases nationwide? What about data mining?

Maybe I do need a vacation

Steve

I so totally suck

My girlfriend is currently attending a yoga teacher training in Los Angeles. This was planned way back in 2007.
She asked me to come as well but since I'm not really fond of yoga I said: what on earth am I going to do over there if you're in training 12 hours a day for 10 days long?!

It turns out the Heroes Happen Here event takes place in LA during that period!!!
I think I'll crawl in small corner space now and wheep a little bit.

Please do not comment. Can't handle it now