Nr: 293
SQLSaturday #293 - Maine 2014
SessionID: 10225
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track IV
Speaker: Ben Miller
Abstract:
Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you'll be glad you did.
SessionID: 10226
SQL Server TDE
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track III
Speaker: Ben Miller
Title: SQL Server TDE
Abstract:
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy in general as well as how it relates to SQL Server TDE.
SessionID: 10680
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track I
Speaker: Brandon Leach
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
SessionID: 12518
Easy SQL Server Benchmarking
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: David Klee
Title: Easy SQL Server Benchmarking
Abstract:
SessionID: 12520
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track I
Speaker: David Klee
Abstract:
SessionID: 12895
Using Hive to Query and Process Big Data
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track III
Speaker: Dan Clark
Title: Using Hive to Query and Process Big Data
Abstract:
SessionID: 12896
Mastering Date-Time Based Analysis in DAX
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track III
Speaker: Dan Clark
Title: Mastering Date-Time Based Analysis in DAX
Abstract:
This session is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them.
SessionID: 13850
Dynamic SQL: Writing Efficient Queries on the Fly
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track II
Speaker: Edward Pollack
Title: Dynamic SQL: Writing Efficient Queries on the Fly
Abstract:
Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
SessionID: 14775
Statistics and Query Optimization
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track II
Speaker: Grant Fritchey
Title: Statistics and Query Optimization
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
SessionID: 14776
Best Practices for Database Deployment
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track II
Speaker: Grant Fritchey
Title: Best Practices for Database Deployment
Abstract:
The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.
SessionID: 16163
SQL Server--All About HA and DR
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track II
Speaker: Joseph D'Antoni
Title: SQL Server--All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, all of the HA and DR options within SQL Server (even the ones that aren't in Enterprise Edition), and finally a demonstration of the new Availability Groups feature in SQL Server 2012/2104 and see them in practice
SessionID: 16164
Building Perfect SQL Servers, Every Time
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track I
Speaker: Joseph D'Antoni
Title: Building Perfect SQL Servers, Every Time
Abstract:
One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.
SessionID: 16739
What the Hekaton
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track III
Speaker: John Flannery
Title: What the Hekaton
Abstract:
SessionID: 16768
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: Jason Hall
Abstract:
I intend to share the whys and hows of these issues with anyone who would like to attend during a SQL Saturday session.
SessionID: 17003
Basic Database Programming
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: John Miner
Title: Basic Database Programming
Abstract:
Abstract:
You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects.
After this presentation, will be ready to meet that clients need.
Coverage:
1 - How is a view better than ad-hoc SQL?
2 - Abstracting underlying tables via a view.
3 - Avoiding DML updates to views.
4 - Using triggers to enforce business rules.
5 - Using triggers to prevent data modifications.
6 - What are the different types of functions?
7 - Simple use of each type.
8 - Using stored procedures as an application interface.
9 - Batch programming using stored procedures.
10 - How to schedule batch jobs.
SessionID: 20504
From Mess to Mastery: Managing Large Environments
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track I
Speaker: Mike Hillwig
Title: From Mess to Mastery: Managing Large Environments
Abstract:
IT veteran Mike Hillwig will show you how some of the integrated tools within SQL Server can help you manage your environment without spending a ton of money. We'll look at the Central Management Server, Management Data Warehouse, Multi-Server Administration, and Policy Based Management. Mike will also show you his tips for building an Environment Inventory Database, a tool you can use to track your servers, instances, and login credentials.
By leveraging what you already have in SQL Server, you'll certainly be able to do more with less.
SessionID: 21639
DBA to Project Manager in 70 minutes flat
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track IV
Speaker: Paresh Motiwala
Title: DBA to Project Manager in 70 minutes flat
Abstract:
As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.
SessionID: 25424
DAX and the tabular model
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track III
Speaker: Steve Simon
Title: DAX and the tabular model
Abstract:
With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
SessionID: 25879
Develop Impressive Dashboards using SSRS 2014
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track IV
Speaker: Sunil Kadimdiwan
Title: Develop Impressive Dashboards using SSRS 2014
Abstract:
Microsoft Reporting Services 2014 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2014.
SessionID: 27717
Crazy Things That Developers Do
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track II
Speaker: Wayne Sheffield
Title: Crazy Things That Developers Do
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
SessionID: 9160
Squeezing the Most out of Row Page Compression
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track IV
Speaker: Andrew Kelly
Title: Squeezing the Most out of Row Page Compression
Abstract:
SQL Server 2008 brought us the ability to do Row and Page level compression in our databases but even today many people are not taking full advantage of these wonderful features. The most common bottle neck today is physical I/O and SQL Server compression can help with that in most cases. If you are not sure how these features work or how to apply them in your environment this session is for you. We will discuss in detail how the compression schemes work at both the row and page levels along with which data types may or may not be able to participate. We will see from various demos what else affects the compression ratio and just how extensive it can be under the right conditions. Nothing comes for free though so we will also cover the pros and cons along with why, when and most importantly how to use it effectively.
SessionID: 9161
TempDB 101
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track IV
Speaker: Andrew Kelly
Title: TempDB 101
Abstract:
SessionID: 9366
T-SQL Power! SQL Server Windows That Open Doors
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: Adam Machanic
Title: T-SQL Power! SQL Server Windows That Open Doors
Abstract:
Ever feel like your Transact-SQL solution to a tricky issue was almost just as difficult as the problem itself? Ever find yourself unable to cleanly express the logic you really need in T-SQL for your complex data calculation? Don’t blame yourself—blame the limitations of the language. Get ready to embrace the most powerful SQL Server programming enhancement: turbocharged support for windowing functions. If you write analytical queries and you need results fast, attend this session to learn everything you need to know to leverage all the power that windowing functions bring to the table. See examples taken from real-world projects that illustrate how to create running sums, calculate moving averages, look both backward and forward in your set, and achieve many other seemingly complex tasks—all with ease and clarity. The hallmark of a truly great SQL Server feature is the ability to make difficult tasks simple. Windowing functions will have you writing better T-SQL than ever before.
SessionID: 9640
It's not just a pivot on the data...
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: Andy Roberts
Title: It's not just a pivot on the data...
Abstract:
SQL Server 2012 introduced a new index type - the Columnstore index. SQL Server 2014 upped the game with the clustered columnstore index. What are these index types, how do they work and what's really going on in there?
SessionID: 9641
Introducing SQL Server 2014 (Lunch Session Room 102)
Event Date: 28-06-2014 - Session time: 00:00:00 - Track: Track V
Speaker: Andy Roberts
Title: Introducing SQL Server 2014 (Lunch Session Room 102)
Abstract:
It's no joke, on April Fool's day this year, SQL Server 2014 was officially launched! Join Microsoft over lunch for a quick intro to What's new in SQL Server 2014.