SQLSaturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held:
on Oct 03 2015 at Rockhurst University, 1100 Rockhurst Road, Kansas City, Missouri, 64110, United States

https://www.sqlsaturday.com/444/registernow.aspx

http://www.sqlsaturday.com/444/Sessions/Schedule.aspx

Saturday, Oct 3, 2015 Conference Schedule

This Fall, over a thousand remarkable people from around the globe will converge in Kansas City to explore the technologies transforming tomorrow at Compute Midwest.

Get exclusive insights from 16+ visionaries at our conference & learn how they overcame enormous challenges to create breakthrough innovations.... giving you the push you need to go create your own.

When remarkable ideas and remarkable people collide, the possibilities are endless.
Get out of your comfort zone & join us at Compute Midwest

Tickets:
https://www.eventjoy.com/e/compute-midwest-2015-3667897

Tuesday, October 6, 2015

Next up, Monday October 5th UXPAKC Speaker Series:  At Quest Diagnostics in Lenexa for “The Value Race.”  This session explores the fusion of design and venture thinking in large corporate environments and the role we all play while running on the innovation track.  This interactive session will take the audience through the value sprint framework, an experimental process that combines Diana Kander’s All in Startup book, the Scaled Agile Framework, Lean Startup Model, Google Design Sprint and work from the Stanford D School. In the spirit of lean agile, we’ll share what we’ve learned, get your feedback and collaborate on ways to improve how we design value together.See you at 5:45!  Get your tickets here:  

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.
Goals:
#1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored.
#2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface.  Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures
#3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.

http://www.sqlsaturday.com/444

There's a lot of general verbiage and API documentation about Service Broker, but how do you fit the queues, services, contracts, and conversations together to actually make something that will work reliably in production?  In this session you'll follow the architecture, design, implementation, and troubleshooting of a simple but production-tested Service Broker messaging framework and get a battlefield-level view of the pitfalls and the payoffs involved in Service Broker development.

http://www.sqlsaturday.com/444

Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.

http://www.sqlsaturday.com/444

Saturday, October 3, 2015

A deep-dive into what is sure to become a very critical feature of SQL Server 2016. We'll walk through some use-cases for the technology, and discuss why this kind of technology is needed - and how it can make a DBA's life easier - including making some regulatory compliance easier. We'll then walk though a typical implementation scenario live, and walk though a few demos and practical examples.

http://www.sqlsaturday.com/444

Developers today face an onslaught of data storage applications. Various NoSQL offerings promise performance, scalability and easy development on commodity boxes. How does one get these benefits in SQL Server? What does a SQL Server application built today using the newest features and best practices look like? This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.

http://www.sqlsaturday.com/444

This session is designed for you, the experienced SSIS developer who's been hearing about Biml but hasn't taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.

http://www.sqlsaturday.com/444

It's common to start with a small database server; but when activity increases, how do you know when to scale? This session will cover scaling Sql Server from express to enterprise and VM to a scale-out HADR architecture. You'll learn common upgrade and migration techniques along with things to keep in mind when building new environments. We'll start with a stand alone server and work our way up to a large scale out and scale up deployment.

Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.
That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool!
In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events. 
Profiler was a friend of mine, but it is time to embrace the new king!

http://www.sqlsaturday.com/444

Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.


http://www.sqlsaturday.com/444/

Defense in Depth - Minimizing the Risk of SQL Injection

During this session you will be thrust into the role of the DBA hired to fix SQL Server to prevent it from ever getting SQL Injected, or at least minimize the damage that can be done when it does.  From bottom to top this session will cover how services should be configured, how SQL Server should be configured, benefits and risks of SQL Server security configurations, and best practices for app development.  Come learn how to defend your servers from hackers, or how to become a SQL Injection hacker yourself!


http://www.sqlsaturday.com/444/

Wednesday, October 14, 2015