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

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, 358 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, 486 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, 187 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, 116 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, 124 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)
VALUES(1,9),(2,2),(3,17),(4,17),(5,26),(6,6),(7,2),(8,20),(9,21),(10,6),(11,19)

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

Read more

1 comments, 355 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, 191 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, 181 reads

Posted in Never Say Never on 1 April 2010

DBCC INPUTBUFFER vs fn_get_sql

Someone asked a question in the forums the other day and I realized it would make a pretty decent blog post to explain the differences in functionality between these two and provide some code for working with them.

Differences

  • fn_get_sql returns the last *statement* executed, where as DBCC INPUTBUFFER returns…

Read more

0 comments, 1,944 reads

Posted in Never Say Never on 28 March 2010

Snagit…

If you read my last post, you may have noticed that my images now include boxes, balloon text and highlighting.  This is due to a friend insisting the he couldn’t live without Snagit for blogging or documentation and that I simply must try it.  I figured I’d sign up… Read more

5 comments, 243 reads

Posted in Never Say Never on 21 March 2010

Random Thoughts on Aliasing

 

Here are many different thoughts/facts/preferences on aliasing.  Most of this applies to column aliasing.  Regardless of whether or not you like aliasing tables, you should still be aliasing columns.  If you do happen to be one of the people who is against table aliasing (some of you may be… Read more

3 comments, 484 reads

Posted in Never Say Never on 20 March 2010

Tally Table CTE

Now that I have several posts on what you can do with a Tally table, I figured I'd share my favorite way to create one inline.  I still prefer to have a physical tally table (usually in a Utility database that can be accessed from anywhere and doesn't need to… Read more

2 comments, 1,438 reads

Posted in Never Say Never on 19 March 2010

SCSUG March Meeting Recap

The Monsoon

My trip to the meeting, short as it was, involved some of the worst driving conditions I've ever personally encountered.  It was coming down in sheets and I was doing 40mph on I-95.  Before you roll your eyes about how I'm one of "those guys", note that only… Read more

1 comments, 120 reads

Posted in Never Say Never on 12 March 2010

SCSUG (Space Coast SQL Users Group) Meeting Tonight Featuring PFE David Pless

In case you missed David Pless in Orlando on Tuesday, you have another chance to see his presentation tonight (Thursday March 11, 2010 6:30 PM EST) at the SCSUG meeting (Brevard County, Fl).

David will be speaking about how to troubleshoot performance issues on SQL Server 2005 and SQL Server… Read more

0 comments, 158 reads

Posted in Never Say Never on 11 March 2010

Tally Table - Delimited list to Table

Dealing with delimited lists (Usually separated by a comma) in SQL is a problem easily handled by a simple function and a Tally Table.  (Tally tables are also often referred to as Numbers tables or spt_values tables.  If you still don't know what that is, please see this excellent article Read more

3 comments, 1,859 reads

Posted in Never Say Never on 27 February 2010

Data Type Precedence and Implicit Conversions

In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that ISNULL attempted to convert the second parameter to the data type of the first parameter where as COALESCE converted according to the Data Type Precedence table.  A reader requested… Read more

2 comments, 1,347 reads

Posted in Never Say Never on 21 February 2010

ISNULL() VS. COALESCE()

There are a lot of arguments about which of these to use.  In my opinion, they both have their place.  Here are a few facts about the two functions.

  • ISNULL can accept only two arguments where as COALESCE can accept any number of input parameters
  • ISNULL is not ANSI standard…

Read more

6 comments, 4,938 reads

Posted in Never Say Never on 11 February 2010

IN and NOT IN

One of the most common mistakes made in T-SQL is thinking that these behave identically.  I've personally opened up a forum topic on it because I didn't know what the difference was.  This post will join a small army of other places on the net devoted to correcting this misunderstanding.… Read more

15 comments, 398 reads

Posted in Never Say Never on 28 January 2010

Windows LiveSynch

After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation, troubleshooting, commonly requested ad hoc queries etc.  I've seen people suggest a few different methods for keeping this 'script library' available on several different machines.  Some people recommend saving everything… Read more

1 comments, 175 reads

Posted in Never Say Never on 20 January 2010

Tally Table - String Cleaning

Overview
This is something that most people eventually need for reporting purposes.  This function uses a Tally table to 'clean' a string, removing anything you don't specify in the @Rep parameter.  In the case below, I remove everything but letters, numbers, spaces, commas and periods.  This is a slightly modified… Read more

6 comments, 1,891 reads

Posted in Never Say Never on 13 January 2010

Newer posts

Older posts