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

Archives: October 2008

SQL Server 2008 Data Compression Example

I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.

First, I identified a row in a production database called so_hdr_tbl that I wanted to compress. Before compressing it, I checked the size of the table, and it had 54,840 rows and took… Read more

5 comments, 4,231 reads

Posted in SQL Aloha on 31 October 2008

Follow Up to Blog Review Post

A month or so ago I posted Blog Review - Yours & Mine to see what I might get for feedback about my writing efforts, and to spend some time taking a deeper look at my Blog Likes & Dislikes. The effort was mildly sucessful overall. I had a… Read more

0 comments, 1,472 reads

Posted in SQLAndy on 30 October 2008

New Books on SQL Server 2008

Since the release of SQL Server 2008, a slew of new books have been released, or are about to be released on it. Below are some of the titles I recommend you check out. By the way, I know all of these authors, and I highly recommend them.



Read more

0 comments, 1,670 reads

Posted in SQL Aloha on 30 October 2008

The October 2008 Energy Update - So Much Passion

Do we have an energy crisis or not? Is global warming real? Are we being affected by burning fossil fuels?

I don’t have the answers. Wish I did, not confident anyone does, but it just feels like there’s an issue here. Nothing can run forever as an every increasing force,… Read more

1 comments, 1,427 reads

Posted in The Voice of the DBA on 30 October 2008

The Wise Old Man Part 2

In my previous post The Wise Old Man Part 1 I wrote about a great session I attended during SQL Saturday #8 in Orlando by Steven Jones.  This session was all about building your brand and making yourself stand out among other IT professionals.  The session influenced me enough to… Read more

0 comments, 1,550 reads

Posted in Devin Knight on 30 October 2008

Thoughts on .Net Reflector Being Acquired by Red Gate

This is an unpaid/unsolicited comment about a product now owned by Red Gate Software. Purely my opinions, and I'll try to make clear my biases as I go.

It's been a while since the announcement, but it was interesting to hear about the acquisition of Reflector by Red Gate. For… Read more

5 comments, 1,569 reads

Posted in SQLAndy on 29 October 2008

The Wise Old Man Part 1

During one of the sessions that I attended during SQL Saturday in Orlando I had the privilege of listening to the Wise One Steve Jones.  He had a great session called ‘The Modern Resume – Building Your Brand’.

It really opened my eyes about what anyone can do to build… Read more

1 comments, 1,657 reads

Posted in Devin Knight on 29 October 2008

Free/Cheap/Good HTML Editor, Is There Such a Thing?

For the past few years I've been using Frontpage 2003 for basic HTML work, usually to write content for SQLServerCentral. Let's me use a decent UI for most of the stuff, it it looks wrong I can easily switch and tweak the HTML. Not recommending it for advanced design work,… Read more

4 comments, 1,328 reads

Posted in SQLAndy on 28 October 2008

Effecting Change

Over the years Andy Warren, Brian Knight, and I have talked about PASS quite a bit. It hasn't always been pretty, but we liked the idea of PASS, though Andy and I thought we had a conflict of interest in serving on the board. Early on in the history of… Read more

1 comments, 1,397 reads

Posted in The Voice of the DBA on 28 October 2008

A Break

Only a small one, but I appreciate every one I get. Not often that I get to leave the site or shirk a few duties.

Today Phil Factor contributed an editorial for the newsletter. It was supposed to run yesterday, but for some reason it didn't get to me on… Read more

1 comments, 1,442 reads

Posted in The Voice of the DBA on 28 October 2008

Post Event Notes - SQLSaturday #8

Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and some where we didn't:

  • Check in still needs some work. Took longer than it should have, but we learned some too. Having the greeter hand out event bags spread out…

Read more

2 comments, 1,299 reads

Posted in SQLAndy on 27 October 2008

Miramar User Group and SQL Saturday Presentations

Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server. This is a new presentation in which I tried to tie in some of the business aspects and concerns with regards to presenting our cases to business and our… Read more

0 comments, 1,533 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 October 2008

Post Event SQL Saturday #8 Orlando

This weekend I spoke at Seminole Community College with a session on Reporting Services 2008.  If your interested you can find the PowerPoint slides on www.SQLSaturday.com .  I was a little disappointed with my presentation due to some issues with the projector and my laptop.  These things happen but luckily… Read more

0 comments, 1,389 reads

Posted in Devin Knight on 27 October 2008

SQLSaturday #8 - Orlando

 The whole idea of having free events, bringing learning to people locally wasn't something that I was thrilled with. It's a lot of energy and effort, and there have been more than a few times that I questioned the wisdom of putting resources into these events. However once I've attended… Read more

0 comments, 1,409 reads

Posted in The Voice of the DBA on 26 October 2008

Absolutely (Not?) - Why Did I Write This?

I've always been a little bit of a strong DBA. I try to get along and work with people, being flexible about what rules to implement, but I am somewhat of a stickler for rules. As I was browsing through some blogs one week, I found myself reading about that… Read more

0 comments, 1,567 reads

Posted in The Voice of the DBA on 26 October 2008

After Event Notes on SQLSaturday #8 in Orlando

By any measure the event was a success. We had a solid 275 attendees this year, up about 50 from last year. We actually registered 465, and then in the last week we worked on reminding people to cancel if plans had changed, resulting in 94 cancelations. It's the nature of free… Read more

0 comments, 1,472 reads

Posted in SQLAndy on 25 October 2008

ways to find the name of a running job

From time to time, I need to check (in my script) which jobs are running at the moment.So far, I have used the following three ways:

1. exec msdb..sp_help_job  @execution_status = 1

2. exec master..xp_sqlagent_enum_jobs 1, 'sa' -- checking the column [running], if it is 1, it means… Read more

1 comments, 1,760 reads

Posted in DBA Philosophy on 23 October 2008

Good Ideas Take Time or How to Brainstorm - Part 2

In Good Ideas Take Time or How to Brainstorm - Part 1 I wrote about how I come up with ideas for blogging. Today I'd like to take that a step further and talk about how I generate ideas for business.

The first step is to have ideas, to find… Read more

2 comments, 1,574 reads

Posted in SQLAndy on 23 October 2008

Out of Band Security Bulletin Release for Microsoft Windows

Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of times since going to that release cycle. Well, today's the day as it looks like another out-of-band release will come out:

Microsoft Security Response Center blog post

Microsoft Security Bulletin… Read more

0 comments, 1,480 reads

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

What’s in a Name?

Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the equally meaningless ‘usp’ for stored procedures. I think that it is because that is what they see illustrated in books, magazines, white papers and on-line 'example'… Read more

0 comments, 1,356 reads

Posted in SQLSequel on 23 October 2008

Older posts