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

Archives: February 2008

Management Article Posted on SSC

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

0 comments, 619 reads

Posted in SQLAndy on 18 February 2008

Turning off a server causes a flood of memories

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

0 comments, 364 reads

Posted in Advice from Aunt Kathi on 17 February 2008

Speaking updates

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

0 comments, 467 reads

Posted in Advice from Aunt Kathi on 16 February 2008

Software Engineering

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.

Buck Woody wrote an interesting… Read more

0 comments, 1,006 reads

Posted in The Voice of the DBA on 16 February 2008

Getting Geeks (IT Pro's) To Talk at User Group Meetings

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

0 comments, 449 reads

Posted in SQLAndy on 14 February 2008

Is SQL Server Dead?

 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…

Read more

0 comments, 1,910 reads

Posted in The Voice of the DBA on 14 February 2008

Should Code Camp/SQLSaturday Be Free?

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

0 comments, 589 reads

Posted in SQLAndy on 13 February 2008

Speaker Eval Form, Part 2

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

0 comments, 925 reads

Posted in SQLAndy on 12 February 2008

Change Data Capture

 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

5 comments, 1,081 reads

Posted in The Voice of the DBA on 12 February 2008

Computed Columns Published on SSC

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

0 comments, 406 reads

Posted in SQLAndy on 12 February 2008

Kalen Delaney SQL Server Internals DVD

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:

  Pre-Order Kalen Delaney's SQL Server… Read more

2 comments, 1,271 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 February 2008

Making Sponsorship Work at Community Events & User Groups (My Wish List)

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…

Read more

0 comments, 746 reads

Posted in SQLAndy on 11 February 2008

Next oPASS Meeting is Feb 12

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

0 comments, 458 reads

Posted in SQLAndy on 11 February 2008

SQLSaturday Tampa 2008 is This Weekend (Feb 16)

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

0 comments, 525 reads

Posted in SQLAndy on 11 February 2008

Init from Backup Published on SSC

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

0 comments, 322 reads

Posted in SQLAndy on 11 February 2008

The Right Font

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, 2,532 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 February 2008

Do It My Way

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

0 comments, 739 reads

Posted in The Voice of the DBA on 8 February 2008

Thoughts on HTTP EndPoints, Schemas, and other niche features

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:

  • HTTP EndPoints.…

Read more

3 comments, 422 reads

Posted in SQLAndy on 7 February 2008

Chipotle - A Model Business? Or Just Good Food?

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

1 comments, 411 reads

Posted in SQLAndy on 6 February 2008

And then there was one

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

0 comments, 715 reads

Posted in The Voice of the DBA on 6 February 2008

Newer posts

Older posts