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

Archives: September 2009

Off-Hours Work: A Guide For Managers

If you work in software development or IT long enough eventually you're going to find yourself in a situation where you have to work during off-hours; it's just the nature of the job and can happen for a variety of reasons like: hardware failure, a new client is brought on… Read more

13 comments, 1,841 reads

Posted in Kendal Van Dyke on 29 September 2009

SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files

A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to a server and sometimes just connect automatically when a file (or files) gets dragged into the window. Thanks to an "aha!" moment with a coworker I've finally figured out why.… Read more

0 comments, 369 reads

Posted in Kendal Van Dyke on 17 September 2009

Networking While On Vacation

There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall I'm planning on kicking off my PASS Summit experience this year by attending Don Gabor's pre-conference session on starting conversations. It's perfectly reasonable to go to a conference, code… Read more

1 comments, 596 reads

Posted in Kendal Van Dyke on 15 September 2009

How To Get Table Row Counts Quickly And Painlessley

Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve table row counts by using sysindexes & DMVs instead of select count(*). It's a 2 minute read – check it out here (free registration required) and if you like… Read more

0 comments, 434 reads

Posted in Kendal Van Dyke on 2 September 2009