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

Archives: July 2008

Building Better VMs

The other day I fired up my old desktop, intending to use it as background in the podcasts. It gave me a "Activate Windows" error for the W2K3 installation on there. I know I was thinking that I would use it as a file server, but downstairs it has no… Read more

0 comments, 314 reads

Posted in The Voice of the DBA on 22 July 2008

Disabling Indexes Published on SQLServerCentral.com

It's been a while since I had anything up on SSC, a combination of Steve being in good shape on content and me being busier than usual, but early July I had a break and got 4 articles done. Disabling indexes isn't a complicated option of course, but one of… Read more

0 comments, 173 reads

Posted in SQLAndy on 22 July 2008

Tool Review: Password Safe

I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on still a dream!) and too often fall back on using the same password over and over again. A few years ago Steve Jones introduced me to Password Safe when he… Read more

0 comments, 174 reads

Posted in SQLAndy on 21 July 2008

Why Are Stored Procedures Too Hard?

Recently I was going through the buy or build process on a small segment of functionality needed for a project, and ran across something that looked like it would work, price point was realistic, and when I looked at the source they made available was thrilled to find it used… Read more

0 comments, 178 reads

Posted in SQLAndy on 20 July 2008

Delayed gratification

Call me odd, but I enjoy taking certification tests.  It may be that I've always tested well, or perhaps it's that I enjoy a challenge, but for whatever reason I have always looked forward to sitting for exams.  So when the opportunity arose to take a beta exam for the… Read more

0 comments, 206 reads

Posted in Tim Mitchell on 20 July 2008

Patching

Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS security bulletin that a security patch MS08-040 needed to be installed on SQL Server 7 - 2005. http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx

I spent some time with our SMS guy to see if we could… Read more

0 comments, 590 reads

Posted in Advice from Aunt Kathi on 19 July 2008

Follow Up Notes on the Custom Whiteboard

A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially it seemed to work very well, the markers wiped off easily with a nice soft cloth. Then it started to get more difficult, requiring more friction than should be necessary.… Read more

0 comments, 160 reads

Posted in SQLAndy on 17 July 2008

JSSUG Speaking Event: Reporting Services 2008

We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting. If you missed it I spoke on Reporting Services 2008. I called the presentation Introduction to SSRS 2008 but we focused mainly on the new features in 2008. If you…

Read more

3 comments, 290 reads

Posted in Devin Knight on 17 July 2008

Tools

Below is a list of various tools I use, some SQL related and some not. Follow the links to my blog entries for more details about why I use/like any of them. As the list grows I may try to categorize a little, for now we'll just go with alphabetically. Read more

0 comments, 373 reads

Posted in SQLAndy on 17 July 2008

Comments on Dissecting SQL Server Execution Plans by Grant Fitchey

Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance to read it last week (on vacation) and was pleased with it, he did a great job covering the concepts and I noted that he had the answers to many… Read more

0 comments, 681 reads

Posted in SQLAndy on 16 July 2008

SQL Server 2008: Implementation and Maintenance, Beta Exam

I signed up for the SS2K8 beta exam, the maintenance and implementation one, and had it scheduled for this morning. I didn't really prepare or study at all, counting on the limited work with CTPs and Betas, as well as reading articles to help me out.

The beta format is… Read more

0 comments, 308 reads

Posted in The Voice of the DBA on 16 July 2008

Reminder - Midlands PASS Chapter Meeting - July 17 - MVP John Welch

The Midlands PASS Chapter hosts:

SQL Server MVP John Welch

July 17, 2008 at Training Concepts

The Midlands PASS chapter will hold a special meeting on Thursday, July 17, 2008, to host SQL Server MVP John Welch. John will be giving a presentation on SQL Server Integration Services Read more

Jacksonville Code Camp Set for August 23, 2008

The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to a good start. Last years event was only a mild success, they've gotten started a little earlier this year so that should translate to a better event.

I see a… Read more

0 comments, 162 reads

Posted in SQLAndy on 15 July 2008

Find all views created on a table

USE ADVENTUREWORKS; -- You can use any kind of database that you have
GO

--Procedure that shows all views created on a table, together with schema

CREATE PROCEDURE VIEWS_IN_TABLE
@TABLENAME VARCHAR(200)
AS
SELECT VIEW_SCHEMA, VIEW_NAME FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE TABLE_NAME = @TABLENAME;
GO

--executing the…

Read more

0 comments, 271 reads

Posted in Dukagjin Maloku - Dugi'DBA on 15 July 2008

MentoringNet

I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went to look. It's interesting, a matching service for mentors and proteges, but unfortuneately focused on college students mainly. It's also email based (unless you happen to live in the… Read more

0 comments, 246 reads

Posted in SQLAndy on 14 July 2008

What is an MVP?

My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately interesting discussion about the MVP program. If you're interested in how the program works or what it takes to get in, it's worth reading both - though you still… Read more

0 comments, 546 reads

Posted in SQLAndy on 13 July 2008

Well Run Companies

One of the things I use to identify how well a company is managed is by looking at how (well) they maintain their facilities. I'm not talking about the white glove test, but the general state of the business. For example, I was recently in a retail food place and… Read more

0 comments, 576 reads

Posted in SQLAndy on 13 July 2008

The Business of Software

I missed it last year, but I just booked my flight for the Business of Software 2008. It's being held in Boston on September 3rd and 4th. I'm flying in on Tuesday, arriving at 4pm, dropping my bag off at the Hotel (I'm going to be at the Seaport)… Read more

0 comments, 199 reads

Posted in The Voice of the DBA on 11 July 2008

SQLSaturday #5 & #6 Update

SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just announced to the local user group already have more than 30 registered. Current focus is on speakers, if you're in the area or know someone in the area please let… Read more

0 comments, 108 reads

Posted in SQLAndy on 11 July 2008

SQL Server 2008 ne Gusht

Pershendetje prap dhe nje rikthim i shpejt ne pjesen ku e kam publikuar se deri me tani kemi versioni RC0 te SQL Server 2008, me duhet t'iu them se jemi afruar shum afer te nje versioni te mundshem RTM te SQL Server 2008 si dhe ka gjasa shumcka te kompletohet… Read more

0 comments, 257 reads

Posted in Dukagjin Maloku - Dugi'DBA on 11 July 2008

Newer posts

Older posts