I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services help me understand more about SSAS. It was good to finally talk with this dude and get him to present to the Data Arch VC
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge, LA. The topic will be Attributes and Hierarchies in Analysis Services 2012. The flow will be from requirements gathering thru implementation in the Semantic Model.
Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server Data-Types. This seemingly simply feature is the heart of tables and data in SQL Server, so you do not want to miss Neil sharing implications of not knowing the details…
Please join this Thursday Dec 20th 2012 at noon central for Business Intelligence expert/consultant James Serra talking Master Data Services. This new feature of the Microsoft BI stack is sure to help elevate your skills with data in SQL Server 2012.
Introduction to Microsoft’s Master Data Services (MDS) by James…
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