Nr: 408
SQLSaturday #408 - Houston 2015
SessionID: 10789
The Binary Language of Music
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Other
Speaker: Brian Rigsby
Title: The Binary Language of Music
Abstract:
Take a fascinating journey into how our minds work and discover how binary and mathematical patterns found in music can be used to learn the underlying language of music theory and applied to other disciplines.
SessionID: 11636
Giving Feedback: How to Effectively Communicate to your Employees
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Giving Feedback: How to Effectively Communicate to your Employees
Abstract:
SessionID: 12171
Analyze your query plan like a Microsoft Engineer!
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Performance
Speaker: Daniel Janik
Title: Analyze your query plan like a Microsoft Engineer!
Abstract:
SessionID: 19241
Let's Get It Started - SQL Server installation and configuration
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: DBA
Speaker: Lori Edwards
Title: Let's Get It Started - SQL Server installation and configuration
Abstract:
We've all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We'll also talk about unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.
SessionID: 23770
Enforce Best Practices with CMS and Policy Based Management
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: DBA
Speaker: Ryan Adams
Title: Enforce Best Practices with CMS and Policy Based Management
Abstract:
If you manage a large environment then you know how hard it can be to make sure all your SQL Servers adhere to best practice settings and more importantly is making sure they stay that way. I'll show you how to check those settings across all your servers with Central Management Server and how it can help you manage a disperse environment. You will also learn how to leverage the power of Policy Based Management to help you enforce those settings and standards in your enterprise. Best of all you will see how to get alerts sent to you when one of your standard settings is changed.
SessionID: 26536
Getting started with Tabular Analysis Services
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Business Intelligence
Speaker: Thomas LeBlanc
Title: Getting started with Tabular Analysis Services
Abstract:
This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.
SessionID: 26651
Managing Security in SSIS
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Business Intelligence
Speaker: Tim Mitchell
Title: Managing Security in SSIS
Abstract:
In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover:
Properly securing connection passwords in SSIS
Using package protection levels
Restricting access to deployed packages
Using role-based security for SSIS deployment and execution
Using execution proxies
SessionID: 36426
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: DBA
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
SessionID: 11635
Mastering your Resume Interview: Tips to Get Hired
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Mastering your Resume Interview: Tips to Get Hired
Abstract:
Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.
SessionID: 17087
Working With Azure SQL Database
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Cloud
Speaker: John Cook
Title: Working With Azure SQL Database
Abstract:
SessionID: 26148
Self-Service Business Intelligence with Power BI
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Theresa Eller
Title: Self-Service Business Intelligence with Power BI
Abstract:
Microsoft recently introduced the Power BI Designer to empower self-service business intelligence charts, reports, and dashboards—without writing code. This session will begin with the Power BI Designer to build charts from data stored in SQL. Then we will bring those charts into a Power BI dashboard and review the options available there. Finally, we'll examine the underlying technology: Power Query, Power View, and Power Pivot, which are free Excel 2013 add-ons that provide additional capability not yet available through the Power BI Designer.
SessionID: 27407
Understanding and Monitoring Tempdb
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Performance
Speaker: Vicky Harp
Title: Understanding and Monitoring Tempdb
Abstract:
Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.
SessionID: 28189
SQL Server Permissions and Security Principals
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: DBA
Speaker: William Assaf
Title: SQL Server Permissions and Security Principals
Abstract:
A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins.
SessionID: 29909
SQL Microsoft SQL Server for Developers
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Application Development
Speaker: Dane Schilling
Title: SQL Microsoft SQL Server for Developers
Abstract:
Get a brief overview of the many facets of SQL Server from a developer's point of view. From back ups to T-SQL hacks; this session has something for everyone.
SessionID: 36130
Just Enough SSIS Scripting to Be Dangerous
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: David Valentine
Title: Just Enough SSIS Scripting to Be Dangerous
Abstract:
SessionID: 37307
Windows Clustering for the DBA Part 1
Event Date: 13-06-2015 - Session time: 09:45:00 - Track: DBA
Speaker: Ryan Adams
Title: Windows Clustering for the DBA Part 1
Abstract:
You need to implement AlwaysOn Failover Clustering or Availability Groups, but need help with the Windows Clustering part. This session will guide you to success. We'll talk about how to plan your network, DNS, Active Directory, and storage. I'll provide you with a check list you can use to plan your implementation. We'll see how to choose the right quorum model for a robust failover configuration that ensures your database is always available.
SessionID: 10756
Easy, Scalable Data Solutions in SQL Azure
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Cloud
Speaker: Brian Gogle
Title: Easy, Scalable Data Solutions in SQL Azure
Abstract:
For companies looking to achieve data scalability without large capital expenses, SQL Azure provides a flexible, economical alternative to hosting your data on-prem. In this session we will demonstrate how to create a SQL Azure database and how to manage scalability and geo-replication. We will also explore how SQL Server Management Studio allows you to interact with your data on-prem, as well as key differences between SQL Server and SQL Azure. There will also be a demonstration of creating a SQL Azure API using Azure Mobile Services.
SessionID: 17590
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Performance
Speaker: Justin Randall
Abstract:
SessionID: 17747
A DBA's pick of differences between SQL Server and Oracle
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: DBA
Speaker: Jason Wong
Title: A DBA's pick of differences between SQL Server and Oracle
Abstract:
In this session, I want to talk about 5 major differences between SQL Server and Oracle, namely:
- Backup, Restore, Recovery (RMAN vs T-SQL/Powershell)
- Schema (Single vs Multi tenants)
- Alter Index Rebuild (defragmentation)
- AWR, ASH vs DMV/DMF (Performance Trouble-shooting)
- Data Guard Mode vs AO Availability Group Mode (synch, asynch).
I will reference my prior year presentation (SQLSaturday#308) how to automate Backup, Restore, Recover SQL Server, Alter Index for Defragmentation, and monitoring backups and agent jobs by using Powershell/T-SQL.
I will also reference my prior year presentation (HASSUG 11/2012) Trouble-shooting with Active Session History (powershell and T-SQL).
I will show Oracle 12C in Oracle SQL Developer. Target audiences should have SQL Server DBA working knowledge and basic knowledge in Oracle on these topics.
SessionID: 25304
Pivots, Cursors and Temp Tables, Oh Boy!!
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Application Development
Speaker: Steve Allison
Title: Pivots, Cursors and Temp Tables, Oh Boy!!
Abstract:
Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.
SessionID: 26537
Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Business Intelligence
Speaker: Thomas LeBlanc
Title: Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube
Abstract:
New features have been added to the last couple of Excel releases in order to bring the most used desktop reporting application to a full-featured Business Intelligence reporting tool for Multidimensional Cubes. This session will be filled with demonstration of all these new features with slides only as references to more detailed explanations and uses. Pivot Tables will be the main focus of this 75-minute session with visual tools that enhance graphs and dashboards.
You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and spark lines focus attention on what is important to the viewed data set.
SessionID: 26652
Building Bullet-Resistant SSIS Packages
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Business Intelligence
Speaker: Tim Mitchell
Title: Building Bullet-Resistant SSIS Packages
Abstract:
In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
SessionID: 36198
The DBA Career Roadmap
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: Professional Development
Speaker: Jennifer McCown
Title: The DBA Career Roadmap
Abstract:
Nobody has a step-by-step plan for your career. But, you do need to know the general direction you’re heading in; which roads go that way (and which ones dead end); and what might be worth stopping for along the way. For example, working for a small shop might be a dead end career move, or it could be a fantastic shortcut to somewhere you really want to be. Getting that next certification might be a worthy way to spend your time, or it might be running around in circles.
Want to find out how to get to the next great place in your career? Get solid advice from the people who have already been there. If you want to be somewhere in five years, start moving today.
SessionID: 37308
Windows Clustering for the DBA Part 2
Event Date: 13-06-2015 - Session time: 11:00:00 - Track: DBA
Speaker: Ryan Adams
Title: Windows Clustering for the DBA Part 2
Abstract:
In part 1 you learned how to plan your network, DNS, Active Directory, and storage. You know what you need to plan a successful implementation and now it's time to put the plan into action. I'll demonstrate setting up a multi-subnet cluster so you know exactly how to do it when you get back to the office. I'll also show you things like Node Draining, Priority Startup, Cluster Aware Updating, and Dynamic Quorum that ensure your database is always available.
SessionID: 14456
Learn How To Build A Golden Record for Any Subject Over Lunch!
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Business Intelligence
Speaker: Gene Webb
Title: Learn How To Build A Golden Record for Any Subject Over Lunch!
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:
• Create a golden record for any subject area in a matter of minutes
Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 37293
Optimize Your SQL Server 2014 Workloads with Cisco UCS
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Other
Speaker: Bill Shields
Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract:
SessionID: 37314
Crash Course on Flash-Based Storage--SQL Server
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Performance
Speaker: Bert Scalzo
Title: Crash Course on Flash-Based Storage--SQL Server
Abstract:
Technical Details
Flash vs. SSD—Why DBAs should care about the difference
How Flash changes storage architecture designs
How current storage architecture designs compare
Two rather special Flash-based offerings from HGST
SessionID: 37335
What's new in SQL 2016
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: DBA
Speaker: Mark Moore
Title: What's new in SQL 2016
Abstract:
Come and enjoy your lunch while learning about what new and exiting changes are coming in SQL Server 2016.
SessionID: 37767
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Performance
Speaker: James Barnes
Abstract:
SessionID: 37782
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Performance
Speaker: Matt Henderson
Abstract:
Flash storage is the new wave of technology hitting data centers and database design. With any new technology, knowledge is power. Flash storage comes with a new set of pros cons, new economics and changes in architecture that highlight what it has to offer while avoiding the common traps. Before migrating or testing, learn the what's, how's and when's.
SessionID: 37802
Wait Watchers - All Gain No Pain
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Performance
Speaker: Patrick Okeeffe
Title: Wait Watchers - All Gain No Pain
Abstract:
We're all told to watch our weight and to exercise more. Join Dell Software who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided).
In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won't be only be about how to fix that problem query, but we'll also talk about how to improve overall performance for all your users.
SessionID: 37919
Event Date: 13-06-2015 - Session time: 12:30:00 - Track: Performance
Speaker: Umair Khan
Abstract:
SQL Server is a business-critical component for the line-of business applications and regular monitoring is essential in order to maintain optimal operations as well as to perform effective troubleshooting. Creating a performance baseline of the essential Windows Server and SQL Server performance metrics can help you to both track the health of your SQL Server instance as well as enable you to quickly troubleshoot performance problems. This session will cover the important tools that you can you can use to monitor your SQL Server instances, the essential system metrics to monitor and what they mean to your system’s performance.
SessionID: 19958
SQL Server Foreign Keys – De-mystifying the Rest of the Story
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Performance
Speaker: Mike Byrd
Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story
Abstract:
Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.
SessionID: 20787
The Ins and Outs of SQL Indexes
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Performance
Speaker: Mindy Curnutt
Title: The Ins and Outs of SQL Indexes
Abstract:
SessionID: 27408
Care and Feeding of Your System Databases
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DBA
Speaker: Vicky Harp
Title: Care and Feeding of Your System Databases
Abstract:
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
SessionID: 35649
T-SQL: Simple Changes That Go a Long Way
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Application Development
Speaker: David Valentine
Title: T-SQL: Simple Changes That Go a Long Way
Abstract:
SessionID: 36200
Beginning Powershell for DBAs 1.0
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: PowerShell
Speaker: Sean McCown
Title: Beginning Powershell for DBAs 1.0
Abstract:
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
SessionID: 36206
The Global Cloud and I
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Cloud
Speaker: Anthony {Tex} Moreign
Title: The Global Cloud and I
Abstract:
This is a special session with multiple presenters showing how to utilize free-ish/no-charge Cloud Offerings (e.g., storage, apps) – available from around the Globe at this point-in-time Jun 2015. Even though the free-ish/no-charge offerings are steadily disappearing (e.g., Free Google Apps), this session will show content that applies to both personal/family and SMB’s (Small/Medium Businesses). Expect to walk away with goodies (-: as always :-) … and with answers to questions, such as:
– How do I get started with the Global Cloud today?
– Any gotchas to keep in mind?
– After this session, where do I go for more ... in Houston?
PRE-REQUISITE: None other than an interest to utilize the cloud.
NOTE: The 3 presenters, Tex (20+ year technologist), Valentino Zane (budding technologists), are with Hybrid Decisions#174; Corp and are presenting on behalf of the “Houston Cloud Cluster User Group”.
#171;#177;#187;
SessionID: 36359
Writing Your First BimlScript
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: David Stein
Title: Writing Your First BimlScript
Abstract:
SessionID: 36430
Log SQL Server Activity on a Budget
Event Date: 13-06-2015 - Session time: 13:30:00 - Track: DBA
Speaker: Rudy Rodarte
Title: Log SQL Server Activity on a Budget
Abstract:
SessionID: 10391
Flash Disk Alternatives for SQL Server Databases
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Performance
Speaker: Bert Scalzo
Title: Flash Disk Alternatives for SQL Server Databases
Abstract:
Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.
SessionID: 14455
Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Gene Webb
Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner
Abstract:
What is master data management and why should I care about it?
What does the master data services components of SQL Server do for me?
Overview of all features of MDS
How to build out an MDM subject area
How to use MDS for reference data management
How to use MDS for data quality
How to use MDS with a data warehouse to improve data quality
SessionID: 16866
Row Level Security in Azure SQL Databases using Hierarchies
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Cloud
Speaker: Jamey Johnston
Title: Row Level Security in Azure SQL Databases using Hierarchies
Abstract:
This session will show how an organizational asset hierarchy is leveraged together to provide predicate-based Row Level Security on tables in an Azure SQL Database without application changes.
Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating an Azure SQL Database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Excel.
SessionID: 19242
SQL Server Statistics – What Are The Chances?
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Performance
Speaker: Lori Edwards
Title: SQL Server Statistics – What Are The Chances?
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.
SessionID: 23096
Designing a Data Warehouse in SQL Server
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Robert Stewart
Title: Designing a Data Warehouse in SQL Server
Abstract:
This will be an introduction to what a data warehouse is and how to build it using the BI stack tool Integration Services. It will mainly cover how to design a data warehouse, dimension tables and fact tables.
SessionID: 36201
Designing Stored Procedure Solutions
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Application Development
Speaker: Jennifer McCown
Title: Designing Stored Procedure Solutions
Abstract:
Asking the right questions to set yourself up for success
Making the case for stored procedures over ad hoc code and other objects
Pro tips for standardization and cross-version compliance
Reevaluating and expanding on your solution
Limiting inputs to reduce unexpected behaviors and errors
Choosing between alternate solutions
Evaluating for performance
This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
SessionID: 36205
So what does it really take to get to four nines
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: DBA
Speaker: George Govantes
Title: So what does it really take to get to four nines
Abstract:
As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, Translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.
SessionID: 36423
Making the Leap from Developer to DBA
Event Date: 13-06-2015 - Session time: 14:45:00 - Track: Professional Development
Speaker: Amy Herold
Title: Making the Leap from Developer to DBA
Abstract:
You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
SessionID: 15772
SQL Geography DataTypes and Applications
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Application Development
Speaker: Jared Nielsen
Title: SQL Geography DataTypes and Applications
Abstract:
At some point in your SQL life you will be asked to calculate or visualize geospatial data. Microsoft SQL server has unique optimizations and frameworks for handling just this circumstance. Not to be confused with Geometric data (square and linear), Geographic data offers even more complexity as you deal with the curvature of the earth and its radial impact on queries. Jared Nielsen is the Principal of the FUZION Agency and the CTO of Online and Digital for Universal Weather and Aviation and contends with geographic data on a daily basis. FIR Boundary intersection, optimized flight planning, weather map overlay and multi-level airspace computations all involve some very interesting SQL Server geographic manipulations that may be interesting for you to experience if you haven't already. Please join me for an in-depth review with helpful resources to guide you on your way as you incorporate Geospatial data into your own applications.
SessionID: 20789
Tracing and Extended Events - 3 Methods to End the Madness
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: DBA
Speaker: Mindy Curnutt
Title: Tracing and Extended Events - 3 Methods to End the Madness
Abstract:
In this Session, 3 different approaches to using Tracing and Extended Events will be covered.
- The Long Running Query.
- The Thousand Paper Cuts - De-Parameterization Aggregation
- Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server).
With each of these approaches we will go over
Setting up both tradtional Traces and the newer Extended Events to capture the information you need.
How to analyze and make sense of the captured data.
Lots of demos and take-away scripts in this session.
SessionID: 24438
Parameter Sniffing the Good and the Bad
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Performance
Speaker: Lance Tidwell
Title: Parameter Sniffing the Good and the Bad
Abstract:
SessionID: 36078
The Life Cycle of a Query in VR
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Application Development
Speaker: Todd Kleinhans
Title: The Life Cycle of a Query in VR
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 (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and "runthrough" 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. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
SessionID: 36202
Minion Maintenance and Backup Solutions
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: DBA
Speaker: Sean McCown
Title: Minion Maintenance and Backup Solutions
Abstract:
The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable.
In this session I’ll show you the benefits to Minion Reindex and Minion Backup:
• Simple installation and configuration for all shops, large or small
• Single or multi-server installation script
• Table-based configuration eliminates the need for excessive jobs
• Highly customizable options
• Flexible include and exclude options, including the use of regular expressions
• “Statement only” option generates statements without running them
• Extensive logging
• Live insight into the current maintenance operation
Minion Backup also provides a truly superb specialty: dynamic backup tuning.
Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.
SessionID: 36360
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: David Stein
Abstract:
You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we'll discuss how to use BimlScript to accomplish the following:
- Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
- Automatically execute each package multiple times and record the results for analysis.
- Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
SessionID: 36427
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Performance
Speaker: Jim Murphy
Abstract:
SessionID: 36431
SQL Server Reporting Services - Zero to Automated Reports Today!
Event Date: 13-06-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Rudy Rodarte
Title: SQL Server Reporting Services - Zero to Automated Reports Today!
Abstract:
Perhaps you've heard about the power of SQL Server Reporting Services. Or, you have created some basic reports and you're ready to automate delivery. If so, this session is for you. You'll learn how to create your first SSRS report using Business Intelligence Design Studio (BIDS) and deliver reports to the business automatically in under an hour.