Archives: February 2008
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for a great manager except working for one that is also a great leader, and perhaps nothing worse than working for a terrible manager. The tragedy of our profession is that… Read more
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server team know that they can decommission it. I have been looking forward to this for several months. This server hosted our financial accounting database which was upgraded back in August.… Read more
If you are anywhere near St. Louis next Wednesday night, I will be speaking at the St. Louis Visual Basic User Group at 7:00 pm on T-SQL Enhancements for SQL Server 2005 and 2008. Click here for more information: http://www.stlvbug.net/dnn/ .
Just a reminder that I will be teaching a two-day… Read more
Some see this as a misnomer, or even an oxymoron. Many countries don't allow "engineer" to be a title for software because it's not regulated like engineering is. Some think it's a joke, given the state of software development, the constant missed schedules and problems.
User groups have to be about more than technical content if you want to sustain them over the long term, and the best way to create that 'more' is to work on getting attendees to talk to each other. Here in Orlando we experiment with different ways of doing this… Read more
Someone sent me this note about a talk they'd had at their user group and the guest speaker mentioned the following:
- -SQL is not based on “computer science”. He challenged us to come up with a “computer science” term to define a database table. No one could to his…
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend Shawn Weisfeld manages the Orlando .Net group and he posted his thoughts on sponsorship yesterday. The Code Camp Manifesto is where it all started and it definitely focuses not just… Read more
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've incorporated below. I know it probably needs some work on formatting! I think there is also a mix of speaker vs room specific stuff in the eval, making it more of… Read more
I started working through some labs for my SQL Server 2008 class and one of the labs was on the new Change Data Capture, essentially an auditing action that allows you to tell what changes have been made to data in a table, including insertions and deletions. You have to… Read more
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level performance tuning class. It's not a technique you'll apply that often, but I think it's used less often than perhaps it should be. Hope you'll take a look… Read more
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals expert, Kalen Delaney. If you haven't pre-ordered the DVD yet, there's only a few days left to do so at the pre-order price:
2 comments, 769 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 February 2008
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and there, it's probably worth writing down some thoughts about what events like Code Camp and SQLSaturday can do to make being a sponsor more attractive.
- Treat me like a…
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the offices of End to End Training, 225 S Westmonte Dr Ste 2010, Altamonte Springs. We have two speakers scheduled; Dan Wolford doing a product demo of one product from… Read more
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past couple months and it's all about to come together. The almost final schedule is posted and it looks like attendance is going to be very good. I'll be there doing… Read more
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it can be a very handy technique for all that. Strangely it's not supported via the UI, you have to add the subscription manually and then everything works normally from there.… Read more
I was doing some development on my laptop tonight and I was getting fed up with the default font, Courier New, in Visual Studio. On my other laptop I have a different font and I found myself mighty frustrated, because Courier New isn't exactly the easiest to keep staring at.… Read more
1 comments, 1,109 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 February 2008
Actually more it's "our way" as mentioned in Andy's post, and less my way than by committee these days with Red Gate and a few other people helping run the show here at SQLServerCentral.
That was a fundamental decision that we made early on in this business to do… Read more
Part of a conversation I had at the South Florida Code Camp was what I thought about various features that had been added in SQL 2005. I suspect I have an unusual view in some cases, but maybe not! In any case, here's a summary of that conversation:
Had a friend forward this link to me about Chipotle and it's worth reading if you either A, like Chipotle/Mexican food, or B, like to learn from businesses that are well run and growing. I eat there a couple times a month probably for the same reasons many do; inexpensive,… Read more
Windows 2008 RTM'd this week, which means that in a few weeks, at the February Launch event, there will be two products that are shipping and have RTM'd, leaving only SQL Server 2008 as a product that's not yet finished. And likely won't be for 6 months.
Some people have… Read more