Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2008

WSUS 3.0 - Query to Return Systems That Haven't Checked in Within the Week

I've been playing with WSUS lately and I've been less than satisfied with the reporting. Since the information I need to get at exists in a SQL Server database, I've been writing my own queries to get it out. Here's a basic query to get out what systems in a… Read more

0 comments, 600 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 September 2008

Mechanical Blog Posts

Mechanical posts are ones that are either auto-generated, or manually input with no real additional work put into them - an example of this in action is if you use Delicious to auto post to your blog each time you add a bookmark. This technique has it's place, but it's easy… Read more

0 comments, 390 reads

Posted in SQLAndy on 22 September 2008

The Agile Cult

Why did I write this? I got challenged by Andy Warren to write a bit about why I wrote something. I complained to him that he has some "mechanical" posts on this blog that just mention he wrote something with some questions, and don't really blog about why he wrote… Read more

0 comments, 340 reads

Posted in The Voice of the DBA on 22 September 2008

The quiet is deafening...

It's been a while since I've written a blog post that wasn't a user group announcement. Here's what I've been up to:

  •  Working on a security chapter for a forthcoming in-print book on SQL Server 2008.
  •  Playing a lot of Heroscape with my boys.
  •  Helping develop the junior high youth ministry…

Read more

0 comments, 262 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 September 2008

Laptops Part 1

I've been using a Dell Latitude for a looong time, probably going back to 2000 or 2001. Decent machine - though I imagine that there's not a lot of difference across brands, was just that the company I worked for at the time was a Dell customer. Recently my partner… Read more

0 comments, 244 reads

Posted in SQLAndy on 21 September 2008

DBA team building

Whenver we start a somewhat big IT project, it is natural for us to build a team dedicated to the project, and the team is usually made up of a project manager, a technical architect, a business analyst, developers, and QAs etc. (Of course, the team can also have some… Read more

0 comments, 1,253 reads

Posted in DBA Philosophy on 20 September 2008

What's Your Favorite Trek Episode?

Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in. Fair warning so you don't consider your time wasted. 

I don't mind admitting to being a long time Star Trek fan, though I've never dressed up as a character or… Read more

2 comments, 260 reads

Posted in SQLAndy on 18 September 2008

Business of Software 2008 - Noah Wasserman

I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston. If you are part of a small technology business (software, hardware, etc.), especially if you are an owner, I'd highly recommend that you attend this conference next year. It's small,… Read more

0 comments, 318 reads

Posted in The Voice of the DBA on 18 September 2008

Tampa Code Camp is December 2, 2008

In recent years this event has been held in July, but this year they ran into problems when the planned venue placed a cap of 250 attendees on the event. Rather than turn people away organizer Keith Kabza postponed the event until a better location could be found. Call for… Read more

0 comments, 172 reads

Posted in SQLAndy on 17 September 2008

Business of Software 2008 - Richard Stallman

I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston. If you are part of a small technology business (software, hardware, etc.), especially if you are an owner, I'd highly recommend that you attend this conference next year. It's small,… Read more

0 comments, 461 reads

Posted in The Voice of the DBA on 17 September 2008

Cross Functional Teams & Cross Training

Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it. Several years ago when I took on management of a team of developers one of the first things I… Read more

0 comments, 179 reads

Posted in SQLAndy on 16 September 2008

Business of Software 2008 - Selling 101

I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston. If you are part of a small technology business (software, hardware, etc.), especially if you are an owner, I'd highly recommend that you attend this conference next year. It's small,… Read more

0 comments, 329 reads

Posted in The Voice of the DBA on 16 September 2008

Relaunching JumpstartTV.com

We experimented with some video training back in 2004/2005 on SSC, but we just didn't have the time/energy to pursue it, and we didn't see at that time a lot of interest. Eventually Brian decided to put some time into it solo and out of that came JumpstartTV.com. It… Read more

0 comments, 171 reads

Posted in SQLAndy on 15 September 2008

Kindle - Chapter by Chapter

I haven't done as much reading on the Kindle since I've been home from my last trip, mainly because I've been outside pounding nails more often than usual. However there's another reason as well.

I used to force myself to alternate one fiction with one non-fiction book as I read… Read more

0 comments, 294 reads

Posted in The Voice of the DBA on 15 September 2008

Business of Software 2008 - Pecha Kucha

I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston. If you are part of a small technology business (software, hardware, etc.), especially if you are an owner, I'd highly recommend that you attend this conference next year. It's small,… Read more

0 comments, 359 reads

Posted in The Voice of the DBA on 15 September 2008

Announcing SQLSaturday #10 - Tampa 2009

Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are just now getting the site set up, but in the next few days I think they'll be issuing the call for speakers. Pam has done a terrific job in… Read more

0 comments, 159 reads

Posted in SQLAndy on 14 September 2008

SQL Code Review - Scalar Variables

One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows, but assigning a column to a scalar variable, like this:

select @ID = ID from SomeTable

It works, but the results aren't necessarily reliable. Probably the most common place I… Read more

0 comments, 188 reads

Posted in SQLAndy on 14 September 2008

Business of Software 2008 - YCombinator - Jessica Livingston

I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston. If you are part of a small technology business (software, hardware, etc.), especially if you are an owner, I'd highly recommend that you attend this conference next year. It's small,… Read more

0 comments, 268 reads

Posted in The Voice of the DBA on 12 September 2008

Kindle - The Two Week Followup

It's been two weeks since I got the Kindle. Actually it will be two weeks in a few hours. I've divided this post into two sections: Feelings and Recommendations. The first is what I think of it, the second what I think for other people. Feelings I've read (to date) Read more

0 comments, 358 reads

Posted in The Voice of the DBA on 12 September 2008

Vacations Part II

One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing' vacation. For example, over the past few years I've vacationed at Disney World (do something), Cocoa Beach (do something), Sarasota (do nothing). Something to be said for both approaches, depending… Read more

0 comments, 430 reads

Posted in SQLAndy on 11 September 2008

Newer posts

Older posts