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 *










Calendar
December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  
Content
SQLHelp

SQLHelp

  • @Ko_Ver: @NickyvV no, no special tricks in the package :) #sqlhelp
  • @NickyvV: @Ko_Ver I've seen that last week that the Job (step) succeeded, but it actually failed with an error #sqlhelp
  • @NickyvV: @Ko_Ver Is FailParentOnFailure set to false on a task/container maybe? #sqlhelp
  • @Ko_Ver: When I start an Agent job, the "job running" pop-up says there's an error. But SSIS catalog and Agent history says jobs succeed. #sqlhelp
  • @DbaMayor: #sqlhelp I'm seeing LCK_M_U and LCK_M_RS_U waits on sec readonly replica with only reporting queries...anyone faced similar issue?..thnks
  • @TrustMeImADBA: Prob not a good question for #sqlhelp but what is the chances time-service changing the time 23 sec forward made my sql cluster failover?
  • @zippy1981: Seem to be that I need to install SSMS vNext Verifying now #sqlhelp
  • @ChrisAdkin8: @YaHoznaDBA you should also compare avg writelog waits to avg tran log write stall,the two are not necessarily foced to be the same #sqlhelp
  • @toddkleinhans: #sqlhelp Will try using lock priority. Totally forgot about that. Thanks!
  • @DBArgenis: @toddkleinhans Compatibility mode is for T-SQL constructs and Query Optimization, nothing else. #sqlhelp

Welcome , today is Tuesday, February 21, 2017