Subscribe to this blog
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, 375 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…
0 comments, 203 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, 156 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, 143 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, 137 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, 589 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, 410 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, 218 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, 300 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, 116 reads
Posted in SQL Awesomesauce on 5 September 2011