SQLSaturday #373 - Puerto Rico 2015
Event Date: 05/09/2015 00:00:00
Event Location:
- Sheraton Puerto Rico Hotel
- 200 Convention Boulevard
- San Juan, Puerto Rico
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Increase your SSIS productivity with Biml
Abstract: Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
Speaker(s):
- Reeves Smith
Track and Room: BI - Room 02
Title: Dynamically Increase your Data Awareness
Abstract: Data Profiling is a vital step that is often overlooked in the development process. Integration Services (SSIS) built-in support for data profiling is limited and takes manual user intervention. Learn a new approach to automate data profiling and increase your data awareness. In this session we will walk through a framework that dynamically develops a group of packages that can profile data based on the existing metadata within your current environment. By dynamically tracking the metadata within your environment, you can easily maintain your data monitoring solution. This will enable a more thorough view of your ETL environment that will allow you to spot issues faster and create a more scaled infrastructure based on your current performance needs.
Speaker(s):
- Reeves Smith
Track and Room: BI - Room 03
Title: Hecka Fun with Hekaton
Abstract: There is a lot of buzz behind Microsoft’s In-memory OLTP offering code named Hekaton, but does it really deliver on the performance claims? What are the implementation limits that you need to keep in mind and more importantly what are the use cases where it does and does not makes sense. Join Microsoft Certified Master Jason Horner as he skins the In-Memory OLTP Onion.
Speaker(s):
- Jason Horner
Track and Room: Dev - Room 02
Title: Business Intelligence for Beginners
Abstract: Se plantea la necesidad, historia, metodolog#237;as y tecnolog#237;as aplicadas, as#237; como conceptos para la compreci#243;n integral de Inteligencia de Negocios.
Speaker(s):
- César Oviedo
Track and Room: BI - Room 02
Title: How Active Directory Affects SQL Server
Abstract: If you have ever had a Kerberos or SSPI context error, then you won’t want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you’ll have a check list of things to discuss with your domain administrator when you return to work.
Speaker(s):
- Ryan Adams
Track and Room: DBA - Room 04
Title: Tricks from the DBA Inbox: Real World Performance Tuning
Abstract: n this heavily demo based session, we show some techniques for performance tuning common problems faced by DBA’s Including: how to identify the problem, resolve the issue, and test the solution. Along the way we will also discuss some of theory behind the solutions. We all know there is no such thing as DBCC GO_FASTER but this session is the next best thing.
Speaker(s):
- Jason Horner
Track and Room: DBA - Room 01
Title: Cloud/On-Premise BI Solutions with Office365
Abstract: En esta sesi#243;n se siembran las bases de la implementaci#243;n de soluciones de Inteligencia de Negocios Hibridas, utilizando el SQL Server SSAS On-Premise y Office365 como front-end.
Speaker(s):
- César Oviedo
Track and Room: Cloud - Room 04
Title: Windows Clustering for the DBA
Abstract: You need to implement AlwaysOn Failover Clustering or Availability Groups, but you need help with the Windows Clustering part. I have you covered. We’ll talk about how to plan for network, DNS, Active Directory, and storage. I’ll even provide you with a check list you can use to plan your implementation. We’ll also discuss quorum, how to decide which one to use, and the effect that choice can have on your Failover Cluster Instance and/or Availability Group.
Speaker(s):
- Ryan Adams
Track and Room: DBA - Room 01
Title: Dealing with Errors and Exceptions in SSIS
Abstract: As a developer or business intelligence professional you need to make sure that your SSIS loading or business automation processes works effectively under any circumstance. In this session we will show how to configure your environment and packages to leverage logging modes and capture exceptions and errors using design patters and best practices. We will demo how to configure logging options, transaction options, deal with errors in the control and data flow, and also create a custom solution to monitor and administer your environment.
At the end of this session you will have a better understanding to configure a bulletproof SSIS environment.
Speaker(s):
- Jose L. Rivera
Track and Room: Dev - Room 03
Title: Recovery and Backup for Beginners
Abstract: We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.
In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He’ll also set the record straight around some very common myths around database recovery and backups.
Speaker(s):
- Mike Hillwig
Track and Room: DBA - Room 03
Title: PowerShell for Data Professionals
Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s):
- Aaron Nelson
Track and Room: Dev - Room 03
Title: Enforce Best Practices with CMS and Policy Based Management
Abstract: If you manage a large environment then you know how hard it can be to make sure all your SQL Servers adhere to best practice settings and more importantly is making sure they stay that way. I’ll show you how to check those settings across all your servers with Central Management Server and how it can help you manage a disperse environment. You will also learn how to leverage the power of Policy Based Management to help you enforce those settings and standards in your enterprise. Best of all you will see how to get alerts sent to you when one of your standard settings is changed.
Speaker(s):
- Ryan Adams
Track and Room: DBA - N/A
Title: Setting up your BI Infrastructure
Abstract: We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch. What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will attempt to answer along the way. What are the best practices involved in creating a BI infrastructure. We can discuss whether to outsource this project or rise above our DBA job and do it ourselves.
Speaker(s):
- Paresh Motiwala
Track and Room: Cloud - N/A
Title: MS-ACCESS and SQL Integration
Abstract: Real world apps in real word scenarios using MS-ACCESS and MS-SQL
Speaker(s):
- Edwin Blancovitch
Track and Room: Dev - Room 02
Title: Introduction to AlwaysOn Availability Groups
Abstract: (Spanish) - This session will explain the AlwaysOn Availability Groups feature which is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise.
Speaker(s):
- Jorge Sanchez
Track and Room: DBA - Room 01
Title: Transaction Log Internals: Virtual Log Files
Abstract: Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs.
Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?
In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they’re created, how to identify them, and how to strike the right balance between too few and too many.
Speaker(s):
- Mike Hillwig
Track and Room: DBA - Room 01
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Jorge Sanchez
LinkedIn: Jorge Sanchez
Mr. Jorge S#225;nchez brings +27 years of experience in the IT industry, currently working for Rock Solid Technologies as IT Manager. Previously, Mr. Sanchez worked 8 years in Microsoft Puerto Rico as SQL Server Regional Specialist for Caribbean and Central America with direct focus in Puerto Rico, Costa Rica, Dominican Republic, and Trinidad. Before that, he worked 14 years as Senior Consultant, Developer, and SQL Server Certified Instructor within the Microsoft Partners Ecosystem.
Reeves Smith
Twitter: - SQLReeves
LinkedIn: Reeves Smith
Contact: http://reevessmith.wordpress.com
Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.
Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.
Jorge Sanchez
LinkedIn: Jorge Sanchez
Mr. Jorge S#225;nchez brings +27 years of experience in the IT industry, currently working for Rock Solid Technologies as IT Manager. Previously, Mr. Sanchez worked 8 years in Microsoft Puerto Rico as SQL Server Regional Specialist for Caribbean and Central America with direct focus in Puerto Rico, Costa Rica, Dominican Republic, and Trinidad. Before that, he worked 14 years as Senior Consultant, Developer, and SQL Server Certified Instructor within the Microsoft Partners Ecosystem.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
César Oviedo
Twitter: - @bi_latam
LinkedIn: César Oviedo
Contact: https://www.facebook.com/BusinessIntelligenceLatam
César Oviedo is a Data Platform MVP with more than 12 years of experience working in multidisciplinary projects running roles such as Scrum Master, Project Manager, BI Developer and DB Administrator. With experience leading teams and projects with more than 30 members. Currently focused on Data Science and Big Data platforms. Community Manager at “Business Intelligence LATAM” (BI PASS Chapter Leader for Costa Rica and PowerBI User Community), international speaker and trainer for Data and Cloud technologies.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Edwin Torres
Twitter: - https://twitter.com/_edtorr
LinkedIn: Edwin Torres
An experienced data architect and technical leader, has more than 10 years of consulting practice across different industries and verticals including digital media, advertising, health, government, retail, education and tourism.
Ramon Ponte
Ramon Ponte has over 19 years of experience delivering enterprise architecture and advisory services to medium and large size organizations in Puerto Rico, the Caribbean and Central America. Industries of expertise include government, education, financial services, insurance, and the telecommunication sector. Ramon#39;s area of specialization is Enterprise Application Platforms. This includes SOA, BI, BPM, ALM, Data Management and Enterprise Architecture.
Jose L. Rivera
Twitter: - SQLConqueror
LinkedIn: Jose L. Rivera
Contact: http://sqlconqueror.com
Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.
Paresh Motiwala
Twitter: - pareshmotiwala
LinkedIn: Paresh Motiwala
Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).
He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com
César Oviedo
Contact: http://www.fb.com/BusinessIntelligenceLatam
César Oviedo es consultor en su propia empresa Sensus Data Analytics y en GFT. Ha trabajado durante más de 10 años en entornos empresariales en teconologías Microsoft, así como instructor de SQL Server. Su atención se centra en tecnologias relacionadas a la inteligencia de negocios. César es el lider del Capítulo de PASS de BI para Costa Rica y MVP en SQL Server, Ingeniero de Sistemas Certificado MCSE, MCITP y MCT. Comunidad: www.fb.com/BusinessIntelligenceLatam
Edwin Blancovitch
Contact: http://www.easypayroll.net
Graduated from the Interamerican University in PR, after working a few years administrating the largest food chain in the island and after looking at the needs of local business for software solutions, decided to create his own business Advanced Developers.Net www.advdev.net . After some year’s easy payroll is being used by some of the top 500 business in the island, with more than 500 users handles over than 100 million in payroll every year.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Carla López Narváez
Carla L#243;pez is the Cloud Solution Architect for Microsoft Puerto Rico. In this role, she is responsible of building a technical and security architecture in Azure, Microsoft#39;s cloud, in order to help customers successfully adapt and deploy applications/workloads in the cloud. In addition, Carla has worked before as a Consultant focusing on mobile, web and SharePoint development.
Alan Koo
Twitter: - alan_koo
LinkedIn: Alan Koo
Contact: http://www.alankoo.com
Alan Koo is a 6th time Microsoft MVP in SQL Server with over 15 years of technical experience architecting and developing solutions oriented to increase businesses performance in both public and private sectors. Alan joined Nagnoi, LLC. in 2005 as the technical lead in the Performance Management amp; Business Intelligence Practice. Alan Koo is the co-founder and former President of Puerto Rico PASS. He shares his knowledge through his quot;Microsoft Business Intelligence y mas…quot; blog and the the MSDN Forums.
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Guillermo Caicedo Santiago
Twitter: - @sqltitan
LinkedIn: Guillermo Caicedo Santiago
Contact: http://www.sqltitan.com
Guillermo Caicedo es un profesional de bases de datos y tecnolog#237;a trabajando como Consultor en Nagnoi, LLC. Ha ayudado a numerosas empresas a obtener conocimiento sobre sus datos por desarrollar e implementar soluciones de inteligencia empresarial en sus organizaciones. El Sr. Caicedo tambi#233;n tiene una amplia experiencia desarrollando aplicaciones web y m#243;viles. Guillermo es un Data Platform MVP y l#237;der del Cap#237;tulo PASS para Puerto Rico (PRPASS).
Reeves Smith
Twitter: - SQLReeves
LinkedIn: Reeves Smith
Contact: http://reevessmith.wordpress.com
Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.
Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.
Diana Betancourt
Twitter: - dianabeta
LinkedIn: Diana Betancourt
Former graduate of the quot;Universidad Santa Maria La Antiguaquot; School of Computer Science. I have been involved in the IT world since 1992, since then I have been working with many OS platforms, development languages and databases, among them Unix, Oracle, SUN, Informix, FoxPro, Microsoft SQL Server, just to mention a few. Diana enjoys solving complex performance tuning issues, examining your data using Databricks, designing in Azure SQL Datawarehouse, developing cool visuals using Power Bi, or evangelizing about Microsoft Data technologies at community events like SQLSaturday and local user group meetings.
Sponsors
The following is a list of sponsors that helped fund the event: