Nr: 271
SQLSaturday #271 - Albuquerque 2014
SessionID: 10442
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bill Fellows
Title: Kama Sutra of SSIS: A guide to loving ETL
Abstract:
Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
SessionID: 10443
2012 TSQL Sweets
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bill Fellows
Title: 2012 TSQL Sweets
Abstract:
The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
SessionID: 11486
Interview Tips
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Chris Shaw
Title: Interview Tips
Abstract:
Have you been asked for an interview for that perfect job? The job that you
would love to have on a team that you really want to be a part of? It is
time to sharpen those interview skills. Every interview is different. During
this session we will talk about my observations from many interviews that I
have been a part of. There are many examples in this session on how not to
present yourself, during an interview. We may laugh at some of the
observations, but there are many lessons to learn. Get an inside look at how
hiring managers make decisions, and make sure you know what to look for as
the candidate. Have you been tasked with conducting an interview? We will
complete the session with some tips on how to make sure that you get the
information you need to make a good decision.
SessionID: 14121
"What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database"
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Gabriel Villa
Title: "What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database"
Abstract:
So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.
SessionID: 14656
Power BI – Cloud Self-Service BI
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Ginger Grant
Title: Power BI – Cloud Self-Service BI
Abstract:
Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
SessionID: 15825
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16879
Getting Started with Execution Plans
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Jason Kassay
Title: Getting Started with Execution Plans
Abstract:
You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points
SessionID: 18982
SQL Server Statistics – What Are The Chances?
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Lori Edwards
Title: SQL Server Statistics – What Are The Chances?
Abstract:
When I was getting started with SQL Server, I struggled with poorly performing queries. I’d spend a lot of time trying to tune the code, but didn’t always make good progress. Soon, I learned that query performance isn’t just the way the SQL is written, it’s also how the indexes are designed and the statistics collected by those indexes. Even then, for far too long, I thought that statistics only contained information on table row counts. But I found out there’s a lot more to statistics than just row counts. In this beginner session, we'll touch on how statistics are created, the different types of statistics, how they’re maintained, and how the Query Optimizer uses them. We will also touch on finding out additional information about your statistics. We’ll use plenty of examples and demos to make it all clear. At the end of this session, you should have a better idea of how SQL Server makes decisions on how to gather data, so that you can write queries that perform better.
SessionID: 19140
Windows Azure SQL Reporting Services
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Leslie Weed
Title: Windows Azure SQL Reporting Services
Abstract:
What you need to know about Reporting Services in the Cloud. We will cover benefits, limitations and scenarios that you may or may not have thought about for implementing this into your enviornment or for simply taking advantage of the free trial period.
SessionID: 19202
The Accidental Report Designer: Data Visualization Best Practices in SSRS
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Meagan Longoria
Title: The Accidental Report Designer: Data Visualization Best Practices in SSRS
Abstract:
SessionID: 19423
Data Visualizations: It’s not all colorful lines o
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Marc Beacom
Title: Data Visualizations: It’s not all colorful lines o
Abstract:
Visualizing data can be an important key to understanding a large amount of data. However, there is more than just colors and graphs. There are several considerations that should go into visualizing data so that your users can understand the story of the data.
SessionID: 19930
Master of All I Survey - track code changes and more across your environment
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Michael Bourgon
Title: Master of All I Survey - track code changes and more across your environment
Abstract:
Almost everyone's seen it happen - problems due changes made on servers, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it's built into SQL Server standard edition from 2005-2014, and it's easy to implement. Come learn what Event Notification is and why you'll want it in your environment.
SessionID: 22766
SQL Server AlwaysOn Availably Groups
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Reeves Smith
Title: SQL Server AlwaysOn Availably Groups
Abstract:
With SQL Server 2012 comes and new high availability and shared nothing feature. Understand what AlwaysOn Availability Groups are and how they can help your high availability, disaster recovery, and reporting needs with this new addition.
This session will demo a high availability environment with failovers with some of the current business intelligence features.
SessionID: 22874
Battle of the Finch Bots
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Jeff Renz
Title: Battle of the Finch Bots
Abstract:
SessionID: 23583
XPath - XQuery; I guess if I HAVE to
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Russ Thomas
Title: XPath - XQuery; I guess if I HAVE to
Abstract:
I don't know anyone who likes it. But the reality is sooner or later you'll have to use XML in your database career. It appears in extended events, ring buffer queries, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and unstructured data in administering and developing databases.
SessionID: 24506
The Encryption Primer
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Steve Jones
Title: The Encryption Primer
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
SessionID: 24872
Building a Scalable Cost Effective Reporting System
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Pat Wright
Title: Building a Scalable Cost Effective Reporting System
Abstract:
SessionID: 25675
Master the Date Dimension Like a Time Lord
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Steve Wake
Title: Master the Date Dimension Like a Time Lord
Abstract:
SessionID: 25933
Extended Events In Real Life
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Seth Washeck
Title: Extended Events In Real Life
Abstract:
Extended Events, introduced in SQL Server 2008 are here to stay. When combined with the fact that Profiler for Trace is a deprecated feature we're going to need to learn how to use Extended Events to monitor our server. In this session we're going to step through some real-world uses of Extended Events including diving into the backup process (on single and multi-stripe backups), Availability Group event monitoring, and insight into the DBCC CHECKDB process (NEW IN SQL 2014)!
SessionID: 26607
Scripting in SSIS
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Tim Mitchell
Title: Scripting in SSIS
Abstract:
In this session, we will explore both the Script Task and Script Component tools within SSIS. We will discuss the reasons why one might need to include scripting as part of an ETL strategy, as well as examining some use cases where scripting is a good fit. We will follow up with several demonstrations of how to solve specific ETL challenges using the Script Task and Script Component in SSIS.
SessionID: 26960
The Life Cycle of a Query
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine and will dramatically show The Life Cycle of a Query. We will follow a query from beginning to end and "flythrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
SessionID: 28102
Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 2
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: 34793
The Hierarchy of Monitoring Needs: A Methodology
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Fal
Title: The Hierarchy of Monitoring Needs: A Methodology
Abstract:
When it comes to the servers in your environment, do you feel alone, afraid, and in the dark ? If we want to know if our servers are healthy, where do we start? It's very easy to feel lost or overwhelmed when you have hundreds, if not thousands, of metrics you can monitor in SQL Server. The Hierarchy of Monitoring Needs provides a clear roadmap for designing your monitoring strategy. This session will review monitoring from a high level, helping you develop a plan from the ground up by addressing critical metrics, business needs, and your overall strategic goals.
SessionID: 34849
SQL Server Databaseology 201
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: John Morehouse
Title: SQL Server Databaseology 201
Abstract:
Did you take apart your Mom's toaster or your Dad's alarm clock just to see how it worked? Ever wonder how that database you built or support works behind the scenes at a cellular level? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures down to the very records themselves. This session will explore some of those deep inner workings of a SQL Server databases. The attendee will walk away with a better understanding of how SQL Server databases work which would allow them to build better and faster databases.
SessionID: 9840
Converting Unreliable Deployments Into Consistent Releases
Event Date: 25-01-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Thomas Norman
Title: Converting Unreliable Deployments Into Consistent Releases
Abstract:
The deployment process is frustrating; an object is missing, an object is
deployed in the wrong order or the incorrect version. Each database is
made up of a lot of objects in different environments. When you create an
object like a table or stored procedure, you need to get this object deployed
into each environment. Together we will discover how to separate each
object for proper order deployment while releasing only objects which have
changed. Deployments can cause you trouble but we will provide a reliable
deployment and version control process.