Nr: 627
SQLSaturday #627 - South Florida 2017
SessionID: 59903
Create lightning fast Dashboard with Power BI and its Components
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Power BI and more
Speaker: Vishal Pawar
Title: Create lightning fast Dashboard with Power BI and its Components
Abstract:
SessionID: 61635
I'm a DBA. Now what?
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Fabiano Amorim
Title: I'm a DBA. Now what?
Abstract:
If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you. After working for many years as developer and consultant, the SQL Server MVP Fabiano Amorim has being working with many day-by-day DBA tasks. In this session he will speak a little about the DBA job and show some very good tips about how to do it with efficiency.
SessionID: 63682
Artificial Intelligence:Canned Ready to Consume in MS Cognitive Services
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Data Science
Speaker: Joe Homnick
Title: Artificial Intelligence:Canned Ready to Consume in MS Cognitive Services
Abstract:
Microsoft Cognitive Services are a set of APIs, SDKs and services available to developers to make their applications more intelligent, engaging and discoverable. Microsoft Cognitive Services expands on Microsoft’s evolving portfolio of machine learning APIs and enables developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications. Joe will be demonstrating a wide variety of the APIs in multiple clients including PowerApps, Flow and Power BI. He will also be discussing what he learned at Build about new and expanded Cognitive APIs launched there.
SessionID: 63764
The DBA Career Path - An Open Discussion
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Professional Development
Speaker: Andy Warren
Title: The DBA Career Path - An Open Discussion
Abstract:
Join Andy Warren for an open discussion of the challenges and rewards of being a DBA and what the next step on the career path. Is it managing more and larger databases? Working on life critical systems? Moving into management? Or does our path take us more towards BI, or DevOps? No slides, just a lightly moderated discussion!
SessionID: 63974
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Shehab El-Najjar
Abstract:
SessionID: 63991
Using PowerQuery to track progress in tuning a stored procedure or complex view
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Ernest Ostrander
Title: Using PowerQuery to track progress in tuning a stored procedure or complex view
Abstract:
Tuning a lengthy stored procedure or complex view can be a challenge. Set Statistics IO On, and have fun wading through lengthy output. Use PowerQuery to organize that output for you so you can see where intensive operations are and how your tuning is progressing.
The focus of this session is PowerQuery, not stored procedures , views or the tuning process. Learn how to read all text files in a folder with PowerQuery, parse the files to retain useful data and then analyze using either Excel or PowerBI. In the process, learn the basics of the PowerQuery Formula Language.
SessionID: 64055
Query Store
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Sam Mesel
Title: Query Store
Abstract:
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 Query Store features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.
SessionID: 64101
Data Security with Power BI, SSAS, SQL Server and Active Directory
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Hector Villafuerte
Title: Data Security with Power BI, SSAS, SQL Server and Active Directory
Abstract:
In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.
SessionID: 64102
What's new with SQL Server vNext
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Pankaj Satyaketu
Title: What's new with SQL Server vNext
Abstract:
In this session we will be taking a look at the latest advancements in SQL Server vNext, including support for containerization and Linux support. We will also be looking into new features such as clusterless availability groups and retention policies to temporal table.
SessionID: 64441
How to Manage Many Instances of SQL
Event Date: 10-06-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Tracy Boggiano
Title: How to Manage Many Instances of SQL
Abstract:
When managing a single instance it can be fairly easy to keep track of the configuration of that instance, but what about when you have more than 10 instances to manage? How do know they are setup correctly? How do you maintain the databases on each instance and their configurations? How do take care of patching? In this talk we will answer these questions and more as we discuss best practices and technologies (such as PowerShell and CMS) to help keep your instance configurations in-sync.
SessionID: 61657
PowerShell working with Python and SQL Server
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Development
Speaker: Maximo Trinidad
Title: PowerShell working with Python and SQL Server
Abstract:
As PowerShell is the main technology for automation in Windows Datacenters Infrastructure, now becomes clear its importance in other non-Windows Operating Systems. The way I see it, Windows Admin has the advantage with PowerShell as the Linux Admin has the upper hand with Bash/PHP/Python. Here’s where we can collaborate and work with each other.
SessionID: 63467
But I Want it in Excel...
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Data Science
Speaker: Perry Patterson
Title: But I Want it in Excel...
Abstract:
Instead of fighting your users, make them your partners! Save time running reports or making small changes for users... empower the business! You don't have to do the export-import thing! Learn some basic techniques to interact directly with SQL to create beautiful Pivot Tables and Graphs, right from Excel. You can even ensure the CxO will always have fresh data and eliminate sync issues with your other reports.
SessionID: 63911
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Lowell Izaguirre
Abstract:
If Clothes make the Man, Scripts make the DBA!
Lowell Izaguirre presents his strategy and methodology, featuring a suite of hundreds of stored procedures to to allow the analysis,administration and maintenance of server and database objects and "better practices".
This suite of over 100 Database-targeted scripts can turn a Developer or Junior DBA into a superhero. Make yourself part of the top 10 percent!
Scripts help with things like scripting objects, fixing heaps, missing indexes, untrusted constraints, and literally hundreds of issues that may exist in a database.
Lowell's codebase introduces a unified strategy for a huge list of Database Level DBA Tasks, where the stored procedures identify issues, as well as suggest fixes for the the problems encountered!
SessionID: 63973
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Shehab El-Najjar
Abstract:
SessionID: 64080
Becoming a Trusted Advisor
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Professional Development
Speaker: Jay Alexander
Title: Becoming a Trusted Advisor
Abstract:
Innovative Architects has successfully delivered hundreds of projects over the course of our 13 year history using a unique mix of technology excellence and focus on understanding our client’s needs. The purpose of this session is to discuss these core principles and show how a handful of specific areas of focus can make your projects run more smoothly. The topics we cover will include technical delivery, likability, resourcefulness, versatility, expectation management and communication. Our time will be spent explaining how we implement these concepts, what we expect from our consultants in each area and how that translates into lower project stress.
SessionID: 64103
Applied Machine Learning with R Programming and Power BI Dashboard
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Data Science
Speaker: Adriano da Silva
Title: Applied Machine Learning with R Programming and Power BI Dashboard
Abstract:
This presentation covers the steps necessary to build and use prediction function, along with the development of Power BI visualization. We will apply machine learning method with R Programming language and consider its practical application. In addition to this, we will walk through the steps of creating and integrating a Power BI Dashboard to visualize the enriched data.
SessionID: 64154
Enabling EDW and BI workloads on Hadoop with Hive / LLAP
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Business Intelligence
Speaker: Luis Figueroa
Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP
Abstract:
In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!
SessionID: 64485
Know What Your Code is Doing to SQL Server!
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Development
Speaker: Kevin Boles
Title: Know What Your Code is Doing to SQL Server!
Abstract:
SessionID: 64904
Who's Afraid of Entity Framework?
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Development
Speaker: Richie Rump
Title: Who's Afraid of Entity Framework?
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.
SessionID: 65194
5 Things To Consider: Stretching Failover Clustered Instances Availability Groups to Azure
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Edwin M Sarmiento
Title: 5 Things To Consider: Stretching Failover Clustered Instances Availability Groups to Azure
Abstract:
SessionID: 66410
2,4,8 16 - Upgrade your journey with SQL Server
Event Date: 10-06-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration
Speaker: Satya Jayanty
Title: 2,4,8 16 - Upgrade your journey with SQL Server
Abstract:
2,4,8 16 - these aren't just numbers to count or calculate. These are years that how SQL Server evolved as number of years!
Why Upgrade?
Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.
In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.
What to-do and what not-to-do?
A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQL Saturday SQLbits UK.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.
SessionID: 64324
Concurrency Controls and Isolation Levels in SQL Server
Event Date: 10-06-2017 - Session time: 12:30:00 - Track: Database Administration
Speaker: Carlos Colon
Title: Concurrency Controls and Isolation Levels in SQL Server
Abstract:
SQL Server determines how multiple processes access the same data simultaneously based on the transaction isolation levels. Because the locking strategy that the database utilizes to control access to data pages is different between the different isolation level settings, the effects on database performance will also be different. The right isolation level must be chosen to achieve a good balance between data concurrency and performance. In this session we will review the isolation level options in SQL Server, their effects on data locks, and performance considerations when running under each of the isolation level.
SessionID: 65396
Event Date: 10-06-2017 - Session time: 12:30:00 - Track: SQL Server
Speaker: Robert Torres
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.
SessionID: 66513
Event Date: 10-06-2017 - Session time: 12:30:00 - Track: Database Administration
Speaker: Rodney Rubio
Abstract:
SessionID: 66639
Monitor and maintain your SQL Server environment anytime, anywher
Event Date: 10-06-2017 - Session time: 12:30:00 - Track: DevOps
Speaker: Gordon Cornelius
Title: Monitor and maintain your SQL Server environment anytime, anywher
Abstract:
Monitor and maintain your SQL Server environment anytime, anywhere, and on any device. Come join Quest Software for a brief 15 minute presentation on our industry leading solutions. Anyone who attends is entitled to a free license of the solution of their choice!”
SessionID: 62624
Supercharge Your Maintenance Plans!
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: Troy Gallant
Title: Supercharge Your Maintenance Plans!
Abstract:
Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.
In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.
SessionID: 63736
For Love or Money, Your Tech Career
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Professional Development
Speaker: Alex Funkhouser
Title: For Love or Money, Your Tech Career
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 biweekly 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 highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.
SessionID: 63765
Devops Continuous Release for the DBA
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: DevOps
Speaker: Andy Warren
Title: Devops Continuous Release for the DBA
Abstract:
SessionID: 63802
SQL to NoSQL: Querying Azure DocumentDb
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Database Development
Speaker: Jason Brugger
Title: SQL to NoSQL: Querying Azure DocumentDb
Abstract:
NoSQL, or "Not only SQL", might be the greatest misnomer ever. This session will discuss NoSQL queries on DocumentDb, server side scripts, and some of the pros and cons of using NoSQL over a traditional RDBMS.
SessionID: 64032
Virtual HA: Running FCI and AGs in a Virtual Environment
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: Shawn Meyers
Title: Virtual HA: Running FCI and AGs in a Virtual Environment
Abstract:
High availability can be different in a virtual environment. Attendees will learn the pros and cons of running SQL Server FCI or Availability Groups in a virtual environment. In this session we will:
Offer a comparison of the different high availability options that exist between all of available technologies.
Discuss how FCI or AG impacts features of VMware and Hyper-V, and how to work with the administrators of your virtual environment.
Walk through all of the storage options in order to determine the best fit for your organization.
Review key settings and configurations for the virtual platform, the virtual machine, and SQL Server; and demonstrate the best settings to ensure top performance.
SessionID: 64089
Heckin Sweet Reports with Power BI
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Power BI and more
Speaker: Julie Smith
Title: Heckin Sweet Reports with Power BI
Abstract:
Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI. Sample data set used in this presentation is from @DogRates)
SessionID: 64330
Data Science: From theory to practice
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Data Science
Speaker: Josh Kodi
Title: Data Science: From theory to practice
Abstract:
Most of us from Engineering background have learnt Statistics to varying degree in college. With the rising popularity of Data Science, there is tremendous opportunity to put the theory to use in various practical applications.
However, if you have not learnt Statistics earlier, this session will provide the basics of some of the concepts and explain how to apply them to solve various business problems. Some of the examples of topics include Regression, Bayesian, Clustering, and Decision Trees. You will also learn techniques to avoid some of the common pitfalls such as Over-fitting the model.
Finally, the session will give you tidbits to explore advanced concepts on your own.
SessionID: 66408
Big Data with Azure: where to begin? Concepts and best practices
Event Date: 10-06-2017 - Session time: 13:30:00 - Track: Data Science
Speaker: Satya Jayanty
Title: Big Data with Azure: where to begin? Concepts and best practices
Abstract:
Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
SessionID: 61430
R Integration in Microsoft Solutions
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Data Science
Speaker: Ryan Fonnett
Title: R Integration in Microsoft Solutions
Abstract:
Session Abstract: R is a very powerful tool that is used for statistical computing and graphics. R has been adopted by many data scientists around the world and after Microsoft's Revolution Analytics R acquisition is integrated in Microsoft solutions. This introductory session will give a brief history on R and then explain how this popular statistical language is now baked into some of the Microsoft tools such as SQL Server, Power BI, and Azure ML. There will be live demoes that will explain how R can be utilized using each tool.
SessionID: 61633
Advanced SQL Server execution plans
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Fabiano Amorim
Title: Advanced SQL Server execution plans
Abstract:
Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a advanced session, so, expect to see lots of traceflags, undocumented and nasty execution plans.
SessionID: 62511
Introducing the Limitless DBA- Copy Data Management, DBA Style
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Kellyn Pot'Vin-Gorman
Title: Introducing the Limitless DBA- Copy Data Management, DBA Style
Abstract:
Everything in our day to day lives as a DBA is about limits-
• Limits in space
• Limits in platform
• Limits in resources
• Limits in expertise
This session is about how to remove those limits. How to provide all the databases you need without having to constantly ask for more disk space. How to provide a databases as fast as they are needed for new projects, new test cases and new challenges. How to do more with less time, less people and less hardware and last but not least, how to do all of this without having to become an expert in 20 different languages, products and specialties.
Join Kellyn Pot’Vin-Gorman as she demonstrates why virtualization is key to empowering the database administrator. This session will cover how to:
• Ease patching and upgrading.
• Offer virtualized environments for every project- development through production with only a 1/3 or the resources once required.
• How to change OS and database platforms without losing your mind.
SessionID: 62512
The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Kellyn Pot'Vin-Gorman
Title: The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization
Abstract:
- Principles of virtualization and why it’s the answer to so many challenges we face today.
- How easy it is to secure data in the cloud using data masking features.
- The ease of connecting to the cloud and migrating environments.
- How to troubleshoot when issues arise and the tools available to diagnose issues.
SessionID: 63906
SQL Server Tips Tricks
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Nadeem Akhter
Title: SQL Server Tips Tricks
Abstract:
Whether you are new to SQL Server or a pro; this session will provide you tips and tricks which will save you a lot of time and provide you new ways to do complex tasks quickly and easily. You can also share your own tips in this session.
SessionID: 63910
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Lowell Izaguirre
Abstract:
If Clothes make the Man, Scripts make the DBA!
Lowell Izaguirre presents his strategy and methodology, featuring a suite of hundreds of stored procedures to allow the analysis,administration and maintenance of server and database objects and "better practices".
This suite of over 75 Server-targeted scripts can turn a Developer or Junior DBA into a superhero.
Scripts identify server level things like memory, disk speed,backups, database mail,Last Accessed databases or tables, and so much more! Make yourself part of the top 10 percent!
Lowell's codebase introduces a unified strategy for a huge list of Server Level DBA Tasks, where the stored procedures identify best practice variances, issues, as well as suggest fixes for the the problems encountered!
SessionID: 64056
InMemory Improvements on SQL 2016
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: SQL Server
Speaker: Sam Mesel
Title: InMemory Improvements on SQL 2016
Abstract:
SQL Server 2016 lifted several limitations from its initial implementation.
This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.
SessionID: 64079
Azure Data Lake Store Data Lake Analytics - Let's Go Swimming!
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Data Science
Speaker: Audrey Hammonds
Title: Azure Data Lake Store Data Lake Analytics - Let's Go Swimming!
Abstract:
SessionID: 64325
Practical Uses for SQL Server 2016 Dynamic Data Masking
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Carlos Colon
Title: Practical Uses for SQL Server 2016 Dynamic Data Masking
Abstract:
Dynamic Data Masking (DDM) allows database administrators to obfuscate data columns containing sensitive data from unauthorized users without changing the data stored in the database. This new features has some limitations that prevent it from being used as the only mechanism for securing sensitive data, but it does provide additional flexibility to administrators, developers, and support personnel on querying sensitive data and maintaining compliance. In this session we will explore how to set up Dynamic Data Masking for use in production support and for generating production-like test data.
SessionID: 64344
Lightweight geo-replication for SQL Server using the Azure Service Bus
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Herve Roggero
Title: Lightweight geo-replication for SQL Server using the Azure Service Bus
Abstract:
In this session I will provide an overview of the Azure Service Bus and how to use it directly from SQL Server to send messages between multiple SQL Server databases across the globe. Sending messages to a service allows database administrators to replicate data from one database to another, or to multiple databases using a subscription model. This demo introduces a technology called Enzo Unified to allow direct connectivity to the cloud from SQL Server databases.
SessionID: 64856
Brand yourself like a pro
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Professional Development
Speaker: Patricia Monica Ojeda
Title: Brand yourself like a pro
Abstract:
Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them.
In this interactive session you will learn how to use Social Media to create you personal brand to positioning yourself as a pro, increasing your self confidence, increasing sales and much more.
SessionID: 65193
Architecting a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity
Event Date: 10-06-2017 - Session time: 14:45:00 - Track: Database Administration
Speaker: Edwin M Sarmiento
Title: Architecting a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity
Abstract:
So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.
You will learn:
- Common design patterns and guidelines that you need to consider when building your architecture
- Proper selection of quorum configuration
- Network configuration for local and geographically dispersed replicas
- Combining SQL Server Failover Clustering with AlwaysOn Availability Groups
SessionID: 62772
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: Database Administration
Speaker: Maximo Trinidad
Abstract:
SessionID: 64440
Query Store Primer
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: Database Administration
Speaker: Tracy Boggiano
Title: Query Store Primer
Abstract:
SessionID: 64483
On-Demand Creation of Dev/Test/Reporting Databases with SQL Clone
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: DevOps
Speaker: Kevin Boles
Title: On-Demand Creation of Dev/Test/Reporting Databases with SQL Clone
Abstract:
Imagine a world where developers and testers could run production-like environments on their own workstations, created on-demand and self-serviced. Raising tickets and waiting hours or days to get operations to deliver test databases would be a thing of the past.
With Redgate's new tool, SQL Clone, this world now exists. Administrators and developers can create their own database copies in seconds using just MEGABYTES of disk space without ever touching production. Developers can see how their application behaves in a production-scale environment during both development and troubleshooting and operations no longer need to find disk space, provision, etc.
In this session we will examine how SQL Clone uses disk virtualization to enable quick, easy and even automated creation of database copies that are just MB in size.
SessionID: 64698
So You think You can Speak?
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: Professional Development
Speaker: Diana Betancourt
Title: So You think You can Speak?
Abstract:
If you've ever enjoyed or admired the knowledge and know-how of a speaker at a SQL Saturday or a Summit , 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 Microsoft 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 here!
"Do You Think You can Speak" is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL, Business Intelligence, Power BI, or otherwise, that is informative, useful, and entertaining.
SessionID: 65557
Introduction to Visualizations with R
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: Data Science
Speaker: Stephen Ippolito
Title: Introduction to Visualizations with R
Abstract:
R is a popular scripting language for data science and visualizations. In this talk we will be going over the basics of the ggplot2 library along with data.tables and rtiny for the purposes of data visualization.
SessionID: 66200
Event Date: 10-06-2017 - Session time: 16:00:00 - Track: Database Development
Speaker: Dmitri Korotkevitch
Abstract:
This session shows several common mistakes and inefficiencies that can be found in many production systems such as excessive code reuse in the database using the views and multi-statement functions and in the data access code; unnecessary joins and I/O operations in pagination queries; storage of multiple entities in the same tables using XML for entities-specific attributes; usage of the optional parameters in the where clause of the queries; and several others. The session explains the root-cause of performance issues those mistakes introduce and demonstrates how to properly address them in the code and database design.