Archives: April 2010
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
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
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
[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
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
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
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
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
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
INSERT INTO @Decode(DSeq, DKey)
Decoder AS (
SELECT D.DSeq N,
CHAR( D.DKey + ASCII(SUBSTRING(@Message,D.DSeq,1)) ) DV
FROM @Decode D),
Conc (S) AS…
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
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