Tuesday, January 28, 2014

Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks

Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and Tricks presented in 5 minute lectures.


Next Meeting

Thu, Jan 30 2014 12:00 (GMT-06:00) Central Time (US & Canada)

RSVP: https://attendee.gotowebinar.com/register/2529334496189827586

This is a SQL presentation for the YouTube generation.  Perfect for half-attentively listening in on your lunch break.  It's really twenty separate five minute lectures.  We'll cover tips and tricks on a range of topics, including data visualization, performance, architecture, and ETL processes.
About Ike Ellis:
Ike Ellis is a 17-year veteran with SQL Server.  He's written millions of lines of code, designed many databases, and troubleshot hundreds of performance problems (some of which he wasn't even the cause of.)  He's a SQL Server MVP, TechEd speaker, RedGate speaker, user group chairperson, and makes a mean guacamole.  Right now, he's neck-deep in several business intelligence projects.  He's designed dashboards, written ETL frameworks, created reports, and all that goes with it.  He doesn't know everything, but he loves to share and teach the things he does know.   Come join him at the SQL Pass Book Readers Virtual Chapter

Wednesday, January 15, 2014

PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies

Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in Analysis Services 2012. This is a presentation I have shown at 2 SQLSaturdays and the Baton Rouge SQL Server User Group as well as 24 Hours of PASS.


Next Meeting

Wed, Jan 15 2014 7PM Central

Thu, Jan 16 2014 12:00 (GMT+10:00) Canberra, Melbourne, Sydney

Attributes & Hierarchies in Analysis Services 2012

RSVP: https://attendee.gotowebinar.com/register/3419604662485554177


The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.

Thomas LeBlanc (MCSA BI 2008, MCITP 2005/2008 DBA & MCDBA 2000) is a Data Warehouse Architect in Baton Rouge, LA. He has been in the IT field since 1989 starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, upgrading to Visual Basic versions 3-6 and even some .Net(C#). Designing and developing normalized database has become his passion. Dimensional Modeling is now his future. Full-time DBA work started in 2001 for Thomas while working at a Paper Mill. DBA related work involved supporting 600+ GB databases with replication to a Data Warehouse and DB Mirroring to a disaster recovery site. Performance tuning and reviewing database design and code are an everyday occurrence. Using the Microsoft BI stack for analytical reporting has sharpened his skills with SSIS, SSAS, SSRS and PerformancePoint.

Wednesday, January 8, 2014

Jan 8th – Baton Rouge SQL Server User Group - Azure

Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the BRSSUG Website: http://www.brssug.org/

January '14 Baton Rouge User Groups Meeting - Azure!

Topic: Microsoft Azure!

This is an all user groups on deck meeting! SQL, .net, SharePoint, IT Pro, La-WIT are all invited!

Date: Wednesday, January 8, 2014

Location: The Louisiana Technology Park - http://www.brssug.org/where

Sponsored By: Microsoft 


5:45 - 6:15 pm: Networking and Refreshments

6:15 - 6:30 pm: Announcements

6:30 - 8:00 pm: Microsoft!

Main Topic: Microsoft Azure Info for ALL User Groups

Main Topic Speakers: Ryan Roussel, Microsoft and Bobby Lee, Microsoft

Main Topic Summary:

Azure is an exciting platform and between IAAS, PAAS, big data, storage, media, mobile services, etc. the possibilities in Azure truly seem limitless.  This user group session will focus on an introduction to Azure with a focus on the agenda topics below.  The session will include lots of live Azure demonstrations and answering questions from the group.  

Every person in attendance will have free access to Azure so they can do everything demoed at the user group meeting on their own after the session!

· Review Azure IAAS (Infrastructure As A Service) – Windows and Linux
    o http://www.windowsazure.com/en-us/solutions/infrastructure/
· Review Azure PAAS (Platform As A Service) and Azure for the web 

    o http://www.windowsazure.com/en-us/solutions/web/
    o How do developers leverage Azure for .Net, JAVA, Node.js, PHP, Python, Ruby, etc.
· Review Azure Mobile Services – Azure development for mobile apps on iOS, Android, Windows Phone
    o http://www.windowsazure.com/en-us/develop/mobile/
· Azure storage options review Azure storage (tables, blob, queue)
    o http://www.windowsazure.com/en-us/services/storage/
    o Developer perspective, when to look at Azure Storage, IAAS database (SQL or Oracle) for SQL Database (Azure PAAS database)
· Free Azure access, review options:
    o MSDN users have free Azure access of $150-$200 free Azure capacity per month. Activate today no credit card needed: http://www.windowsazure.com/en-us/pricing/member-offers/msdn-benefits/

    o Free Azure access for Non-MSDN users, NO credit card needed: http://www.windowsazure.com/en-us/pricing/free-trial/