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

Archives: April 2010

2008 Upgrade Completed

Whew!  So I've been super busy the past week and a half upgrading our production server from SQL 2000 to SQL 2008 and haven't had time for any new posts.  Finally starting to see everything calm down again though and running smoother than ever before.  I had hoped to do… Read more

1 comments, 657 reads

Posted in Never Say Never on 26 April 2010

T-SQL Tuesday #005: Monitoring Reports with SSRS

This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”.  (It got a little long.  Ordinarily I’d have broken this up into a series and fleshed out individual pieces a bit better, but this touches on most of the general points) Read more

4 comments, 985 reads

Posted in Never Say Never on 13 April 2010

Reporting Services and Windows 7 Home Premium

Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of what I had to do to get Reporting Services running on Windows 7 Home Premium.  The whole issue was that the account I was using did not have permissions to… Read more

3 comments, 755 reads

Posted in Never Say Never on 13 April 2010

Bug: Reporting Services 2K8, SSMS and Windows 7

[Edit]  Since writing this, I've realized that the true reason behind this was that my account was not a member of the System Administrators Role in SSRS.  Once I adressed that (see this post for details), I no longer had to run SSMS as an administrator to modify roles.  This… Read more

0 comments, 1,079 reads

Posted in Never Say Never on 12 April 2010

SCSUG April Meeting Follow-up

The April meeting went well.  I had hoped that the prospect of a couple of Technet subscriptions would increase attendance a bit for this meeting, but it doesn't seem to have done so.  On the bright side, that meant my competition for them was less and I managed to walk… Read more

0 comments, 369 reads

Posted in Never Say Never on 12 April 2010

2010 Goals – First Quarter Review

Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.

Community Involvement

New Posts on SSC Forums:  Got a bit behind on this one as I really wasn’t posting until about a month ago.  I’ve found that with the… Read more

3 comments, 453 reads

Posted in Never Say Never on 7 April 2010

SCSUG April Meeting Reminder

A reminder to anyone in the Brevard County Florida area:


The SCSUG monthly meeting is at 6:30 on Thursday, April 8th at the SCCU HQ featuring Herve Roggero ( Blog | Twitter).  Herve will discuss SQL Server performance and best practices on indexing, the new indexing capabilities of… Read more

0 comments, 267 reads

Posted in Never Say Never on 6 April 2010

A T-SQL Holiday Message

Totally pointless, but fun.  Run it to decode the message.

DECLARE @Message varchar(20)
SET @Message = '????????????'

DECLARE @Decode Table(
DSeq tinyint,
DKey smallint

INSERT INTO @Decode(DSeq, DKey)

Decoder AS (
CHAR( D.DKey + ASCII(SUBSTRING(@Message,D.DSeq,1)) ) DV
FROM @Decode D),
Conc (S) AS…

Read more

1 comments, 675 reads

Posted in Never Say Never on 3 April 2010

The Best vs. The Good Enough

When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient or that you should be doing things a different way.  While that is true, there's a flip side to this.  In a perfect world, you would always do things the… Read more

3 comments, 415 reads

Posted in Never Say Never on 2 April 2010

Blog Topics - Where do you draw the Line?

I started blogging a few months ago and since I started writing my own blog, I've been a much bigger follower of other technical blogs.  I now follow over 25 SQL blogs and add more on a regular basis. Some of the blogs I follow are updated every day and… Read more

4 comments, 456 reads

Posted in Never Say Never on 1 April 2010