Welcome to Salvo(z)

SQL 2005, ADO.Net and ArithAbort On/Off

Wednesday, November 26, 2008
by asalvo

I have a stored procedure, that when run from Sql Server Management Studio (SSMS) takes 1 second to run. When invoked from my web application via ADO.Net, it takes > 30 seconds (web application gets a SQL timeout). Running SQL profiler shows that the following commands are executed prior to the execution of the stored procedure:

read more...


New blog and some interesting Win2k8 tidbits

Thursday, August 23, 2007
by asalvo

While looking for information on how to administer a server core install, I came across a new blog resource. http://blogs.technet.com/daven I was able to get a list of command line commands that can be used to get your server core install off to a good start. When the Core installation is finished, you have a server with an unknown name, with a blank administrator’s password in a workgroup.

read more...