SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: June 2007

Debugging Stored Procedures in VS 2005

My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk through of how to set up and use the VS debugger on procs. According to an MSDN article he includes it still requires sysadmin permissions to debug though, limiting it…

Read more

0 comments, 1,357 reads

Posted in SQLAndy on 27 June 2007

Celko Cites Steve Jones

I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL Programming Style and was mildly startled to see him reference a couple of Steve's articles (Coding Standards Part 1 and Coding Standards Part 2). Worth taking a look…

Read more

0 comments, 1,396 reads

Posted in SQLAndy on 20 June 2007

GO More than Once?

SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and when I followed along on the associated discussion came across an interesting comment that noted in SSMS you can add an integer param to GO to have it execute the…

Read more

3 comments, 1,354 reads

Posted in SQLAndy on 18 June 2007

Tampa Code Camp 2007

Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go again this year, along with my sometime sidekick Chris Rock if he can get away from work. Code Camps offer the same kind of variety you'd find at a…

Read more

0 comments, 1,339 reads

Posted in SQLAndy on 12 June 2007

Mirrored Backups Posted on SSC

This was fun to run through, nice to see MS adding features even if in my view they didn't quite bake the whole cake. Click here for the article.

Read more

0 comments, 1,318 reads

Posted in SQLAndy on 12 June 2007

Clustered Index Seek or Key Lookup

When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may no longer be true after the service pack because of subtle or no so subtle changes made by MS. I was lucky enough to have an example of this show…

Read more

0 comments, 1,703 reads

Posted in SQLAndy on 4 June 2007