Archives: October 2008
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
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
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.
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
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
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
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
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
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
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.
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…
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, 691 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 October 2008
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
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
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
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
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
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
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:
0 comments, 650 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 October 2008
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