Nr: 303
SQLSaturday #303 - Rochester 2014
SessionID: 11515
Ten T-SQL Techniques with Tally Tables
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Chris Hyde
Title: Ten T-SQL Techniques with Tally Tables
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 11779
SQL Audit - auditing doesn't have to be boring
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Colleen Morrow
Title: SQL Audit - auditing doesn't have to be boring
Abstract:
Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.
SessionID: 12514
Easy SQL Server Benchmarking
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: David Klee
Title: Easy SQL Server Benchmarking
Abstract:
SessionID: 12517
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: David Klee
Abstract:
SessionID: 12887
SSIS Optimization techniques
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Daniel Bowlin
Title: SSIS Optimization techniques
Abstract:
SessionID: 12888
SSIS 2012 Parameters, deployments, and environments
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Daniel Bowlin
Title: SSIS 2012 Parameters, deployments, and environments
Abstract:
SSIS 2012 brings some paradigm shifting concepts to the table. Configurations are being deprecated in favor of Parameters, the Project deployment model vs. the package deployment model, and the addition of environments. This sessions will go hands on to review upgrading some packages, working in parameters and dropping your configurations, work through some of the advantages of the Project deployment model, and round it out with a discussion on Environments to help control the behavior of your packages.
SessionID: 13654
T-SQL Basics
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Carlton Ramsey
Title: T-SQL Basics
Abstract:
In this session we will go over T-SQL Basics. We will review SELECT, INSERT, UPDATES and DELETE statements. Discuss how to retrieve data from multiple tables. Work with group by and a few other advance T-SQL techniques to retrieve data from your database.
SessionID: 13846
Dynamic SQL: Writing Efficient Queries on the Fly
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 1
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: 13847
Diving Into Query Execution Plans
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Edward Pollack
Title: Diving Into Query Execution Plans
Abstract:
SessionID: 14534
SQL Server 2014 New Features
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: George Walters
Title: SQL Server 2014 New Features
Abstract:
SQL Server 2014 will have a number of new features to help with specific situations in OLTP and OLAP queries. In-Memory tables and queries, SSD Buffer Pool, Columnstore Indexing, and AlwaysOn Improvements will be covered
SessionID: 14537
SQL Server 2012 Failover Clustering
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: George Walters
Title: SQL Server 2012 Failover Clustering
Abstract:
SQL Server 2012 has significant improvements in Failover Clustering Instances. This will review shared-disk instance clustering and illustrate the new features.
SessionID: 18072
Inspector Insert And The Case Of The Mistaken IDENTITY
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Kendal Van Dyke
Title: Inspector Insert And The Case Of The Mistaken IDENTITY
Abstract:
Think you know everything about working with identity values? Think again - they're not as straightforward as they seem! Follow along as Inspector Insert discovers the many ways to end up with a case of mistaken identity and learn how to make sure you're working with the right identity values every time. Attendees will: - Understand how identity columns work - Understand all the ways to return identity values and what factors influence their accuracy. - Learn how to always be sure they're working with the right identity values in TSQL.
SessionID: 18073
How To Build A SQL Server Virtual Lab On Your Own Machine
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Kendal Van Dyke
Title: How To Build A SQL Server Virtual Lab On Your Own Machine
Abstract:
As the number of SQL Server versions and features grow over time so does the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up an AlwaysOn Availability Group? Or maybe you want to try out the latest features in SQL 2014...virtualization offers a convenient way to do any and all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual lab on your own machine.
SessionID: 20654
Trace Flags for Developers
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Mike Hays
Title: Trace Flags for Developers
Abstract:
Will Trace Flags help troubleshoot or optimize your your queries? This is an introduction on the how why Trace Flags alters the way SQL Server behaves. Understand the difference between documented and undocumented trace flags. Learn how Trace Flags can be enabled as a hint for individual queries. Also review a couple trace flags that may help with those day to day puzzles.
SessionID: 20655
Recovery that May or May Not have a Wizard
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hays
Title: Recovery that May or May Not have a Wizard
Abstract:
The wizards that come with SQL Server help us accomplish many things including recovering the database; however, we can not use the wizards for all our data recovery issues. In this session we'll review recovery topics of page corruption, temporary storage loss, master database recovery, and other data recovery scenarios. We'll also determine which of these scenarios can be resolved with a wizard.
SessionID: 21142
101 Stupid Things Your Colleagues Do When Setting Up SQL Server
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Matt Slocum
Title: 101 Stupid Things Your Colleagues Do When Setting Up SQL Server
Abstract:
SessionID: 28118
Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: William E Pearson III
Title: Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models, developed by business users, to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect, SSAS Maestro and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.
SessionID: 28119
Bridging the Chasm: BI Theory vs. Practice
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: William E Pearson III
Title: Bridging the Chasm: BI Theory vs. Practice
Abstract:
A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
SessionID: 9596
Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Tabisz
Title: Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Abstract:
Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps.
In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.
SessionID: 9633
The Modern Data Warehouse
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Andy Roberts
Title: The Modern Data Warehouse
Abstract:
SessionID: 9634
What the Hek is under the covers?
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Roberts
Title: What the Hek is under the covers?
Abstract:
SQL Server Hekaton completely changes the way that we process data in the SQL Server Engine. This talk will focus on the SQL Server in-memory data structures and how memory optimized and traditional structures can be used in the same application.
SessionID: 9974
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
SessionID: 9975
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 21-06-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Allen White
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract:
You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.