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

Archives: September 2011

Start daily programs – More n00bz fun with #Powershell!

When I get in to work in the morning, I like a good cup of coffee waiting for me, a neck rub, and all my favorite programs open and waiting for me.  Since the first two seem out of the question, I focus on the third.

I’ve automated my start-of-day… Read more

1 comments, 613 reads

Posted in SQL Awesomesauce on 27 September 2011

Presenting “Tangled Code” at Charleston UG Tuesday 9/20

On Tuesday, September 20 at 5p CST (6pm Charleston time), I will present “Unraveling Tangled Code” via LiveMeeting at the brand-spanking-new Charleston SC User Group!

Abstract: Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex…

Read more

0 comments, 314 reads

Posted in SQL Awesomesauce on 19 September 2011

PASS First Timers Guide and Schedule

Hi there ho there everybody! I am now a Big Sister Fearless Leader of a group of PASS Summit first timers! This is the page wherein I record all of my sage advice and such for them, and for any other first timer who wishes to come around. I will… Read more

0 comments, 267 reads

Posted in SQL Awesomesauce on 17 September 2011

PASS First Timers Guide

Hi there ho there everybody! I am now a Big Sister Fearless Leader of a group of PASS Summit first timers! This is the page wherein I record all of my sage advice and such for them, and for any other first timer who wishes to come around.  I will… Read more

0 comments, 243 reads

Posted in SQL Awesomesauce on 17 September 2011

PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”

The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro).  Yes, I made sure to add the network location that holds my files, and yes, I rebuilt the file index. The damn thing still ignores everything and claims I don’t have… Read more

0 comments, 221 reads

Posted in SQL Awesomesauce on 15 September 2011

Great Tools for Formatting T-SQL

I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting code. You see, (I say,) you can’t even begin to understand or optimize a query if it’s not formatted…and by “formattted”, I mean breaking out query clauses onto different lines,… Read more

3 comments, 723 reads

Posted in SQL Awesomesauce on 12 September 2011

Little Workaround in Report Manager

I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report), and from there clicking a link to generate and export a subreport (say, Individual Widget Report). The problem with this is that it wipes out initial report and… Read more

1 comments, 562 reads

Posted in SQL Awesomesauce on 9 September 2011

I need #sqlhelp! BIDS shuts down unexpectedly

I have MS Visual Studio 2008 (BIDS) x86 with SP1.  Recently it’s started shutting down without warning whenever I hit “preview” on a SSRS report. Google hasn’t helped, and I didn’t get much love on #sqlhelp (the Twitter hashtag for SQL help), so I thought I’d ask my adoring public:… Read more

1 comments, 341 reads

Posted in SQL Awesomesauce on 8 September 2011

I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

Edit: See end of blog for solution.

I have MS Visual Studio 2008 (BIDS) x86 with SP1.  Recently it’s started shutting down without warning whenever I hit “preview” on a SSRS report. Google hasn’t helped, and I didn’t get much love on #sqlhelp (the Twitter hashtag for SQL help), so… Read more

0 comments, 441 reads

Posted in SQL Awesomesauce on 8 September 2011

SQL Education

They always used to tell us that education is important.

Education is (They said) key, in fact.  We as a technical community apparently agree with Them, because we’ve devoted countless hours to writing and reading blogs, articles, books, abstracts, bios, and technical sessions. We’ve spent even more hours… Read more

0 comments, 206 reads

Posted in SQL Awesomesauce on 5 September 2011