December 2011 LV UG Meeting

Categories: News, Professional, SSC
Tags: ,
Comments: 1 Comment
Published on: November 30, 2011

The Holidays are upon us.  It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL Server.

This month, Jason Brimhall will be presenting a new topic:


As a DBA in the modern era, you may be required from time to time to do something outside of your comfort zone.  One of these things may be to become quickly acquainted with SSRS.  Even better is that you may be required to do things you have not considered in a standard report.  In this session, you will learn how to implement a framework to help provide a common ground for your reports.  This session will delve into fun topics such as dynamic grouping and dynamic sorting.  We are not talking about the interactive sorting that your accountant may use.  Attendees will also be introduced to a few quick methods of exporting Reports from the report server – this is from a DBA perspective after-all!

Jason’s Bio:

Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2008 R2. He has experience in performance tuning, high transaction environments, as well as large environments. He is currently a DB Architect and an MCDBA. He is he VP of the Las Vegas User Group (SSSOLV).

LiveMeeting Information:

Attendee URL:
Meeting ID:  FHKZS7

New Meeting Segment

We are going to be trying a new idea with the group at the meetings.  Each meeting, bring some of your ugly code.  We can look it over and help each other make better code.


The meeting location has changed.  We will no longer be meeting at The Learning Center.  New meeting location is M Staff Solutions & Training / 2620 Regatta Drive Suite 102 Las Vegas, NV 89128.



1 Comment - Leave a comment

Leave a comment

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

November 2011
« Oct   Dec »


  • @SQLSoldier: @mvelic Yes, but then I pointed out that they were using nolock and SSIS isn't. The matching records were not committed. #sqlhelp #TrueStory
  • @mvelic: It's just maddening because this lookup has *always* worked in the past. It's just now deciding to not recognize matches. #sqlhelp
  • @mvelic: Has anyone just seen an SSIS Lookup fail to make matches? You know the matches exist, but it doesn't connect them and it fails? #sqlhelp
  • @banerjeeamit: @MattPgh No. Current processing report is not visible. This is visible in RunningJobs table but not the stats breakdown. #sqlhelp
  • @forhakim: #sqlhelp in Visual Studio SSDT is there a way to make it NOT show table designer, only the script, when I edit a table?
  • @MattPgh: @banerjeeamit Will the current report show up in ExecutionLog? whatever processing is happening did not finish yet. #sqlhelp
  • @banerjeeamit: @MattPgh Look at the time processing and rendering in the logging table: #sqlhelp
  • @banerjeeamit: @MattPgh Also, CPU time can be consumed due to rpt processing. This is available thru the ExecutionLogStorage table #sqlhelp
  • @banerjeeamit: @MattPgh Using XEvents or profiler u can see which stmt r CPU intensive? This wud gv u the cpu time consumed by the DB queries. #sqlhelp
  • @MattPgh: Is there a way to tell exactly what SSRS service is doing when it has CPU pegged to 100%? like a "what running" query in sql. #sqlhelp

Welcome , today is Friday, October 9, 2015