Nr: 249
SQLSaturday #249 - San Diego 2013
SessionID: 10324
Dive into the Query Optimizer-Undocumented Insight
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Benjamin Nevarez
Title: Dive into the Query Optimizer-Undocumented Insight
Abstract:
SessionID: 10325
Defeating the Limitations of the Query Optimizer
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Benjamin Nevarez
Title: Defeating the Limitations of the Query Optimizer
Abstract:
SessionID: 10750
Windows Azure SQL Server - Better Together
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Bret Stateham
Title: Windows Azure SQL Server - Better Together
Abstract:
SessionID: 12384
Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Bermingham
Title: Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Abstract:
SessionID: 12385
SQL Server 2012 AlwaysOn Step-by-Step
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Bermingham
Title: SQL Server 2012 AlwaysOn Step-by-Step
Abstract:
Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a "hands-on" fashion.
SessionID: 12807
Discover SQL# (SQL CLR library)
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: David Sumlin
Title: Discover SQL# (SQL CLR library)
Abstract:
Quick overview of the SQL# CLR library where we'll examine a few implementations of some of the functions that I've found useful. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 225 procedures and functions, user defined aggregates, and user defined types ... and counting. Come explore some of the interesting problems that SQL# can solve. If you'd like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.
SessionID: 13003
Implementing Auditing in SQL Server 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Dye
Title: Implementing Auditing in SQL Server 2012
Abstract:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
SessionID: 13005
Dealing With Errors in SSIS 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 14737
Best Practices for Database Deployment
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
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 within your environment to ensure that your deployments are as successful as they can be.
SessionID: 14738
Tune Queries By Fixing Bad Parameter Sniffing
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Grant Fritchey
Title: Tune Queries By Fixing Bad Parameter Sniffing
Abstract:
SessionID: 15344
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: SIOS
Abstract:
SessionID: 15466
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Ira Warren
Abstract:
SessionID: 16199
Into the Blue: Extending AlwaysOn Availability Groups
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Joseph D'Antoni
Title: Into the Blue: Extending AlwaysOn Availability Groups
Abstract:
For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
SessionID: 16200
Using PowerView and Hadoop to Unlock Hidden Market
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Joseph D'Antoni
Title: Using PowerView and Hadoop to Unlock Hidden Market
Abstract:
A practical way to derive business value from big data is to microtarget customers, but where do you begin? In this session, we examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. In addition, we demonstrate how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that can be used to connect more effectively with customers.
SessionID: 17497
SSRS – Implementing a Rendering Extension
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Josh Sivey
Title: SSRS – Implementing a Rendering Extension
Abstract:
SessionID: 17498
Unit Testing your SQL Server database with SSDT
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Josh Sivey
Title: Unit Testing your SQL Server database with SSDT
Abstract:
SessionID: 17893
$#*! Your Database Says About Me
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Karen Lopez
Title: $#*! Your Database Says About Me
Abstract:
Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.
SessionID: 17894
10 Things I Hate About Interviewing with You
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Karen Lopez
Title: 10 Things I Hate About Interviewing with You
Abstract:
Join Thomas LaRock and Karen Lopez for valuable interviewing tips from both sides of the desk. Based on Tom's blog posts of 10 Things I Hate About Interviewing You and 10 Things I Hate About Interviewing With You, this session will be packed with valuable insight and tips to help you sail through your next job interview
SessionID: 18089
How to Find Bad Queries, Fast
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Kendra Little
Title: How to Find Bad Queries, Fast
Abstract:
SessionID: 18190
Top 10 Admininistrator Mistakes on SQL Server
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Kline
Title: Top 10 Admininistrator Mistakes on SQL Server
Abstract:
SessionID: 18192
Team Leadership Fundamentals
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Other
Speaker: Kevin Kline
Title: Team Leadership Fundamentals
Abstract:
- What are the fundamental ways that a new leader can build credibility and trust with their team?
- What are the unique ways in which IT people are motivated?
- How can a leader effectively communicate with their IT team using a variety of communication channels?
- How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
SessionID: 19325
AWS for the SQL Server Pro
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Lynn Langit
Title: AWS for the SQL Server Pro
Abstract:
In this talk Lynn will share her real-world experience deploying solutions to the AWS cloud. She will focus on data solutions such as EC2 w/SQL Server, RDS w/SQL Server and more. Her talk will include coverage of NoSQL offerings such as Glacier, S3 and DynamoDB. She will also cover the RedShift and the new Data Pipeline service. Attend this talk to learn which services to use and tips for usage in the real world.
SessionID: 20386
Scalable SSRS Reports Achieved Through the Powerful Tablix
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Mickey Stuewe
Title: Scalable SSRS Reports Achieved Through the Powerful Tablix
Abstract:
Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control. In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.
SessionID: 20387
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Mickey Stuewe
Abstract:
Combining the backend power of enterprise BI stacks with the fluidity and accessibility of self-service BI designs, Pyramid fuses the needs of both business users and IT administrators into a singular solution.
SessionID: 20388
How Flash Storage Modernizes Databases
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Mickey Stuewe
Title: How Flash Storage Modernizes Databases
Abstract:
For decades the characteristics of spinning hard drives have acted as a tail wagging the dog requiring the processes and behaviors of software, architecture and administrators to bend to its requirements. With the advent of a new technology, flash storage, comes the unleashing of a new round of performance potential as well as a shedding of long encumbering patterns. Modernizing databases is about both vastly boosting performance and also significantly reducing the complexity and effort to maintain them. Come see a deep dive into how ultra-fast and random-optimized storage is modernizing database performance, architecture and maintenance.
SessionID: 21054
SQL Server 2012 Licensing Options
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Denny Cherry
Title: SQL Server 2012 Licensing Options
Abstract:
In this session on SQL Server Licensing we will review the various options for purchasing SQL Server 2012, as well as the options available for reducing your overall license costs. Additionally we will look at the options which are available when installing new servers running older versions of Microsoft SQL Server.
SessionID: 21055
SQL Server's In Memory Database Objects
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Denny Cherry
Title: SQL Server's In Memory Database Objects
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
SessionID: 21591
Big Data! What's the Big Deal?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Orion Gebremedhin
Title: Big Data! What's the Big Deal?
Abstract:
For decades humans have been collecting data in ever increasing formats and exponentially increasing volumes. Data collection tools have historically outnumbered data analytics tools, hence leading to a huge backlog of raw data waiting to be analyzed. This backlog has increased dramatically in recent years with the explosion of social media and the advent of a plethora of Internet connected devices. The challenge in clearing the backlog was exacerbated by requirements imposed by various analytics technologies to get data into common formats that would then be pumped into standardized data models. The big data revolution challenges this approach by tapping into various, high velocity and large volume sources to identify correlations and patterns that we could only dream of identifying using traditional analytic technologies. In this presentation I will discuss the history of big data tools and will briefly discuss Microsoft HDInsight,an Apache Hadoop compatible Big Data implementation.
SessionID: 21629
Flash Deployment Strategies in SQL 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Peter Andrews
Title: Flash Deployment Strategies in SQL 2012
Abstract:
This session presents three successful strategies to leverage Flash in your SQL Server environment reduce IO latency to sub Millisecond ranges, and dramatically improve performance and user experience.
SessionID: 21823
Visualization Choices: What, When, and How?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Paul Turley
Title: Visualization Choices: What, When, and How?
Abstract:
SessionID: 21824
Tabular Models: Easier Faster Than Cubes; Really?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Paul Turley
Title: Tabular Models: Easier Faster Than Cubes; Really?
Abstract:
The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.
SessionID: 22113
Up Your Game With OUTPUT
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Phil Helmer
Title: Up Your Game With OUTPUT
Abstract:
There are some classic database programming tasks that rely on answering the question "What did I just change?" Prior to SQL Server 2005, we had to use functions like SCOPE_IDENTITY() and some extra tricks for handling multiple rows. Some people even had to resort to triggers. Yikes!! This session focuses on the practical use cases for the T-SQL OUTPUT clause. More importantly, you will find out how you can ditch the tricks of the past for a simpler solution that will help keep you sane.
SessionID: 23161
Designing for Analysis: Facts and Dimensions
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Robert Hatton
Title: Designing for Analysis: Facts and Dimensions
Abstract:
SessionID: 24512
Branding Yourself for a Dream Job
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Other
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24513
The Encryption Primer
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
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: 24659
Taking BI to the Next Level: Collaboration
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Stacia Varga
Title: Taking BI to the Next Level: Collaboration
Abstract:
SessionID: 24660
Dashboard Do's and Don'ts
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Stacia Varga
Title: Dashboard Do's and Don'ts
Abstract:
SessionID: 24856
Stop That!
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: David Moutray
Title: Stop That!
Abstract:
Ten programming mistakes that Database Administrators wish Database Developers would stop making, why they make them, and what to do instead.
SessionID: 24857
How to Be a Better SQL Database Developer
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: David Moutray
Title: How to Be a Better SQL Database Developer
Abstract:
SessionID: 24945
Data Vault – What is it? Where Does It Fit?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Phil Robinson
Title: Data Vault – What is it? Where Does It Fit?
Abstract:
As a Data Warehouse / ETL developer who sometimes waits weeks or months without capturing or loading any source data while a new data warehouse / mart target model is being defined, would you instead like to be able get ahead of the curve by – quickly and mostly automatically – designing and even loading a robust and fully history-tracking DW / staging repository? Or, have the recent requests from sponsors – requests that your DW reporting / analytics solution also supply data for upcoming Master Data Management needs – got you a little nervous about your data transformations? If either of these scenarios resonate, you will appreciate Data Vault, an emerging DW design and architecture. Leaving this session, you will be familiar with Data Vault’s simple design fundamentals, appreciate its potential for task automation, and understand where and when it fits your needs.
SessionID: 25141
Database Design: Size DOES Matter
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Performance
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25996
45 min to build your first SSRS report
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
SessionID: 26207
Windowing Functions: THE Reason to Upgrade to 2012
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Kevin Boles
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract:
SessionID: 26208
Common TSQL Mistakes
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26210
SQL Injection
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 26901
Database Monitoring : Trying To Keep Sane
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: TJay Belt
Title: Database Monitoring : Trying To Keep Sane
Abstract:
Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish.
We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.
SessionID: 26902
Documentation – you know you love it
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: TJay Belt
Title: Documentation – you know you love it
Abstract:
SessionID: 27456
Data Flow Architectures in Software Development Life-Cycle
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Virginia Mushkatbat
Title: Data Flow Architectures in Software Development Life-Cycle
Abstract:
The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach
SessionID: 8840
SQL Server Database Development with SSDT
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Aaron Nelson
Title: SQL Server Database Development with SSDT
Abstract:
Most importantly we’ll show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we will also highlight and demonstrate the features that have been added to SSDT in the past year.
SessionID: 8841
PowerShell for Data Professionals
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 9078
Manageable SSAS Deployment Strategies
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Kerry Tyler
Title: Manageable SSAS Deployment Strategies
Abstract:
If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
SessionID: 9147
SQL 2012 Programmability Enhancements
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Andrew Karcher
Title: SQL 2012 Programmability Enhancements
Abstract:
With SQL 2012 comes a slew of enhancements on the Programmability side. This session will explore some of those new features such as Analytic Functions, Over Clause (Window Functions), Date Functions, Conversion Functions, Sequence Objects, Paging and FileTables to name just a few. If you want to get a jump on those features you will be seeing in SQL 2012 this is the session for you.
SessionID: 9378
Physical Join Operators
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Ami Levin
Title: Physical Join Operators
Abstract:
SessionID: 9379
Where did I put my (primary) keys?
Event Date: 21-09-2013 - Session time: 00:00:00 - Track: Dev / Design
Speaker: Ami Levin
Title: Where did I put my (primary) keys?
Abstract:
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.