Thursday afternoon concluded with How to run SSRS in Sharepoint integration mode, Enriching Tabular with DAX and Monitoring SSAS. The best was the last. Tim Peterson (SolidQ) shared his 12+ years working with SSAS to give us 3 ways to monitor SSAS – SQL Profiler, PerfMon and a… Read more
WIT – Women In Technology 10 anniversary PASS Summit Luncheon
Please go to this link for more info on the speakers and content. I am blogging and tweeting from this luncheon to help with exposure of the message and to learn more myself.
Using SSIS 2012 for ETL in a Data Warehouse
Well, I feel great relief that my session has been completed, and completed successfully. The room was full with people on the floor and along the walls. That was great considering Peter Meyers and Devin Knight had done similar sessions 2… Read more
Could not sleep past 4:30AM this morning, daylight savings time and 2 time zone changes did not help. So, exercise now in the morning and off to Summit for 7:30AM.
Meet 2 new Summit attendees in the elevator from Los Angles working for Stamps.com. They were both developers of… Read more
Using SSIS 2012 for Data Warehouse ETL
I have been fortunate to be selected this year to speak at the PASS Summit 2012 in Seattle. This presentation will go mainly over 3 new features: The Change Data Capture and DQS controls as well as deploying SSIS projects/packages to the… Read more
I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about an error: Deadlock. Searching the SQL Log, I was able to get the details of the deadlocking. We have Trace Flags 1204 and 1222 turned on which provides the details.… Read more
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr. SQL Louis Davidson as he helps application and database developers design and implement SQL Server databases.
The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the PASS Summit in Seattle, WA Nov 5th-9th. The Data Architecture VC gets to host Rod presenting on BI Architecture With SQL 2012 & SharePoint 2010. This is a good… Read more
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting the surrogate key for a fact table. I hope to introduce here a third.
The first is the caching option.
If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I have helped chair the Data Architecture VC for the past year or so, started by volunteering with the Performance VC for about 6 months and have done presentations on the… Read more
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing and Bill Waters. Sharepoint sessions are great for those in the BI field using Microsoft BI stack managing PerformancePoint and PowerView/SSRS integration or SQL Server DBAs having a… Read more
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my top 3 sessions last year at the Summit. He has an excellent way of using visuals to explain things. The session for the PASS Data Architecture VC on Thursday (July… Read more
The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks this year. This blog will be about the speakers from first track.
8:20AM - Introduction to SSIS with a Real-World Example
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach to Data Warehousing. The PASS DW/BI Virtual Chapter has graciously allowed me to present on Dimensional Modeling. I am not an expert, so this is an introduction to what… Read more
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of July and August 2012. My local brother from a different mother, Patrick LeBlanc, hosted a SQLLunch for me as I demonstrated the new CDC controls in SSIS 2012. Patrick’s… Read more
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered the new business building for out event.
This blog continues the series of blogs over the next few weeks to spotlight the tracks for this FREE event. Of course, nothing… Read more
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got the ball rolling 4 years ago and now a team of IT professionals from Baton Rouge have continued the effort.
This blog starts a series of blogs over the next… Read more
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no comments, so I am not even sure if it was helpful to anyone, but me.
This post will be an example of a query from the AdventureWorks database that… Read more
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity and Performance.
We will also be giving away an Amazon gift card plus someone gets a book - Itzik’s T-SQL Fundamentals.
If you would like to volunteer for this VC,… Read more