December Recap

Categories: News, Professional, SSC, SSSOLV
Tags: ,
Comments: 1 Comment
Published on: December 29, 2011

The past few months I have been pretty busy.  December is no exception to that.  Between normal work, moonlighting as a general contractor on my own basement, and trying to keep up with my family – it almost seems like the month has barely even been a blink.

Other than the highlights of the holidays and finishing a room in the basement, I did have some SQL related highlights.

The first highlight came with notice of having won a contest – yay.  I entered into the SafePeak performance story contest back in September.  The contest closed out in November and the winners announced the first part of December (maybe the end of November).

For that contest, I submitted this story.  In that story, I showed how duplicated business logic can prove detrimental to query performance.  By deduping the business logic, I was able to realize a significant performance gain.

As a reward for winning that contest, I received an IPAD2.  That prize came the week just before Christmas.  Now, we use the IPAD as an extra incentive with the children for improved behavior (they really like the IPAD).

The other highlight came at the beginning of the month when I presented a new topic for the S3OLV User Group.  That new topic was on SSRS and customizing Sorts, Groupings, Display Order of Columns, and a few other tricks.  The custom sorts, groupings etc can all be driven based on parameters and prompts.

It was a pretty decent presentation.  The demos worked relatively well.  There didn’t seem to be any hiccoughs with technology.  I do wish more people had attended – but we are working on that.  I plan on sharing a few articles about the very topics discussed during that presentation.

I like presenting and think I need to find more opportunities to do that during the upcoming year.  Let’s hope I actually publish my goals this upcoming year (unlike 2011 where I started writing out my goals and the post remains unpublished).

1 Comment - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

December 2011
« Nov   Jan »


  • @richardslim: Is it possible to have traditional fail-over Clustered instances with locally installed instances in an AG on the same 2 servers? #SQLHelp
  • @gm_praveenk: Hi all Can any one help out in documentations of migration of physical sql server to cloud (hp cloud). #sqlhelp Thanks
  • @SQLSoldier: @DBArgenis @SportsNut70 More specifically, look for updates to heaps. #sqlhelp
  • @DBArgenis: @SportsNut70 that is orthogonal to the storage you use. Look for changes in database schema and workload. #sqlhelp
  • @SportsNut70: We migrated to Flash storage and now see Forwarded Records/sec avg about 5000. On SAN, we had 0. Should I be concerned? Is it Flash?#sqlhelp
  • @yenho213: @DBArgenis interesting idea. I will try to use that solution. thanks. #sqlhelp
  • @DBArgenis: @yenho213 you don't _have_ to configure log shipping again upon failover - write your own scripts and voila. #sqlhelp
  • @yenho213: @DBArgenis, primary and sec node are AG, 3rd server using Log shipping due to application can't handle multisubnet=true just yet #sqlhelp
  • @DBArgenis: @yenho213 depending on what you're actually trying to achieve...#sqlhelp
  • @yenho213: @DBArgenis that means I have to configure Log shipping again every time my AG fail over between the primary and secondary correct? #sqlhelp

Welcome , today is Tuesday, August 4, 2015