Nr: 373
SQLSaturday #373 - Puerto Rico 2015
SessionID: 21680
Setting up your BI Infrastructure
Event Date: 09-05-2015 - Session time: 00:00:00 - Track: Cloud
Speaker: Paresh Motiwala
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.
SessionID: 23748
Enforce Best Practices with CMS and Policy Based Management
Event Date: 09-05-2015 - Session time: 00:00:00 - Track: DBA
Speaker: Ryan Adams
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.
SessionID: 11878
Business Intelligence for Beginners
Event Date: 09-05-2015 - Session time: 09:45:00 - Track: BI
Speaker: César Oviedo
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.
SessionID: 17632
Introduction to AlwaysOn Availability Groups
Event Date: 09-05-2015 - Session time: 09:45:00 - Track: DBA
Speaker: Jorge Sanchez
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.
SessionID: 22788
Dynamically Increase your Data Awareness
Event Date: 09-05-2015 - Session time: 09:45:00 - Track: BI
Speaker: Reeves Smith
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.
SessionID: 15863
Hecka Fun with Hekaton
Event Date: 09-05-2015 - Session time: 11:15:00 - Track: Dev
Speaker: Jason Horner
Title: Hecka Fun with Hekaton
Abstract:
SessionID: 20585
Recovery and Backup for Beginners
Event Date: 09-05-2015 - Session time: 11:15:00 - Track: DBA
Speaker: Mike Hillwig
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.
SessionID: 23749
How Active Directory Affects SQL Server
Event Date: 09-05-2015 - Session time: 11:15:00 - Track: DBA
Speaker: Ryan Adams
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.
SessionID: 13611
MS-ACCESS and SQL Integration
Event Date: 09-05-2015 - Session time: 13:45:00 - Track: Dev
Speaker: Edwin Blancovitch
Title: MS-ACCESS and SQL Integration
Abstract:
Real world apps in real word scenarios using MS-ACCESS and MS-SQL
SessionID: 20587
Transaction Log Internals: Virtual Log Files
Event Date: 09-05-2015 - Session time: 13:45:00 - Track: DBA
Speaker: Mike Hillwig
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.
SessionID: 36695
Dealing with Errors and Exceptions in SSIS
Event Date: 09-05-2015 - Session time: 13:45:00 - Track: Dev
Speaker: Jose L. Rivera
Title: Dealing with Errors and Exceptions in SSIS
Abstract:
At the end of this session you will have a better understanding to configure a bulletproof SSIS environment.
SessionID: 15864
Event Date: 09-05-2015 - Session time: 15:15:00 - Track: DBA
Speaker: Jason Horner
Abstract:
SessionID: 22786
Increase your SSIS productivity with Biml
Event Date: 09-05-2015 - Session time: 15:15:00 - Track: BI
Speaker: Reeves Smith
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.
SessionID: 8876
PowerShell for Data Professionals
Event Date: 09-05-2015 - Session time: 15:15:00 - Track: Dev
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 11887
Cloud/On-Premise BI Solutions with Office365
Event Date: 09-05-2015 - Session time: 16:45:00 - Track: Cloud
Speaker: César Oviedo
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.
SessionID: 23751
Windows Clustering for the DBA
Event Date: 09-05-2015 - Session time: 16:45:00 - Track: DBA
Speaker: Ryan Adams
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.