Nr: 680
SQLSaturday #680 - Kansas City 2017
SessionID: 66781
LIVE SQL Server 2017 LINUX Availability Group buildout!
Event Date: 07-10-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Dave Walden
Title: LIVE SQL Server 2017 LINUX Availability Group buildout!
Abstract:
Full LIVE buildout of an 2-node SQL Server 2017 CTP 2 Availability Group, on Linux! We're going to start from scratch, and cover allocating VMs in Hyper-V, loading the OS, general configuration of the operating system, installing SQL Server, and finish with an controlled failover of SQL Server using native Linux utilities. We'll talk about each step along the way
SessionID: 67648
Data Modeling for the Modern Enterprise
Event Date: 07-10-2017 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Ryan Casey
Title: Data Modeling for the Modern Enterprise
Abstract:
This session is theoretical with a focus on the many ways that we can model data. We will discuss why we select one modeling technique over the other in different user scenarios. These different scenarios will vary by industry and company, two main scenarios include: purchasing a product and storing the data related to the sales transaction, or visualizing the total sales for a product, month over month, for the calendar year 2016. Diagrams will be used to explain these different models and try to bring a more tangible aspect to the theoretical aspects of the discussion. Demos using IDERA ER/Studio Data Architect will be used to conclude the presentation.
Why Model Data
• Business Benefits and Value
Different Model Types
• Enterprise Model
• Conceptual Model
• Logical Model
• Physical Model
• Dimensional Model
Different Modeling Techniques
• Normal Form Modeling
• Star Snow Flake Schema
• Slowly Changing Dimensions
• Many to Many Relationships
SessionID: 68672
Hidden Power: Service Broker
Event Date: 07-10-2017 - Session time: 08:45:00 - Track: Other
Speaker: Ankit Baria
Title: Hidden Power: Service Broker
Abstract:
Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers.
With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.
SessionID: 68902
Introduction to R
Event Date: 07-10-2017 - Session time: 08:45:00 - Track: Analytics and Visualization
Speaker: Jeff Renz
Title: Introduction to R
Abstract:
SessionID: 68920
The Junior Developer's Handbook
Event Date: 07-10-2017 - Session time: 08:45:00 - Track: Application Database Development
Speaker: Doug Lane
Title: The Junior Developer's Handbook
Abstract:
SessionID: 66761
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Anthony Nocentino
Abstract:
SessionID: 68428
SQL Unit Testing with T-SQLt
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Kevin Trojanowski
Title: SQL Unit Testing with T-SQLt
Abstract:
Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.
SessionID: 68459
Remote SQL Server Troubleshooting and Monitoring Using SSIS
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Don St. Cyr
Title: Remote SQL Server Troubleshooting and Monitoring Using SSIS
Abstract:
We have over 3500 remote installations of SQL Server and only 3 DBAs to find and resolve issues. While some installations need daily examination others operate for months without any attention at all.
We needed a system to keep a light, revolving set of data that we could quickly pull back and analyze when issues were escalated to us.
This system also had to be modular so we could add or remove queries, as needed, while always keeping the data fresh.
In this session I'll use Glenn Berry's diagnostic queries and SSIS to show how we collect and store data on our remote systems. When problems arise we download the data and use Powershell to digest it into a simple report.
SessionID: 68985
Service Broker Empowering near Real-time Mainframe Analytics
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Brendon Collier
Title: Service Broker Empowering near Real-time Mainframe Analytics
Abstract:
If you've learned the basics of Service Broker, this discussion will help you understand how to design a Service Broker architecture that allows for near real time message processing from external sources. In this case, see a system designed to handle 5 million varied messages an hour in less than 750 milliseconds across multiple, distributed commodity SQL Servers. Discussion of service broker design and optimization, conversation management, error handling and logging, and operational metrics.
SessionID: 69786
Preparing to be Hacked
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
Speaker: Bill Graziano
Title: Preparing to be Hacked
Abstract:
They are going to get in. This session talks briefly about how they get in. But they are going to get in. It talks a little about security best practices. But one little mistake by anyone and they are in. How will you know they’re in? How will you know how they got in? What do they want? How will you know what they’re doing? How will you know if you’ve kicked them out? This session will focus on the type of logging and tripwires you’ll need to respond to a breach of your SQL Servers. It includes a mix of technical solution and process recommendations based on actual incidents.
SessionID: 69825
Set Me Up: How to Think in Sets
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Brian Hansen
Title: Set Me Up: How to Think in Sets
Abstract:
SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.
We will look at T-SQL features that can break set-based processing -- generally meaning poor performance -- and gather empirical evidence to support that assertion. We'll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.
SessionID: 69892
Tallgrass Consulting
Event Date: 07-10-2017 - Session time: 12:15:00 - Track: Other
Speaker: KC SQLSaturday
Title: Tallgrass Consulting
Abstract:
Learn more about how Tallgrass is your partner in achieving success. We provide expertise and ingenuity to solve your business challenges and enable execution for impactful results
SessionID: 69893
Rockhurst University – Business Intelligence Analytics Programs
Event Date: 07-10-2017 - Session time: 12:15:00 - Track: Other
Speaker: KC SQLSaturday
Title: Rockhurst University – Business Intelligence Analytics Programs
Abstract:
Rockhurst University – Business Intelligence Analytics Programs
Come learn about Rockhurst University’s unique certificate and master’s degree programs in Business Intelligence and Analytics. Certain courses are now being offered online for the Spring semester.
SessionID: 69895
Datrium
Event Date: 07-10-2017 - Session time: 12:15:00 - Track: Other
Speaker: KC SQLSaturday
Title: Datrium
Abstract:
Learn more about how Datrium is revolutionizing data storage
SessionID: 69896
Cohesity
Event Date: 07-10-2017 - Session time: 12:15:00 - Track: Other
Speaker: KC SQLSaturday
Title: Cohesity
Abstract:
Learn how Cohesity can help tame your data sprawl
SessionID: 69897
Quest
Event Date: 07-10-2017 - Session time: 12:15:00 - Track: Other
Speaker: KC SQLSaturday
Title: Quest
Abstract:
Quest Software Update
- Commitment to SQL Server Market
- Solutions Overview
Monitoring and Workload Analysis
Historical Trending
Ensure Coordination From DEV to TEST to PROD
Backup, Compression, and Recovery
SessionID: 66746
ORMs and the DBA: How to Make Both Happy
Event Date: 07-10-2017 - Session time: 12:45:00 - Track: Application Database Development
Speaker: Dan Mallott
Title: ORMs and the DBA: How to Make Both Happy
Abstract:
SessionID: 67933
Azure Machine Learning 101
Event Date: 07-10-2017 - Session time: 12:45:00 - Track: Analytics and Visualization
Speaker: Kathi Kellenberger
Title: Azure Machine Learning 101
Abstract:
SessionID: 68415
Source Control and Database Projects - Just Do It
Event Date: 07-10-2017 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Leslie Weed
Title: Source Control and Database Projects - Just Do It
Abstract:
If you aren't using database projects you should be and if you aren't using any source control well..... NOW IS THE TIME. We'll review basic functionality and purpose of both and walk through how they work together. Let's talk about the type of foundation pieces you need to pay attention to and how to organize this into team and agile work. Lots of tips and tricks to remove the often experienced headaches that developers have experienced with implementing both of these items.
SessionID: 68907
Don't just code it—Generate It
Event Date: 07-10-2017 - Session time: 12:45:00 - Track: Application Database Development
Speaker: Kevin Mackey
Title: Don't just code it—Generate It
Abstract:
Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
- Source to Target mapping documents can be used to generate the code to effect the mapping.
- Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
- Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
- Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
SessionID: 66776
Continuous Deployments using SSDT
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Christopher Wolff
Title: Continuous Deployments using SSDT
Abstract:
Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.
SessionID: 66780
Index Speed Demons - How To Turbo-Charge Your Text Based Queries Using Full-Text Indexing
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Adam Koehler
Title: Index Speed Demons - How To Turbo-Charge Your Text Based Queries Using Full-Text Indexing
Abstract:
We all want to improve the speed of our databases to make sure they run optimally. In this session we will explore relational and full-text indexes, their internals and uses. We’ll take a look at some alternatives to full-text indexes and their pitfalls. We’ll also explore turbo-charging the performance of your text-based search criteria using full-text indexes.
SessionID: 67068
SQL and BI Business Value
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Professional Development
Speaker: Matthew Bowers
Title: SQL and BI Business Value
Abstract:
Determining business value for SQL and BI in the enterprise. Establishing a business case, purpose of a business case, business case components, SQL and BI Value, value in the Cloud.
Have you been challenged determining value? Identifying the basic problem? Communicating the business benefit? This session is a great business introduction to these concepts! Helping IT leaders bridge the gap between IT and business!
Participants will learn about the basics of determining business value for a solution.
SessionID: 67381
Working with Temporal Data in SQL Server
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Application Database Development
Speaker: David Maxwell
Title: Working with Temporal Data in SQL Server
Abstract:
In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you'll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.
SessionID: 68271
Data Mining Techniques with R and Azure Batch Services
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Advanced Analysis Techniques
Speaker: Matthew Sharkey
Title: Data Mining Techniques with R and Azure Batch Services
Abstract:
SessionID: 68463
Dynamic SQL: Tables, Pivots, Parameters
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Application Database Development
Speaker: Steven Tidwell
Title: Dynamic SQL: Tables, Pivots, Parameters
Abstract:
SessionID: 66729
Make Power BI Your Own with the Power BI APIs
Event Date: 07-10-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Steve Wake
Title: Make Power BI Your Own with the Power BI APIs
Abstract:
Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.
SessionID: 66742
Transitioning from Integration Services to Azure Data Factory
Event Date: 07-10-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Meagan Longoria
Title: Transitioning from Integration Services to Azure Data Factory
Abstract:
SessionID: 68710
Security Developers Need To Know
Event Date: 07-10-2017 - Session time: 15:45:00 - Track: Application Database Development
Speaker: Rob Kraft
Title: Security Developers Need To Know
Abstract:
In this session I will list the things that developers need to do to minimize the risk that a hacker can gain access to a database. I will discuss each in depth and provide examples of a good code and practices to keep hackers out. The list includes: protecting connection strings, using minimal database permissions, funneling all database code through central logging and injection testing filters, proper use of stored procedures, hashing passwords, and SQL injection prevention. I believe that when developers write a properly architected application, they can be confident that risks of database injection through the application is minimized.
SessionID: 68934
How to Keep Your Databases Secure in Just Minutes a Day
Event Date: 07-10-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Leighton-Dick
Title: How to Keep Your Databases Secure in Just Minutes a Day
Abstract:
You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.