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

Archives: December 2010

Efficiency and Effectiveness at Work [Video]

In this vblog entry on shows SQL Server expert Kevin Kline discussing his views on how to be both efficient and effective in your day to day and career – aimed at the SQL Server professional, but good for anyone.

Originally posted August 08, 2008.

Read more

0 comments, 237 reads

Posted in Kevin E. Kline on 23 December 2010

Updated SQLRally Flyer

We’ve updated the original flyer to the new and improved model that has the prices. The image below is a screen capture, download the real flyer to get the best resolution. We’re in the process of ordering print copies now and will be working to distribute them beginning in January,… Read more

0 comments, 294 reads

Posted in SQLAndy on 23 December 2010

Lunch Story #3–No Free Sandwiches

This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for buy one get one. Four of us go, we get there and then do the coupon dance, who wants chicken, who wants roast beef? Finally two of us decide on… Read more

1 comments, 254 reads

Posted in SQLAndy on 23 December 2010

How To Choose A Topic For Speaking

“The human brain starts working the moment you are born and never stops until you stand up to speak in public.” observed Academy Award winning movie producer George Jessel. I think there is some truth to that for many of us.

As a regular speaker at conferences, SQLSaturdays, and other… Read more

1 comments, 380 reads

Posted in Joe Webb on 23 December 2010

Strange issue while using IDENTITY values in INSTEAD OF triggers

Found an interesting issue last goes like this: If you are using INSTEAD OF triggers on views (in SQL 2005) and you need to retrieve IDENTITY values you have to be very careful how you do it. It turns out that a simple SELECT from the inserted table can…

Read more

0 comments, 439 reads

Posted in Sam Bendayan's 2 Cents on 23 December 2010

Interlude: SSMS tips


I know I said I was going to add more information about the CDC system in this post, but I wanted to throw up a quick sideline before Christmas.

SSMS is a powerful tool, and one I am very happy with. It contains a lot of really useful features…

Read more

3 comments, 810 reads

Posted in Don Halloran on 23 December 2010

Intel Sandy Bridge Processor Machines Coming Soon!

If you are in the market to buy or build a new laptop or desktop computer, you might want to wait a few weeks, for several reasons. First, Intel is going to formally roll out the brand new Sandy Bridge family of processors at the Consumer Electronics Show on January… Read more

0 comments, 346 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

SQL Server 2005 SP3 Cumulative Update 13 Released

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday, but the “View and request hotfix downloads” link was broken until earlier today.  I waited to blog about it until you could actually request it.

I have… Read more

0 comments, 392 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

SQL Server Scripts Manager From Redgate Software

Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as one of the nine authors of the included scripts. It is always nice to get a free tool that does something useful.

This is how Redgate describes the tool: Read more

5 comments, 1,104 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

Book Plug: Say Goodbye

I read a lot, and often marvel at the effort that goes into writing them, and I think I get part of that appreciation from watching my friend Bob write his first novel, Say Goodbye. He’s worked hard at it, growing it, changing it, polishing it, and sweating over… Read more

0 comments, 295 reads

Posted in SQLAndy on 22 December 2010

SSIS to SQL Server Data Type Translations

I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS data types.  At first glance they seem to be nothing like SQL Server data types you love and know.  That's why I've provided below a conversion chart of SSIS data… Read more

3 comments, 16,109 reads

Posted in Devin Knight on 22 December 2010

Can You Dig It? – StmtCond Element

She can dig it!
D Sharon Pruitt

A couple posts ago in the plan cache series I discussed the children for the Statements element.  This next post will focus on the second of the five possible child elements – the StmtCond element.  You might want to call this the “Statement… Read more

0 comments, 407 reads

Posted in StrateSQL on 22 December 2010

The Real Purpose for Kindle

It finally dawned on me why people would bother getting a separate book-reading device like Kindle - and why it might be a good idea especially in a database professional's line of work.

My epiphany came today while at Borders in the Business/Management section and I see a book called… Read more

4 comments, 702 reads

Posted in Bill Nicolich on 22 December 2010

SQL Server Storage Internals Part 4 - How to read a Heap page

I like to share 4 updates before moving on to this section:

1. I 've updated my profile to know more about me and purpose of this blog.
2. I 've republished this part with some updates after getting comments from Seniors. 
    You may notice that I 've removed detailed explaination of… Read more

15 comments, 4,549 reads

Posted in LivingForSqlServer on 21 December 2010

Pragmatic Works: The Transition

So if you know me via Twitter or my blog you
probably know that as of about a month or two ago I joined the
fantastic team at
Pragmatic Works. This
transition was rather significant for me as I would be moving from
the world of administration to the… Read more

0 comments, 489 reads

Posted in SQL Chicken on 21 December 2010

Can You Dig It? – StmtUseDb Element

She can dig it!
D Sharon Pruitt

The last post in the plan cache series discussed the children for the Statements element.  As I noted in that post, there are five possible children.  This post will focus on StmtUseDb.  Or as little children sometimes say “Statement Use Database”

As the… Read more

0 comments, 301 reads

Posted in StrateSQL on 21 December 2010

Get Prepared for the January Hiring Season

Get Prepared for the January Hiring Season

As the year winds down, in what was undoubtedly a tough economic year for jobs all around, and in the IT sector, hope for 2011 comes as an early Christmas present.  Quiet is the word in these last two weeks of the… Read more

1 comments, 426 reads

Posted in Pearl Knows on 21 December 2010

The 9th Day of SQL: Things Aren't as Simple as They Seem

The 12 days of SQL

Brent Ozar (blogtwitter) had an idea: a group of people should blog about writing which they’ve loved this year by people in the SQL community. For each “day of SQL,” someone picks a blog which they thought was great and writes… Read more

0 comments, 373 reads

Posted in LittleKendra on 21 December 2010

DBTA: Growing Like Weeds – Explosive SQL Server Grassroots Growth

One thing I really enjoy about the SQL Server community is its vibrancy.  I’ll give you details on the SQL Server community’s explosive growth in a moment, but let’s start by comparing Microsoft SQL Server’s user community with those of other significant database platforms. [READ MORE]

Posted May 10, 2010 Read more

0 comments, 203 reads

Posted in Kevin E. Kline on 21 December 2010

Fashionably Late, but She's Here!

I'm pleased to announce the latest addition to the Kelley family, a beautiful baby girl born at 11:56 PM last night. She weighed 8 pounds and 1 ounce and measured in at 18.5 inches. She is the biggest at delivery of our four children. Mommy and baby are both fine.

For obvious reasons,… Read more

Newer posts

Older posts