Nr: 238
SQLSaturday #238 - Minnesota 2013
SessionID: 12368
T-SQL: Simple Changes That Go a Long Way
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: David Valentine
Title: T-SQL: Simple Changes That Go a Long Way
Abstract:
Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance of your queries. Learn about indexing techniques and reading execution plans to see if the optimizer is using the index. Performance isn't everything though. There are small things you can do to make your TSQL more maintainable too. We will dive into a few TSQL tricks with Common Table Expressions, Table-Valued Parameters, and COALESCE.
SessionID: 12380
Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: David Bermingham
Title: Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Abstract:
SessionID: 13666
Service Broker: The Queue Continuum
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Ed Leighton-Dick
Title: Service Broker: The Queue Continuum
Abstract:
Pop quiz: How can SQL Server help developers build scalable, distributed, and asynchronous applications? Service Broker is the answer! In this presentation, I'll show you what it is; talk about when and why you might want to use it in your applications; walk through an example of how to set it up; and share a few lessons learned from our successful implementations.
SessionID: 13887
Unit Testing Fundamentals
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Eric Selje
Title: Unit Testing Fundamentals
Abstract:
How can you be certain the "little change" you're about to make to that stored procedure isn't going to take down your whole company? "Real" developers use a technique called "Unit Testing" to minimize that risk, a concept that's also available to you. With unit testing you can quickly ascertain whether the the changes to functions, stored procedures, and even other objects in your database had a negative unforeseen impact.
In this session we'll walk through the basics of what unit testing is, how to set up a simple Unit Testing project in SSMS, how we can tell whether something has negatively changed in our functions or procedures. We'll then introduce the tSQLt framework to run our test suite as well as SQL Test from RedGate.
SessionID: 13912
Data Mining Deep Dive: Clustering
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-210
Speaker: Eric Ness
Title: Data Mining Deep Dive: Clustering
Abstract:
Microsoft SQL Server makes it simple to apply data mining algorithms to a wide variety of data. Applying the results to business decisions without a thorough understanding of how the algorithms work is dangerous to the bottom line of the business, though. This session will take one of the algorithms, the Microsoft Clustering Algorithm, and do a deep dive into the mechanics of how it works. The algorithm is valuable for analyzing data in the fields of marketing, social networks and many others. The session will also examine the types of data that are valid for clustering. A demonstration of building a clustering model using SQL Server Analysis Services and viewing the model using the Excel Data Mining Add-In will be given.
SessionID: 13914
Table Partitions for Archiving
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Eric Zierdt
Title: Table Partitions for Archiving
Abstract:
What is Table Partitioning? How can it be used to move large amounts of data quickly? How can it be used with a data archiving strategy to quickly and easily drop archived data from a table? We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you.
SessionID: 14641
You're THE DBA. Now What?
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Gill Rowley
Title: You're THE DBA. Now What?
Abstract:
Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
SessionID: 14810
Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View Maps
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Greg Beaumont
Title: Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View Maps
Abstract:
Business Intelligence has now been a global discipline for several years, and with new Microsoft tools you can now bring the globe to Business Intelligence. Microsoft Data Explorer for Excel 2013 enables you to access, harness, transform, and mash-up data like never before. Data that is separated by source type, format, location and more will be reviewed and mashed up in Data Explorer. GeoFlow is a new geospatial Business Intelligence tool which literally adds another dimension to data visualization. The power of GeoFlow to transform inanimate data into a story will be demonstrated. Power View for Excel 2013 has the capability to recognize geospatial data and create reports that integrate with Bing Maps, enabling global data BI report development from a desktop computer. The ease of use, intuitive design, and value of maps with Power View 2013 will be reviewed with some interesting examples leveraging publically available data. Take your data global…literally.
SessionID: 15470
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Ira Warren
Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own
Abstract:
Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census" has written a series of white papers on record linkage and particular a technique called "Blocking Indexs". In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of "real world" examples(Code) and you will leave a master of record linkage and the concepts behind it
SessionID: 15552
PowerShell and SQLPSX the Dynamic Duo for the DBA
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Jim Dorame
Title: PowerShell and SQLPSX the Dynamic Duo for the DBA
Abstract:
With PowerShell and SQLPSX your DBA life can be a lot simpler.
SMO is powerful, but can be difficult to use. Enter SQLPSX.
Chad Miller put together a set of PowerShell functions that
streamline the use of SMO, easing management of a multi-server
environment. Come learn when and how the addition of
PowerShell and SQLPSX can benefit you.
SessionID: 15824
Dimension Modeling Design Patterns: Beyond Basics
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Jason Horner
Title: Dimension 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: 15958
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Jason Strate
Abstract:
SessionID: 16369
When Scripting Worlds Collide: PHP + SQL Server
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Jeff Prom
Title: When Scripting Worlds Collide: PHP + SQL Server
Abstract:
SessionID: 16825
T-SQL: How to create a million sample people
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Jim Horn
Title: T-SQL: How to create a million sample people
Abstract:
This session is a demo how you can create T-SQL code to create a table with a million rows of sample people with addresses, phone number, date of birth, and other demographic columns. Useful for creating realistic-looking data for a project that doesn't have any, or de-identifying existing data for development and testing purposes.
( Note: An article on this session has been published at http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_12174-SQL-Server-T-SQL-recipe-to-create-a-million-sample-people.html )
SessionID: 18384
Implement a Dynamic Table Partitioning Solution
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Kirby Richter
Title: Implement a Dynamic Table Partitioning Solution
Abstract:
Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.
SessionID: 18953
Big Data in the Cloud with HDInsight
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Lara Rubbelke
Title: Big Data in the Cloud with HDInsight
Abstract:
Learn the patterns for using Azure for Big Data workloads. Learn how to create a cluster, load a cluster, and develop approaches for analysis to use the data. This session will draw on customer implementations, sharing the questions asked and problems solved by taking various implementation approaches.
SessionID: 18958
Yesterday I Couldn’t Even Spell ‘DBA’.
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Larry Toothman
Title: Yesterday I Couldn’t Even Spell ‘DBA’.
Abstract:
Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator. Once the initial shock passes they realize that they need help. The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help.
SessionID: 19633
DANGER: The Art and Science of Presenting
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Mark Vaillancourt
Title: DANGER: The Art and Science of Presenting
Abstract:
Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
SessionID: 19634
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Mark Vaillancourt
Abstract:
SessionID: 20061
Shoveling Frogs into a Wheelbarrow
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Merrill Aldrich
Title: Shoveling Frogs into a Wheelbarrow
Abstract:
If you face managing over a hundred, or perhaps thousands, of databases, automation, standards and a "policy-based" mindset are critical. In this session we'll do a walk-through of a rules-based backup and index maintenance solution suitable for zillions of smaller databases, and talk at a high level about features and techniques for multi-server management including monitoring, performance data collection, jobs automation, PowerShell and PBM.
SessionID: 20062
Eureka! Visual deep dive into storage internals
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Merrill Aldrich
Title: Eureka! Visual deep dive into storage internals
Abstract:
Sometimes half the battle in computing is just to see what's happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!
SessionID: 20843
The care and feeding of your adolescent SQL Server.
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Mark Knutson
Title: The care and feeding of your adolescent SQL Server.
Abstract:
Many organizations bring SQL Server into their environment and evolve in their use of it in a similar manner. They may start with extensive use of Microsoft Access and Excel data stores and bring in SQL Server to address the limitations of these products. They may bring in SQL Server to support a departmental application development initiative, or to start a BI project. A developer or server administrator may be pressed into service as a DBA, and as the project or use of the server increases, an improvisational approach to managing the server starts to get cumbersome.
At this stage in the organization’s use of SQL Server, there are a few simple things that can prepare the server for its increasing role in the organization:
SessionID: 21365
SQL Server 2012 Memory Management
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Neil Hambly
Title: SQL Server 2012 Memory Management
Abstract:
SQL Server 2012 brings a wide range of changes from its previous versions - one key change is the way SQL Server memory is managed. With releases prior to SQL Server 2012, there were 2 memory managers, these have been merged into 1 with the latest version, and that’s just the start of the changes for SQL Server memory.
This session will dive into questions related to memory primarily for SQL Server 2012.
SessionID: 21368
Why are we Waiting..
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Neil Hambly
Title: Why are we Waiting..
Abstract:
An in-depth session examining "Waits" happening in your SQL Servers, using the well-known "Waits Queues" methodology.
With particular focus in the session on understanding and interpreting the information found the (DMV) sys.dm_os_wait_stats,
Taking note of which “Waits “with the highest counts or excessive wait times, as well as those which “Waits” can be safely ignored,
We can discover those "performance hurdles" and ways to overcome or remove them, restoring your SQL Servers performance levels.
By using established methodologies like “Waits Queues”, we can systematically identify and remove performance
Previous Presented @ SQLBits 8 9 in UK @ SQLPASS Summit 2011 (310 Attendees) SQLDay
And @ several UK User Groups
SessionID: 21821
Hadoop on Windows
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Paul Codding
Title: Hadoop on Windows
Abstract:
SessionID: 21944
Big Data Analytics with PowerPivot and Power View
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-210
Speaker: Peter Myers
Title: Big Data Analytics with PowerPivot and Power View
Abstract:
This presentation will introduce big data analytics for the business analyst with PowerPivot and Power View. It will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in Excel 2013.
Demonstrations will include creating a big data solution by using HDInsight Server; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with local data; and, analyzing the PowerPivot model data by using Power View.
SessionID: 21946
Mastering the CUBE Functions in Excel 2013
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-210
Speaker: Peter Myers
Title: Mastering the CUBE Functions in Excel 2013
Abstract:
This session explores the seven CUBE functions that are natively available in Excel 2013. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.
The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.
This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is also applicable to Excel 2007 and Excel 2010.
SessionID: 22387
Database Snapshots - Making Your Job Easier
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Paul Timmerman
Title: Database Snapshots - Making Your Job Easier
Abstract:
Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
SessionID: 22992
Temporary Objects Without Permanent Consequences
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Rick Krueger
Title: Temporary Objects Without Permanent Consequences
Abstract:
SessionID: 23465
Self-Service Roles and Responsibilities
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Ross McNeely
Title: Self-Service Roles and Responsibilities
Abstract:
SessionID: 23663
Introduction to BIML and BIMLScript
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Russel Loski
Title: Introduction to BIML and BIMLScript
Abstract:
SessionID: 23666
SSRS data driven subscription using SSIS
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-210
Speaker: Russel Loski
Title: SSRS data driven subscription using SSIS
Abstract:
SessionID: 25776
Power to the User: a look at Power BI
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Steve Hughes
Title: Power to the User: a look at Power BI
Abstract:
Microsoft has put their user facing BI products into the Power BI suite. In this whirlwind session we will work through a solution that uses much of that power. We will be using Power Pivot, Power Query, and Power View in Excel 2013 to show how any user or techie can take advantage of BI on the desktop.
SessionID: 25777
Beyond Power Pivot - Building Tabular Model Solutions
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Steve Hughes
Title: Beyond Power Pivot - Building Tabular Model Solutions
Abstract:
So you have built this awesome Power Pivot model and deployed it SharePoint. Now you need additional security or better processing strategies. What do you do? Migrate the model to a SQL Server Analysis Services Tabular Model. In this session, we will explore those features that make the Tabular model more robust than a Power Pivot model. We will walk through migrating and updating a solution to take advantage of security, partitioning, and other Tabular model capabilities.
SessionID: 26030
Agile Data Warehouse - The final frontier
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Terry Bunio
Title: Agile Data Warehouse - The final frontier
Abstract:
SessionID: 26546
Back(up) to Basics
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Ben Thul
Title: Back(up) to Basics
Abstract:
Are your databases being backed up? Are you sure? Are you sure they're being backed up correctly? Maybe you're an "accidental DBA" or a developer who's not quite sure of the answers to those questions. In this session, you'll learn what the different types of basic backups are, how to execute them, and (perhaps most importantly) how to restore from them if and when necessary.
SessionID: 26579
Data Migration Between SQL Servers
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Tim Plas
Title: Data Migration Between SQL Servers
Abstract:
Data must often be relocated to a different SQL server, when consolidating or upgrading servers or databases. This session details experiences from numerous such moves, using a number of different techniques. We talk about why you might do such a thing, which approaches are available (with what trade-offs), and some of the things that sometimes get forgotten. And especially, how to handle SQL-based apps for a move.
SessionID: 27062
Subqueries for Superheroes
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Tracy McKibben
Title: Subqueries for Superheroes
Abstract:
Strictly for beginners, this session explores the lowly subquery, sidekick of the T-SQL world. Learn the different types of subqueries, how they can help you, and how they can hurt you.
SessionID: 28196
They Say We Shouldn't, But Let’s Do It Anyway – Ad
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Keller 3-210
Speaker: William Weber
Title: They Say We Shouldn't, But Let’s Do It Anyway – Ad
Abstract:
You know all of those things that people say you shouldn't do with Tabular models; many-to-many relationships, parent-child hierarchies, actions, etc? Let’s do those! In this session we’ll work through a few scenarios to implement some of the more advanced SSAS Tabular techniques. Not only those things that we often hear we shouldn't do (though there’s often a business case to do them), but also those advanced aspects of Tabular models and the DAX language like dynamical security, using inactive relationships and implementing a direct query model that aren't as frequently implemented. Come join me to try out all of the things we shouldn't.
SessionID: 9684
Data cleansing life cycle with Data Quality Services in SQL 2012
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Anton Rozenson
Title: Data cleansing life cycle with Data Quality Services in SQL 2012
Abstract:
Do you have dirty data? Most likely yes... This session will take us on the adventure of designing data cleansing solution and implementing it with Data Quality Services and SSIS. We will walk through creation of Knowledge Bases, Domains and Rules. You will learn how to Conform and De-duplicate text data and Enrich it with information from Windows Azure Data Market.