SQLSaturday #378 - Curacao 2015
Event Date: 05/23/2015 00:00:00
Event Location:
- University of Curacao
- 111 Jan Noorduynweg
- Willemstad, Curaçao, Netherlands Antilles
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: Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure
Abstract: DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will look at new and interesting way to load, transform, merge and analyze configuration and performance data for many servers simultaneously. I will also demonstrate how to best utilize that data for reports in Excel, SSRS and Visio to get the most out of automation, standardization and visualization with the new Power tools.
Speaker(s):
- Rodney Landrum
Track and Room: Track 1 - Aula
Title: 5 Steps to Being a Top DBA–Learning Automation in SQL Server
Abstract: Being a DBA is tough job–there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as: • Fully Automating SQL Server Installations • Dynamically Adding Databases to an Availability Group • Syncing jobs and logins between Availability Group members • Patching SQL Servers automatically • Other techniques for process automation This session will benefit both Junior and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 2 - Aula
Title: Power BI in the Fast Lane–Visualizing Formula 1
Abstract: Power BI provides a great toolkit for building data models and doing rapid analysis of data. When you combine the broad capabilities of Power Query to gather external data through a wide variety of data sources and Open APIs. In this session, you will learn about the entire Power BI toolset using data from the current Formula 1 season. You will learn how to use graphics (track maps) as icons for filtering in Power View. You will learn how to relate data in a Power Pivot data model to build complex visualizations. You will learn about Power BI QA and how it can provide answers from your data.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 1 - Classroom B
Title: In Memory OLTP
Abstract: If you have had waits due to high disk IO, come see this session where you will be introduced to In-Memory objects. In this session we will learn how In-Memory object will reduce the disk IO, what are the two types of memory tables, how to create them and how to maintain them. We will also see how we can manage memory for these In-Memory objects.
Speaker(s):
- Roy Ernest
Track and Room: Track 2 - Classroom B
Title: Troubleshooting SQL ServerBasics
Abstract: Discover in this session how to create a line of investigation in SQL Server. You will be able to find the root cause of the problems and solve them learning how to analyze the historical and live data in SQL Server. Download in the final of the presentation the SeatBelt kit with all the scripts to use in your environment.
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: Track 2 - Aula
Title: Protecting SQL Server against Hackers [Best Practices]
Abstract: In this session you will learn how to protect the various forms of attacks that are carried out in SQL Server, this session will teach the best security practices, lest’s dig at the thought of a hacker and learn how he can access SQL Server of course after the session we will avoid such achievement Ready to learn how a hacker can break into your SQL Server? Join me in this internal session of SQL Server + Kali Linux.
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: Track 2 - Aula
Title: Super Hybrid 2014
Abstract: Most SQL Servers run on-premises. This one runs on the Cloud (too). More and more, Microsoft is betting in the Cloud and hybrid environments are already a reality. We already have few different options to integrate on-premises with cloud environments, which opens a new horizon of possibilities. On this session, we will explore the available options and understand how could we take advantage of this option, as well as show some action - with some demos.
Speaker(s):
- Murilo Miranda
Track and Room: Track 2 - Aula
Title: SQL Server 2012 AlwaysON (HADR) for dummies
Abstract: SQL Server 2012 introduced a new High availability concept Always ON. Always ON Availability Groups allows you to configure failover for one database, a set of databases or the entire instance again something you could not do with database mirroring.This session will cover the HADR from the basics to how to implement SQL Server 2012 Always On feature.
Speaker(s):
- Rohan Joackhim
Track and Room: Track 2 - Classroom B
Title: Buffer Pool Extension (BPE) - How it works?
Abstract: A new feature of SQL Server 2014, Buffer Pool Extension (BPE) promises improvement on OLTP workload like systems, taking advantage of fast persistent disks. On this session we will enter in some theoretical details regarding this new technology, as well as some demos.
Speaker(s):
- Murilo Miranda
Track and Room: Track 2 - Aula
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Rodney Landrum
Twitter: - @SQLBeat
Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/
Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP
Rohan Joackhim
Twitter: - @rohanjoackhim
LinkedIn: Rohan Joackhim
Rohan has been working with SQL Server since 2001. His experience includes SQL Server projects dealing with HP Europe, financial institutions in Canada and data centers in the Dutch Caribbean. He is currently dealing with databases in 24/7 high availability environments . He was an active member and a presenter of the PASS chapter Toronto. Rohan holds a Bachelor of Computer Engineering degree and he is MCDBA SQL Server 2008 and ITIL V3 certified.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Roy Ernest
Twitter: - @RumblingDBA
LinkedIn: Roy Ernest
Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/
Roy Ernest (Twitter: @RumblingDBA) currently works as the Manager of the IT-DBA Department for Zarb Corporation. He is the Leader of the Curacao SQL Server User group. Roy is very active in the SQL Server community and volunteers his time for the PASS organization. You can read his blog at http://www.sqlservercentral.com/blogs/dba_rumblings/default.aspx.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Murilo Miranda
Twitter: - murilocmiranda
LinkedIn: Murilo Miranda
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Murilo Miranda
Twitter: - murilocmiranda
LinkedIn: Murilo Miranda
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Sponsors
The following is a list of sponsors that helped fund the event: