February 2012 SQL Lunches

#62-Build, Secure, & Deploy an SSAS Tabular in 30 minutes

Report Builder
Speaker: Patrick LeBlanc

View Recording: Watch Now!

Download:  Not Available

BIO: Patrick LeBlanc is a Microsoft SQL Server and Business Intelligence Technical Solution Professional. He has written several blogs and articles on his blog at http://patrickdleblanc.com, www.sqlservercentral.com and www.bidn.com. Along with his 10+ years experience he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of four SQL Server books. His past work experiences include Sr. Consultant at Pragmatic works and Database Architect at several companies. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community.

Topic: #62-Build, Secure, & Deploy an SSAS Tabular in 30 minutes
In this demo-centric presentation I will show you how to build a fully functional analytic model, add database and row-level security and finally deploy your model to an SSAS server running in tabular mode. I will also show you how to quickly build a quick report that provides insight into the data.

#63-PowerShell Query for the T-SQL Developer

Report Builder
Speaker: Max Trinidad

View Recording: Watch Now!

Download: Download Now!

BIO: Max Trinidad is a native of Puerto Rico and has been working with computers since 1979. He has worked with Dbase III/IV, Clipper, RPG, OS/400, OCL/JCL/CL, HTLM and most current MS development technologies. Work for many years as a Senior IT/Developer has provided support for Windows Servers 2003/2008, SQL Servers Applications, Microsoft Virtualization Technologies, and IBM iSeries building Visual Studio solutions. In 2009 and 2010 got his Microsoft MVP award in Powershell.

Topic: #63-PowerShell Query for the T-SQL Developer
Showing similarities of creating PowerShell query vs T-SQL scripting: Select, where, SUM, Count. There's a little of Extending your T-SQL Scripting using PowerShell. I'll be providing a comparison chart "PowerShell | T-SQL",and demo script included. Just to show that you can adopt PowerShell sooner than you think.