Nr: 407
SQLSaturday #407 - Vancouver 2015
SessionID: 11727
Empowering your data sharing architecture
Event Date: 27-06-2015 - Session time: 08:30:00 - Track: Database Administration
Speaker: Clay Jackson
Title: Empowering your data sharing architecture
Abstract:
This session will show attendees how to use database replication to manage the ever-increasing volume of data by using database replication to maintain near real time copies of databases closer to the consumers of that data. We'll discuss the use of database replication to both distribute and consolidate data with no impact to performance or reliability.
SessionID: 35851
Building a Static Data Warehouse Server
Event Date: 27-06-2015 - Session time: 08:30:00 - Track: Data Warehousing
Speaker: Ron Talmage
Title: Building a Static Data Warehouse Server
Abstract:
Sometimes users require underlying data to be static and unchanging. In this session we'll examine steps used to create a static server from a copy of a live data warehouse server, including implementing clustered columnstore on large partitioned tables, simplifying the management of files and filegroups, and reclaiming large amounts of database space.
SessionID: 36706
Event Date: 27-06-2015 - Session time: 08:30:00 - Track: Business Intelligence
Speaker: Nadiia Bogush
Abstract:
Microsoft offers several options for implementing variety of analytical scenarios:
#183; data modeling and feature engineering with PoverPivot, Power Query,
#183; interactive visual analytics with Power View, Power Map, Power BI and
#183; advanced analytics with Sql Server Analysis Data Mining and recently released Azure Machine Learning.
We will give an overview of these tools and represent the power of combining them all to hack different datasets for hidden insights.
We will share lessons learned by our team from Microsoft Big Data Hackathon with Translink public data. We hope that this session will give a boost for Sql Server developers to put all the power of Microsoft BI tools together and implement advanced and flexible analytical solutions for their customers.
SessionID: 36708
Get Control of your Database Development with SQL Server Database Projects
Event Date: 27-06-2015 - Session time: 08:30:00 - Track: Database Development
Speaker: Jacob Appleton
Title: Get Control of your Database Development with SQL Server Database Projects
Abstract:
Is your database development process as mature, automated and repeatable as your other code development processes? Do you have source control, builds, unit tests and automated deployments as part of your database software development lifecycle? Or instead, do you have some change scripts saved somewhere and rely on your DBAs to hit F5 on the correct scripts in the correct database?
The client services IT team at Orbis is coming to the end of an ambitious project to refactor a large legacy codebase. Like many organisations, we had a lot of business logic in our database layer and didn't have much of a software development lifecycle process to keep it under control.
This talk will demonstrate the process we took to implement SQL Server Data Tools Database Projects, how that enabled us to get control of our database development, and how easy it is for you to start getting control of your database development too.
SessionID: 38236
Big Data for the SQL Ninja
Event Date: 27-06-2015 - Session time: 08:30:00 - Track: Big Data
Speaker: Scott Klein
Title: Big Data for the SQL Ninja
Abstract:
SessionID: 35717
Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit
Event Date: 27-06-2015 - Session time: 09:45:00 - Track: Data Warehousing
Speaker: J May
Title: Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit
Abstract:
Columnstore indexes were introduced in SQL Server 2012 have been wholly re-architected optimized in SQL Server 2014.#160; Columnstore indexes are optimized for data warehouse workloads are a hybrid technology leveraging the best of off-disk in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at sub-second response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, big wins at customer sites inside MSIT. The presentation is rich in demos.#160;Learn whether columnstore can change your users' world why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit why columnstore manifests my motto, “Change the world or go home!”
SessionID: 36541
Continuous Integration for Databases
Event Date: 27-06-2015 - Session time: 09:45:00 - Track: Database Administration
Speaker: Steve Jones
Title: Continuous Integration for Databases
Abstract:
SessionID: 36707
Optimizing desktop Power Pivot models using Power Query
Event Date: 27-06-2015 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Ken Puls
Title: Optimizing desktop Power Pivot models using Power Query
Abstract:
You know the scene; you’ve built a beautiful Power Pivot model that has solved all of your organization’s problems. You open it up, click Refresh and wait patiently for all the data to stream in. That’s okay, there’s a lot of data and you expect that. Then you click a slicer and… wait…
Time during the initial data load is one thing, but consumer’s patience during use is another. Their tolerance for latency is much less.
In this session we’ll explore the things you can do to increase your Power Pivot model performance. We’ll look at the key factors that affect performance, as well as the things you can do to deal with them. In addition, we’ll look at how sourcing your data with Power Query can give you ultimate control over your data’s size and shape, and tricks to optimize it for Power Pivot consumption.
SessionID: 36846
Event Date: 27-06-2015 - Session time: 09:45:00 - Track: Database Administration
Speaker: Argenis Fernandez
Abstract:
SessionID: 38216
10 Handy Tips On SQL Server Dates
Event Date: 27-06-2015 - Session time: 09:45:00 - Track: Database Development
Speaker: Julie Koesmarno
Title: 10 Handy Tips On SQL Server Dates
Abstract:
With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE!
SessionID: 11461
SQL Server Mythconceptions and Mythteries
Event Date: 27-06-2015 - Session time: 11:00:00 - Track: Database Administration
Speaker: Robert Davis
Title: SQL Server Mythconceptions and Mythteries
Abstract:
There are a lot of misconceptions and mysteries in SQL Server due in large part to there be no single right answer for just about any question you have. How many times have you heard, ‘It Depends’ as the answer to a complex SQL Server question? So often that it has almost become a joke. When it’s your SQL Server, it’s no joke.
Why won't that query go parallel? Why won't the optimizer use that index? Why did rebuilding that index improve performance 10 times over?
Sometimes misconceptions become accepted as fact, and they spread. Occasionally, these mistold tales come from very reliable sources. It can be extremely difficult to tell what is fact and what is fable.
In this session, we will explore some of these misconceptions and mysteries turned myths and bust out the truth. We will prove the right answer and free you from these myths that have taken on a life of their own.
SessionID: 19995
TSQL Bullet-Dodging and Spoon-bending
Event Date: 27-06-2015 - Session time: 11:00:00 - Track: Database Development
Speaker: Michael DeFehr
Title: TSQL Bullet-Dodging and Spoon-bending
Abstract:
Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won't have to. Learn some of the newer language elements in SQL server: Recursive CTE's, Composable DML, the MERGE statement, Row numbering and table-valued parameters. This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.
SessionID: 21873
Power BI Hands-On Micro-Workshop
Event Date: 27-06-2015 - Session time: 11:00:00 - Track: Business Intelligence
Speaker: Paul Turley
Title: Power BI Hands-On Micro-Workshop
Abstract:
Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013
Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379
SessionID: 36849
Restoring a SQL Server Database from Azure Blob Storage
Event Date: 27-06-2015 - Session time: 11:00:00 - Track: Cloud
Speaker: Randolph West
Title: Restoring a SQL Server Database from Azure Blob Storage
Abstract:
Microsoft Azure offers Blob Storage as a cost-effective way to store SQL Server backups offsite. Unfortunately, there is no easy way to go through tens of thousands of files to write a restore script, when your SQL Server goes away.
Leveraging Ola Hallengren's backup solution, this session will describe how to recover the most recent SQL Server backup available, by knowing only the database name and your Azure Storage credentials.
SessionID: 38237
Windows Azure SQL Database for the DBA
Event Date: 27-06-2015 - Session time: 11:00:00 - Track: Cloud
Speaker: Scott Klein
Title: Windows Azure SQL Database for the DBA
Abstract:
Windows Azure SQL Database is a fully-managed, scalable service based on SQL Server technology. Yet “fully-managed” does not necessarily mean that many or all of the tasks and responsibilities of the DBA are managed and executed by Microsoft or the service itself. The DBA is very crucial in Windows Azure SQL Database, and this session will take a look at the all-important role of the DBA when working with Windows Azure SQL Database. This session will look at how many of the on-premises functions, tasks, and responsibilities of the DBA are accomplished in a cloud environment, specifically Windows Azure SQL Database. This session will also look at the tips, tricks, and best practices a DBA should know for accomplishing similar on-premises tasks in the cloud.
SessionID: 37104
Accelerate SQL Server Master Data Services with Profisee Maestro
Event Date: 27-06-2015 - Session time: 12:15:00 - Track: Lunch Sessions
Speaker: John McAllister
Title: Accelerate SQL Server Master Data Services with Profisee Maestro
Abstract:
Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.
SessionID: 37206
Hardware for Nothing, Get Your Flash for Free—Optimized Data Center Econ
Event Date: 27-06-2015 - Session time: 12:15:00 - Track: Lunch Sessions
Speaker: J May
Title: Hardware for Nothing, Get Your Flash for Free—Optimized Data Center Econ
Abstract:
SQL Server licensing is complex— expensive. Consolidating on Flash provides savings of hundreds of thousands per server. A contemporary commodity two-socket server costs around $10K; SQL licenses for that server cost $200K to $300K or more. An idle CPU isn't doing nothing—it's burning money. You paid for your licenses, learn how to leverage them fully by leveraging Flash. Whether upgrading to leverage the latest--greatest SQL Server features or to maintain support owing to the Windows Server 2003 SQL Server 2005 EOL events, or consolidating strictly for economics, learn about real-life examples in which SanDisk has collaborated with our customers to save up to millions— learn how you can educate your engineers CxO's so you can do the very same thing. Doing so not merely covers your server Flash hardware budget, you'll have piles of money left over—and an even bigger pile when you stop paying for SAN maintenance. Standardize to optimize! Move electrons not molecules!
SessionID: 38102
Dell Lunch Presentation : Title and Speaker TBD
Event Date: 27-06-2015 - Session time: 12:15:00 - Track: Lunch Sessions
Speaker: Rich Baumet
Title: Dell Lunch Presentation : Title and Speaker TBD
Abstract:
TBD
SessionID: 38285
Event Date: 27-06-2015 - Session time: 12:15:00 - Track: Lunch Sessions
Speaker: Rich Baumet
Abstract:
Presented By Dell
SessionID: 38368
How to Light up your SQL Server Investment with Pyramid Analytics.com
Event Date: 27-06-2015 - Session time: 12:15:00 - Track: Lunch Sessions
Speaker: Mike Teel
Title: How to Light up your SQL Server Investment with Pyramid Analytics.com
Abstract:
Quick overview on who is Pyramid Analytics and demo on Pyramid Analytics BI Software
SessionID: 25071
Distributed Replay: Testing With Your Data, Your Way!
Event Date: 27-06-2015 - Session time: 13:30:00 - Track: Database Administration
Speaker: Melody Zacharias
Title: Distributed Replay: Testing With Your Data, Your Way!
Abstract:
SessionID: 35859
Parameter Sniffing the Good and the Bad
Event Date: 27-06-2015 - Session time: 13:30:00 - Track: Database Development
Speaker: Lance Tidwell
Title: Parameter Sniffing the Good and the Bad
Abstract:
SessionID: 36891
NFL Power BI
Event Date: 27-06-2015 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: BRADLEY BURCH
Title: NFL Power BI
Abstract:
Demonstrate Power BI Technologies utilizing 30 years of NFL data
SessionID: 36927
Paying Down Technical Debt - Consolidating Data Marts
Event Date: 27-06-2015 - Session time: 13:30:00 - Track: Data Warehousing
Speaker: Todd McDermid
Title: Paying Down Technical Debt - Consolidating Data Marts
Abstract:
So how do you get from spaghetti code to a more manageable Kimball style Data Warehouse Bus? Simple tools within SQL Server (views and schemas) partnered with conforming ETL to consistent practices are getting us there. Come see what we're doing that works - and share some of your own successes too!
SessionID: 37000
Choosing Projects for Hadoop in the Cloud
Event Date: 27-06-2015 - Session time: 13:30:00 - Track: Big Data
Speaker: Cindy Gross
Title: Choosing Projects for Hadoop in the Cloud
Abstract:
Techies and business people will learn how to choose the right projects for Hadoop. We'll talk about how Hadoop fits into end-to-end architectures and when it makes sent to put new Hadoop projects in the cloud, focusing on Microsoft Azure. I will show you HDInsight on Azure as well as Hortonworks HDP and Cloudera EDH/CDH on Azure VMs. http://smallbitesofbigdata.com/archive/2015/02/25/master-choosing-the-right-project-for-hadoop.aspx
SessionID: 11581
Azure Data Factory concepts
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Cloud
Speaker: Christian Cote
Title: Azure Data Factory concepts
Abstract:
Azure Data Factory is a new Service offered by Microsoft on Azure that can help you to manage your data on premise and in the clouds. This session will allow you to familiarize yourself with the different concepts and opportunities offered by the Azure Data Factory service.
SessionID: 12799
SRS Report Builder for Business Intelligence
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: David Eichner
Title: SRS Report Builder for Business Intelligence
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!
SessionID: 14164
SQL Server execution plans – hidden and tricky optimizations
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Database Development
Speaker: Fabiano Amorim
Title: SQL Server execution plans – hidden and tricky optimizations
Abstract:
In this session, I'll present some hidden and tricky optimizations that will help you to "speed-up" your queries. It all begins by looking at the query execution plan and from there, we'll explore the alternatives that were not initially considered by query optimizer and understand what is it doing. If you need to optimize queries in your work, don't miss this session. Also expect to hear about hidden features like batch sort, prefetch, set autopilot and hypothetical indexes.
SessionID: 27389
Ouch! Our Data Type Choices Did THAT?
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Database Development
Speaker: Vern Rabe
Title: Ouch! Our Data Type Choices Did THAT?
Abstract:
In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.
SessionID: 35721
Master Data Management - Getting Started with SQL Server MDS
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Enterprise Information Management
Speaker: John McAllister
Title: Master Data Management - Getting Started with SQL Server MDS
Abstract:
This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS
SessionID: 36269
Introduction to Policy Based Management
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: Steve Stedman
Title: Introduction to Policy Based Management
Abstract:
SessionID: 38449
Managing Log File Obesity
Event Date: 27-06-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: Michael Fal
Title: Managing Log File Obesity
Abstract:
Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.
SessionID: 11244
Why I can't adopt Power BI
Event Date: 27-06-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Cathy Dumas
Title: Why I can't adopt Power BI
Abstract:
File under "life after Microsoft" and "lessons learned". After spending time on the product development team, Power Pivot and the other tools in the Power BI stack hold a special place in my heart. I've tried using them in the real world and run into some serious adoption blockers. I will give an example end-to-end Power BI application that wound up getting mothballed and give a project post-mortem. I will also talk through user education, licensing, support, upgrade, and other considerations that make it hard for me to love Power BI.
SessionID: 12155
You haven't upgraded your SQL Server 2005 Servers yet?
Event Date: 27-06-2015 - Session time: 16:00:00 - Track: Database Administration
Speaker: Dandy Weyn
Title: You haven't upgraded your SQL Server 2005 Servers yet?
Abstract:
With SQL Server 2005 approaching its end of support, a lot of businesses are struggling on how to upgrade their existing environments to SQL Server 2012 or SQL Server 2014. Well this session is targeted at those!
Learn how to successfully implement different upgrade scenarios, including advanced upgrade scenarios such as rolling upgrades. By the end of the session you will have a clear understanding of which tools to use, which upgrade strategies to implement, and how to successfully upgrading your SQL Server installations with minimal downtime.
SessionID: 34782
Powershell Tips and Tricks for SQL Server Administration
Event Date: 27-06-2015 - Session time: 16:00:00 - Track: Database Administration
Speaker: Michael Fal
Title: Powershell Tips and Tricks for SQL Server Administration
Abstract:
SessionID: 37016
Where are the Women in Technology?
Event Date: 27-06-2015 - Session time: 16:00:00 - Track: Professional Development
Speaker: Cindy Gross
Title: Where are the Women in Technology?
Abstract:
Speaker Moderator Melody Zacharias
Panelists Cindy Gross, Julie Koesmarno, TBD
Panel: How is your business impacted when women are underrepresented in tech? Women are interested, why aren’t they working in IT? Why is the number of women in IT decreasing? How does subtle/implicit bias affect this? What can you personally do about it? Why should you care? We can all help make our businesses more productive, our work culture more pleasant, and our employees and coworkers happier.
SessionID: 9870
RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.
Event Date: 27-06-2015 - Session time: 16:00:00 - Track: Database Development
Speaker: Arnie Rowland
Title: RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.
Abstract:
I'm just going to say it straight out. I'm pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it 'pessimistic', or 'optimistic', or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel 'dirty' as you attempt to 'repeatedly' read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of 'Dirty', 'Repeatable' and 'Phantom' reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.