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

Archives: August 2008

Labor Day

It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to decent working conditions, and it marks the end of summer (here in Fla, that means temperatures will soon be bearable again). Hopefully you're reading this on Tuesday and took Monday off… Read more

0 comments, 1,740 reads

Posted in SQLAndy on 31 August 2008

Kindle - First Thoughts

I got my Kindle yesterday and I'll write some more notes as I go along, but I have to say that it's pretty cool. The buttons are a bit of a problem, but not that bad and I had it next to the bed this morning. With one arm trapped… Read more

0 comments, 1,444 reads

Posted in The Voice of the DBA on 30 August 2008

Defining Value

I've been thinking a lot lately about the concept of value.  Earlier this week a colleague of mine tendered his resignation quite unexpectedly and at a very inconvenient time, a mere four weeks away from the consummation of a 2-year sofware implementation and data conversion project.  Citing health and family… Read more

0 comments, 1,426 reads

Posted in Tim Mitchell on 29 August 2008

Insufficient Space for a Side by Side Restore - What Do You Do?

I was recently working with a student in a one on one format and one the scenarios he wanted to learn to handle in SQL Server (he was an Oracle DBA cross training) was how to recover from the proverbial accidentally dropped table when there wasn't enough space to do… Read more

0 comments, 1,387 reads

Posted in SQLAndy on 28 August 2008

Kindle - About Face

OK, I reversed myself and bought a Kindle today. Or I guess I ordered one and it should be here tomorrow.

I was installing a server into the co-location facility for End to End training and while a few patches were downloading, I checked in Kindles for some reason. I… Read more

0 comments, 1,740 reads

Posted in The Voice of the DBA on 28 August 2008

Reminder: Upcoming SQL Launch Event in Jacksonville, FL on Sep 12, 2008

The Jacksonville SQL Server Users Group (www.jssug.com) is hosting a SQL 2008 launch event on Friday, Sep 12, 2008 in downtown Jacksonville. Plans are for 15 sessions, all focusing on SQL 2008 and most being presented by speakers who live in the greater Jacksonville area. Registration is open at… Read more

0 comments, 1,349 reads

Posted in SQLAndy on 27 August 2008

Comments on a Recent Visit to Boston

Slightly off topic today. 

It's fair to say I'm not a great traveler. Waiting for planes, dealing with the hassles of travel, etc, etc, all result in me prefering to stay in Orlando as much as possible. But I don't quite have the luxury of not travelling at all, and… Read more

0 comments, 1,504 reads

Posted in SQLAndy on 26 August 2008

Tool Review: Quicken

I've used Quicken for a long time now and it's the center of how I manage finances at home. There are similar packages on market from other vendors (MS Money, etc) which probably offer similar features, but I've always liked that Intuit stays focused on their market and I love… Read more

0 comments, 1,342 reads

Posted in SQLAndy on 25 August 2008

Kindle - On Hold

Just as I was debating whether to take advantage of Amazon's $100 savings offer on the Kindle (with a new credit card), I saw this report about Kindles being marketed to college students, which seems like a great idea. I know I'd loved one in college, just to have… Read more

0 comments, 1,921 reads

Posted in The Voice of the DBA on 25 August 2008

Assessing DB Changes

One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central point of change when it comes to being a DBA, we should be adding value:

  • Look at each change and ask ourselves 'is this obviously stupid?'. For example, we might…

Read more

0 comments, 1,416 reads

Posted in SQLAndy on 24 August 2008

Taking Care of Employees - Storms

As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected (good) and authorities have taken steps to cancel school and ask people to stay at home if at all possible just in case (also good in my view). Yes, you… Read more

0 comments, 1,378 reads

Posted in SQLAndy on 21 August 2008

Kindle - On the clock

In a week and a half, I start on the first of my four trips this year for work, and I'll be gone for 17 or 18 days between now and November. So I've been looking at Kindles again, since I'd be talking about buying one to keep from lugging… Read more

0 comments, 1,434 reads

Posted in The Voice of the DBA on 21 August 2008

Deleting Duplicates without a unique key

The following was sent to me by my friend and colleague Dave Miller:

Dave's Email:

Wanted to pass along something I hadn't used before and found useful to easily get rid of duplicates in a set of data. The functionality has existed in the SQL language and was supported in… Read more

SQLSaturday #8 in Orlando - Update (Aug 21)

Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We already have a number of potential sessions submitted and more on the way. Registration and call for speakers is open at http://www.sqlsaturday.com/register.aspx?eventid=11.

If you haven't attended a SQLSaturday before… Read more

0 comments, 1,424 reads

Posted in SQLAndy on 20 August 2008

Troubleshooting High Connections & What's The Application Name?

I was visiting with a client recently when they asked me to come take a look at an incident in progress, the number of connections to the server had just about doubled over what they were normally. As far as troubleshooting this scenario I always start by checking for blocking.… Read more

0 comments, 1,339 reads

Posted in SQLAndy on 20 August 2008

[Off Topic] The Big Apple

I got my first opportunity to visit New York City last week.  I was actually sitting in on a training class in Whippany NJ, which is about an hour away (by train) from the city.  I went over to NYC for both evenings that I was in town to see… Read more

0 comments, 1,521 reads

Posted in Tim Mitchell on 20 August 2008

Notes on My Visit to the St Louis SQL Group

Actually it was subset of the group, but Kathi & Julie from the St Louis SQL Server User Group did a great job of marketing  my free Succesful Technical Speaking class. Microsoft was kind enough to provide both meeting space as well as lunch in a great show of community… Read more

0 comments, 1,384 reads

Posted in SQLAndy on 19 August 2008

Speaker workshop

Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user group.  Several times a year he offers the free workshop at End to End Training in Orlando. We had a pretty good turn out. Hopefully, we will get… Read more

0 comments, 1,294 reads

Posted in Advice from Aunt Kathi on 19 August 2008

What every DBA that manages a large number of SQL Servers should know about SQL 2008!!

Error when importing RegServer list from SQL 2005 to SQL 2008

I discovered the already known bug in SQL 2008 that you can't import a SQL 2005 server list (exported as a regsrvr file). For someone like me who deals with a large numger of SQL Servers, this is a… Read more

Building a Security Philosophy Posted on SQLServerCentral.com

This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written to get people to think about they approach security. Do you give the proverbial Junior DBA only partial access? Do you believe in table access? Do you use the built… Read more

0 comments, 1,472 reads

Posted in SQLAndy on 18 August 2008

Older posts