November 2010 SQL Lunches

#37-Data Mining in SQL Server and Power Pivot

Report Builder
Speaker: Adam Jorgensen

View Recording: Not Available

Download:  Not Available

BIO: Adam Jorgensen , MBA, MCDBA, MCITP: BI has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQLSaturday events on strategic and technical topics.

Topic: #37-Data Mining in SQL Server and Power Pivot
Have you ever wanted to predict the future? Have you heard of data mining or predictive analytics but don’t know how it would impact your business? Come see Adam walk through the basics of data mining in SQL Server and how you can use power pivot to do a lot of the heavy lifting here as well.

#42-Auditing Database Permissions in SQL Server

Report Builder
Speaker: K. Brian Kelley

View Recording: Watch Now!

Download:  Not Available

BIO: Brian is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a database administrator / architect for AgFirst Farm Credit Bank where he can concentrate on his passion: SQL Server. He previously was a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical community, Brian is president of the Midlands PASS Chapter, an official chapter of PASS. Brian is also a junior high youth minister at Spears Creek Baptist Church in Elgin, SC.

Topic: #42-Auditing Database Permissions in SQL Server
Invariably, the dreaded auditors will come knocking at your door wanting to know who can do what in a database. Knee deep in other initiatives, the last thing you want to do is parcel out the time required to answer their requests and the follow-on questions they're likely to have. However, you know that this these are requests you can't refuse and you resign yourself to your fate. In this presentation, Certified Information Systems Auditor (CISA) and Microsoft SQL Server MVP K. Brian Kelley will cover what to audit, how to audit it quickly and efficiently, and the gotchas to look out for when it comes to compiling and reporting database permissions in SQL Server. Coverage of the security catalog views to use in SQL Server 2005/2008 as well as capturing implicit permissions will be focused on.

#41-Get a Lever and Pick Any Turtle: Lifting with Metadata

Report Builder
Speaker: Cade Roux

View Recording: Watch Now!

Download:  Not Available

BIO: Cade Roux, is the recent founder of Rose Crescent, a software and systems consultancy in New Orleans. He has been a professional programmer since 1992, and a user of SQL Server since 1997, managing IT operations at all levels of organizations. He has broad experience in several lines of business, including Route Accounting, Medical and Banking and technical exposure ranging from C/C++ to T-SQL, from the Windows API to Data Warehousing. He loves building great systems and great teams.

Topic: #41-Get a Lever and Pick Any Turtle: Lifting with Metadata
Integrated metadata is a required element of all RDBMSs. In addition to ANSI INFORAMTION_SCHEMA and metadata on implementation-specific features like indexes, SQL Server also offers a very powerful extended properties feature. In this talk, I cover using the basic metadata combined with extended properties and demonstrate practical usage to organize and document a system's design and monitor the health of a system's compliance with design rules.

#43-(In Spanish) - Guía rápida para un mejor uso de esquemas de referencia de XML en SQL

Report Builder
Speaker: Otoniel Diaz

View Recording: Not Available

Download:  Not Available

BIO: (Spanish) Otoniel Diaz es un consultor de Administración, Diseño, Desarrollo de Bases de Datos y Sistemas de Inteligencia de Negocios y Reporteo. Con 5 años de experiencia con SQL y con tres certificaciones MCITP que ofrece Microsoft en la rama de SQL 2008 (Database Developer 2008, Database Administrator 2008 y Business Intelligence Developer 2008), continua preparándose para mantenerse al día con las nuevas tecnologías que Microsoft desarrolla para administración de bases de datos. Es miembro activo del PASS desde el 2008 y actualmente es líder del Capitulo Monterrey promoviendo el crecimiento profesional de sus colegas en su ciudad y compartir experiencias con los demás para integrar mejor la tecnología SQL en Monterrey. Actualmente laborando en Sieena en Monterrey, NL colaborando como mentor interno en bases de datos y trayendo su expertise en SQL a los proyectos manejados para clientes en Estados Unidos

(English) Otoniel Diaz, MCITP (Database Developer 2008, Database Administrator 2008 and Business Intelligence 2008), is a consultant that works with SQL Server technologies including SSIS, SSAS, Transact-SQL and Reporting services. He has five years experience working with these various SQL Server technologies. He likes to keep up with the newest Microsoft technologies. He has participated in SQLPASS as an active member since 2008 and currently leads the Monterrey, Mexico Chapter promoting professional growth in their city colleagues and sharing experiences with others to better integrate SQL technology in his region. He currently works in Sieena in Monterrey, NL as an internal mentor in SQL Server bringing its expertise in SQL to different projects for clients in United States.

Topic: #43-(In Spanish) - Guía rápida para un mejor uso de esquemas de referencia de XML en SQL
XML y SQL pueden ser combinados en muchas y diferentes formas, además de que pueden ayudarte a implementar un gran número de soluciones que en otras ocasiones podrían ser muy complejas, en esta platica te presentaremos algunos concejos de cómo utilizarlos para mejorar tus prácticas de desarrollo de SQL Server.

English: Topic: Quick guide to a better use of XML reference schemas in SQL XML and SQL can be combined in many different ways, plus they can help you implement a large number of solutions that in other times could be more complex, in this talk we will present some tips on how to use them to improve your development practices in SQL Server