Event Location:
Nova Southeastern University
3301 College Ave
Davie, Florida
Abstract:
Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.
Speaker(s): Niran Even-Chen,
Abstract:
Partitioning has long been one of the key feature sets utilized to improve performance or reduce contention within our large tables in SQL Server. However, table partitioning has been solely the prerogative of SQL Server Enterprise edition. Even though that is correct, there are techniques available to us in Standard edition which would accomplish the same result as table partitioning. In this session we will go through the steps needed to configure and use the partitioned views to achieve the same result as table partitioning. We will also configure the maintenance jobs to imitate the sliding window functionality, and for those of us who are lucky to have Enterprise edition, we will see how to be able to take advantage of combining both partitioned views and table partitioning as well as inMemory tables to give us an ability to use double partition elimination based on two different keys as well as the ability to move hot spots data into inMemory OLTP.
Speaker(s): Konstantin Melamud,
Abstract:
Salvi works on a non-profit that connects thousands of Cubans to the web, via email. In Cuba, 25% of the population can access to email only, while 5% access to the Web without restrictions. After three years of work, his non-profit organization has collected several gigs of data that can re-shape our understanding about Cuba. Salvi will show data collected by this great technology, and how fascinating can be interpreting row information from a country that has been censored internally and externally for generations . The audience will have a unique opportunity to learn this technology, access this data and to use their skills to make a worldwide impact.
Speaker(s): Salvi Pascual,
Abstract:
Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone. In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you… - if you are struggling to find enough new clients, - if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you, - if you feel like you are treading water when it comes to marketing. Join this session and get started on your way to becoming a Phenomenal IT Consultant.
Speaker(s): Sebastian Meine,
Abstract:
Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB's elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.
Speaker(s): Silvia Doomra,
Abstract:
SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. In this session we will show how to get started with SQL Server R Services to operationalize R solutions or to create powerful data exploration and predictive modeling solutions.
Speaker(s): Jose L. Rivera,
Abstract:
With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.
Speaker(s): Konstantin Melamud,
Abstract:
This session is designed to teach DBAs and developers the best strategy to transfer large data. We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Speaker(s): Simon Cho,
Abstract:
Analyzing query performance can be tricky. It involves knowing several dynamic management views (DMVs) and accessing query plans that are still in the query cache. If you need to get performance metrics for a query which is no longer in the cache, or if your server is restarted it will be an impossible task. Query Data Store is a new feature that comes to help DBAs. By persisting query execution data over time, it allows reviewing of statements / plans / properties / statistics. This session will show you how to enable and use QDS features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.
Speaker(s): Sam Mesel,
Abstract:
When it comes to disaster recovery and high availability with SQL Server, there are a lot of options. Most business owners (and many DBAs) lump disaster recovery (DR) and high availability (HA) together. And while they do share some pieces, they also call for different strategies. Should you use one or more of these options? And what criteria should you use to make the choice? It’s important that you understand the decision tree that can guide you to select the right option(s) for your organization and that you can clearly explain those choices to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This session will give you a high-level understanding of the options, their costs and complexities, and reasons for using each of them.
Speaker(s): Kendal Van Dyke,
Abstract:
Power BI has a many moving parts that can make it difficult to know when and where each part of the tool is necessary. In this half day session get a clear end to end journey through creating a Power BI solution. Start with the data discovery phase by importing and applying business rules to your data. Then load that data into a data model where you can apply hierarchies and calculations. Finally using that data model design reports to visualize the results. Once complete learn how the results can be shared with others by creating dashboards on the Power BI service. Taking this end to end trip through the tool will allow you to fully understand how each piece fits together.
Speaker(s): Devin Knight,
Abstract:
In this session we will be reviewing the highlights of what's new with SQL Server 2016. I will also be demonstrating several of the hero features in SQL Server 2016 such as Always Encrypted, Operational Insights, Polybase, Hybrid Cloud and much, much more.
Speaker(s): Pankaj Satyaketu,
Abstract:
Just because NoSQL is taking off doesn't mean that SQL developers are left behind. We'll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we'll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we'll demonstrate how we can work with MongoDB from SSIS.
Speaker(s): Ben Galluzzo,
Abstract:
You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL. In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel, SQL Server Management Studio and other third party tools, to use as practical examples of how to write MDX queries.
Speaker(s): Shabnam Watson,
Abstract:
Becoming certified in SQL Server is a great career move and can be very rewarding for a new or seasoned database professional. This session will provide you with an overview of the SQL Server Certification program, including the changes made to the program for certification on SQL Server 2012 and 2014. You’ll also discover the benefits of becoming certified, and some of the best ways in which to do so. You’ll leave the session armed with great tips and tricks to pass the exams on the first try. If you are thinking about getting certified in SQL Server in the near future, then this session is definitely for you.
Speaker(s): Marilyn Rousseau,
Abstract:
Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn't self-aware. Chances are it is using the Microsoft Entity Framework (EF). EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it's changed over time. We'll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we'll review EF-generated T-SQL and give some tips on how to improve performance. If you're a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.
Speaker(s): Richie Rump,
Abstract:
Assume that you want to create packages to load 100's files (text or Excel) that you receive from vendors and structure of data in the files are different. How long it can take? How about creating a simple tool for your manager who doesn't know anything about SSIS to create packages for transferring data between servers? You want to find out which package, among 100's of them already running, update/insert a particular table . How long it will take to open each package and get the answer? We can automate all these process using C# (or Visual Basic) and SSIS SDK. Can it be more interesting if the conversion of those 2008 packages to 2012/2014 and deploy it to the new SSISDB using project deployment model can be automated too? If you are an SSIS expert with some knowledge of programming and like automation, you will have fun in this session.
Speaker(s): Jemini Joseph,
Abstract:
In this session we will review our database as a service offering, Azure SQL Database. We will also recap and demo the recent advancements such as Threat Detection, Query Performance Insight, Query Store, Database Index Advisor and more.
Speaker(s): Pankaj Satyaketu,
Abstract:
Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times. We'll begin with an overview of how a Common Table Expression is constructed. Then we'll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.
Speaker(s): Ben Galluzzo,
Abstract:
In this session I will show you how to access multiple data sources (including databases, flat files on FTP sites, Azure Tables and even MySQL) in parallel, all at the same time, using a single T-SQL command, and return data from these data sources into a single output. This allows you to remove complex intermediate processing steps, query multiple data sources without moving data, and get to your information faster. This session introduces you to a project that has been in development for a few years, and is meant to open new doors to data acquisition and analytics. If you deal with importing data in SQL Server from multiple sources, this session is for you.
Speaker(s): Herve Roggero,
Abstract:
As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.
Speaker(s): Michael Keleher,
Abstract:
If you've ever enjoyed or admired the knowledge and know-how of a speaker at an event like this, remember that they started where you are, with an interest in SQL and I.T. topics, a passion to learn more, but also with the desire to share what they know with their peers. If you have an interest in SQL or any of the Data platform technologies, and have learned something useful in your I.T. career, consider giving back to the community by sharing what you know. While it may seem intimidating to give an hour long talk at an event like this, remember that every great speaker had to start somewhere. And for you, maybe that start is Speaker idol. Speaker Idol is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL or otherwise, that is informative, useful and engaging. This is a great way to get experience presenting a technical topic to the community, and a great way to find and develop the next generation of speakers!
Speaker(s): Diana Betancourt,
Abstract:
Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and PowerBI to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.
Speaker(s): Rodney Landrum,
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability. You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker(s): Sebastian Meine,
Abstract:
Join Joe on a fun and informative session on the current state of Microsoft Business Intelligence (BI) offerings. We will look at the array of tooling around BI in SQL Server 2016, Power BI and Cortana Intelligence. There have been major changes in reporting and cognitive data source capabilities the last few months. This session will get you caught up on your current BI possibilities with many dazzling demos.
Speaker(s): Joe Homnick,
Abstract:
It's Monday morning and everyone is complaining that the database is slow. You see the problem - even though indexes aren't fragmented and statistics are up to date the query optimizer is choosing a bad plan. Users want it fixed (now!) and you know a way to get things working again but you're not allowed to change code because...it's production. What's a good DBA going to do? Show the query optimizer that you're the boss with plan guides! In this session you'll learn what plan guide are, how they work, and when to (and not to) use them to make under-performing queries behave.
Speaker(s): Kendal Van Dyke,
Abstract:
This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"
Speaker(s): Jeffrey Garbus,
Abstract:
The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, Parameter Sniffing and Value List Handling. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let's get things moving!
Speaker(s): Mindy Curnutt,
Abstract:
This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.
Speaker(s): Mindy Curnutt,
Abstract:
• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue? • Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are using the latest, most marketable technologies? In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.
Speaker(s): Alex Funkhouser,
Abstract:
Please join the local Pure Storage account team for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.
Speaker(s): Robert Torres,
Abstract:
Today we live in a world where quad core cell phones is becoming a common theme. Cloud computing is cheap and the services are advanced. The sheer quantity of services can blow your mind. This talk goes through how to deliver product where intelligence is at the core of the product. We will cover building intelligence into the device, retrieving data from the device, analyzing it in the cloud and then surfacing important insights back into the device.
Speaker(s): David Crook,
Abstract:
Learn how Cisco and Microsoft's strategic partnership has led to the creation of a powerful joint solution-MSFT SQL Server on Cisco UCS-to help companies migrate their SQL Server workloads to 2014/2016 versions.
Speaker(s): Ed Cho,
Abstract:
Come see Dell Software’s premier SQL Server diagnostics solutions Spotlight. Spotlight can ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Come learn how Spotlight can provide intuitive overviews of performance health, automated alerts with actions, and mobile device support. Everyone who attends will also receive a free 3 month license of the solution!
Speaker(s): Gordon Cornelius,
Abstract:
If you are a working professional there is a chance that stress has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
Speaker(s): Karlyn LeBlanc,
Abstract:
The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it's underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.
Speaker(s): Kevin Boles,
Abstract:
This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.
Speaker(s): Maximo Trinidad,
Abstract:
A Primer for SSAS for those who know of SSAS but not what SSAS is and why we use it. In this session we will answer: What are Cubes? Why do we Use Them? Is it the Right Tool For the Job? What Makes a Cube a Cube? How do they work? and any general questions or perspectives around SSAS.
Speaker(s): Alexander Nykolaiszyn,
Abstract:
We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL SSAS are a game changer for the BI market and specially for the Microsoft segment.
Speaker(s): Yoav Yetinson,
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s): Kevin Boles,
Abstract:
This session is well suited for DBAs and Developers who are constantly exposed to production environment because the session covers the common issues many neglect without recognizing. We demonstrate examples of incorrect development methodologies and analyze internal transaction logs in multi-transaction cases. After identifying the common mistakes, we will cover the best practice to avoid nested transactions in a stored procedure for smart error handling. We will also learn the basics of minimally logged operations.
Speaker(s): Simon Cho,
Abstract:
You've used every database trick you know and the latencies and user experience are still unacceptable. Now what? Join Kaminario as we discuss a number of Use Cases where helped clients database challenges by deploying a cost effective All Flash Array (AFA).
Speaker(s): Olivier Renard,
Abstract:
Everyone is eager to get started with Microsoft’s new offering: Power BI. It promises to be a great delivery system of information and analytics. This session will show some tips and tricks to getting started fast and deliver some real WOW factor to your users. We will explore bringing in data, enhancing it, and then displaying it. We will look at how to work with the standard visualizations as well as a few custom visualizations. We will discuss publishing options to allow us to show off our work. Come join the fun and see why there is so much ado about Power BI.
Speaker(s): Pam Shaw,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: http://www.linkedin.com/in/simonsql
Contact: http://simonsql.com
Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group. As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups. He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers. He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team. He is pretty much working on SQL server running on kubernetes.
LinkedIn: http://www.linkedin.com/in/AlexFunkhouser
Contact: http://www.SherlockTech.com
Alex Funkhouser wrote his first lines of code in 1980 on a TRS80. He is an avid supporter of the technology community, earned a Bachelor of Science from Washington University and an International MBA from The Netherlands. Alex#39;s recruiting philosophy: “Know who is best at what, and know who needs the best!quot;
Contact: http://www.sqltwist.com
Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft's Flagship Database Engine, SQL Server. Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation. Pankaj is an active supporter of local user groups and SQL Saturday events in Florida. He is also a graduate of Florida Atlantic University.
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
LinkedIn: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.
Contact: http://www.sqltwist.com
Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft's Flagship Database Engine, SQL Server. Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation. Pankaj is an active supporter of local user groups and SQL Saturday events in Florida. He is also a graduate of Florida Atlantic University.
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.
LinkedIn: http://linkedin.com/in/richierump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
LinkedIn: https://www.linkedin.com/in/silviadoomra?
Silvia is a Program Manager in Azure SQL Database Team. She has experience of over 8 years in Microsoft working on different technologies like Windows Server, Visual Studio, Mobile Operators. Currently she is working in Azure SQL Database team building scale-out database technologies.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: https://www.linkedin.com/in/salvipascual
Contact: https://apretaste.com
Salvi Pascual is a university professor, an experienced software developer, a systems architect, and a technology trailblazer for social good through his open source project, Apretaste. His work has an immediate and positive affect on thousands of people internationally, and he has been nationally recognized by the press and media as a technology innovator. He earned his master degree in Computer Science from Florida International University and continues to teach and inspire future technology creators. Salvi loves traveling and strives to not be the worst pool player in the world.
LinkedIn: http://www.linkedin.com/in/marilynro
Marilyn Rousseau is a DBA Manager, Consultant, and Coach with over 25 years of technology experience. She specializes in Health IT with an emphasis on data management. Marilyn currently serves as Vice President of the South Florida BI User Group. Prior to that, she served on the board of the South Florida SQL Server User Group for 3 years. She#39;s been an active PASS volunteer since 1999 and is a frequent volunteer of SQL Saturdays in Florida. She holds a Bachelor in Computer Science, an MBA, and is currently working on a doctorate in Adult Education and HR Management at FIU. Marilyn is passionate about all things SQL Server and enjoys helping IT professionals reach their personal and professional goals.
Contact: http://www.indiedevspot.com
David is a Technical Evangelist at Microsoft focused on Analytics and Innovation. He has past experience at Microsoft Consulting Services as a development engineer working on projects for some of Microsoft#39;s largest customers across multiple verticals.
Contact: http://cloud-abstract.com
Niran Even-Chen (@niranec) is a Staff Solution architect at VMware Inc. In his role as a Microsoft enterprise applications architecture specialist Niran is responsible for developing solutions for SQL Server with VMware solutions, writing white papers and is also a frequent speaker in different venues such as VMUG conferences, SQL Saturday user groups, VMworld conferences and more. Niran is certified as VMware certified design expert (VCDX) #142 for datacenter virtualization and Cloud with 15 years of experience in the industry designing and architecting enterprise level solutions.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Contact: http://geekswithblogs.net/hroggero
Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
LinkedIn: http://www.linkedin.com/in/pshaw1129/
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQL Saturday Tampa.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: http://www.linkedin.com/in/simonsql
Contact: http://simonsql.com
Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group. As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups. He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers. He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team. He is pretty much working on SQL server running on kubernetes.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQL Saturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/pub/michael-keleher/3/b09/a56
Michael Keleher is a Microsoft Certified Professional and is currently the Database Administrator at Bisk Education, Inc in Tampa, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle plus another three as a Database Administrator. He enjoys getting involved in security and performance tuning projects.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/in/deknight/
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
LinkedIn: http://www.linkedin.com/in/dianabeta
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 SQL Saturday and local user group meetings.
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/
Contact: http://www.maxtblog.com
Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQL Saturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: http://www.linkedin.com/profile/view?id=189422534
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 SQL Saturday 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.
LinkedIn: http://www.linkedin.com/pub/ben-galluzzo/20/7b9/389/en
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
LinkedIn: https://www.linkedin.com/in/shabnamwatson
Contact: https://shabnamwatson.wordpress.com/
Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI. She is an active member of PASS community and has spoken at PASS Summit, SQL Saturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQL Saturday Atlanta BI Edition. She holds a master's degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).
LinkedIn: https://www.linkedin.com/in/deknight/
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
LinkedIn: http://www.kaminario.com
Twenty-five year IT Professional in both Sales and Sales Management. 15-years in the data storage space with younger technology companies like Network Appliance (pre-IPO), 3PAR/HP, and Kaminario. Focused on evangelizing the benefits of ALL Flash Arrays for today#39;s toughest data use cases.
I am the Database Solutions Account Manager for the Southeast. Happy to discuss all things SQL Server and Quest Software's future investment in SQL Server technologies.
LinkedIn: https://www.linkedin.com/in/deknight/
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Robert Torres has been the south Florida systems engineer at Pure Storage, Inc. since November, 2015. Robert has been in the enterprise IT industry for over 20 years and today serves as the Pure Storage south Florida technical lead in helping customers transform into the next generation data center. He has held technical leadership positions during his tenures at CDW and Carnival Cruise Lines ranging from enterprise data center architect, vendor management and enterprise storage administration.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQL Saturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
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
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQL Saturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: https://www.linkedin.com/in/ed-cho-2b37332?trk=hp-identity-name
Strategic Partner Marketing Manager who oversees Cisco#39;s partnership with Microsoft.
will be provided later on
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Contact: http://www.littlebigintel.com/
Alexander Nykolaiszyn is a Sr. Business Intelligence Developer for Citrix Systems. Specializing mostly in the BI Stack and Dashboard Design. In his spare time he thinks way too much about the consumption and perspective of business intelligence as well as putting his family to sleep with way too much enthusiasm about data.
LinkedIn: https://www.linkedin.com/in/joehomnick
Contact: http://joeblog.homnick.com/
Joe Homnick is a Microsoft Regional Director since the start of the program over 20 years ago and is a principal owner of Homnick Systems (HSI), a Microsoft Gold Certified Partner located in Boca Raton, Florida. HSI is one of the most established Microsoft Certified Partners in the world, dating back to the beginning of the program in 1993. HSI delivers Microsoft services in the areas of system development and implementation through software consulting, development, training and mentoring.
LinkedIn: https://www.linkedin.com/in/jeminijoseph
I#39;ve been working in Microsoft BI field since 2003 and worked in SSIS/SSAS/SSRS since 2005. Working as an independent consultant in BI field since 2007 for different clients across the country (US). Most of my experience is in SSIS and worked different versions of SSIS from 2005 to 2014.
LinkedIn: Public Profilehttps://www.linkedin.com/in/yoav-yetinson-83598545
I believe success on a global level requires leadership, a strong work ethic, innovation, but most importantly – working well as part of a team. I possess strong interpersonal communication skills, which were acquired in my jobs as a real estate agent, property manager, and enterprise software sales. My service in the Army helped shape my leadership skills. Through my education I attained business and technical skills including the ability to create databases, design systems and write basic codes in C++ and SQL. I have a very deep interest in BI and the financial sector. I acquire my financial knowledge through trading stocks, reading financial articles, and discussing recent events with friends who work in the industry.
The following is a list of sponsors that helped fund the event.
Dobler Consulting Services LLC
Nova Southeastern University#39;s College of Engineering and Computing