Nr: 314
SQLSaturday #314 - Providence 2014
SessionID: 10879
Murder They Wrote
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 3 (PERF)
Speaker: Jason Brimhall
Title: Murder They Wrote
Abstract:
This is the Solo version of the Joint version normally done as an all-day precon
SessionID: 11032
PowerShell for Database Developers
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 2 (DEV)
Speaker: Bryan Cafferky
Title: PowerShell for Database Developers
Abstract:
PowerShell has become the backbone of Windows Administrators but not heavily adopted by SQL Developers and this presentation is out to change that. Do you ever need to encrypt, decrypt, zip, unzip, combine files, export to csv format , import from csv format, move, copy, rename, even provide a nice interface to some powerful script you wrote? Bryan will even demonstrate how a PowerShell script can automatically navigate web pages doing tasks for you on the internet. In short, there is nothing PowerShell can't do an if you are a SQL Developer or DBA, you need to be leverage its Power!
SessionID: 11033
Breaking Down BI Barriers with PowerShell
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 2 (DEV)
Speaker: Bryan Cafferky
Title: Breaking Down BI Barriers with PowerShell
Abstract:
SessionID: 11279
Prevent Recovery Amnesia – Forget the Backups
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 4 (ADM)
Speaker: Chris Bell
Title: Prevent Recovery Amnesia – Forget the Backups
Abstract:
Do you suffer from Recovery Amnesia?
You have a complete strategy to backup your SQL environment; but what about the recovery?
Is that even part of your strategy?
Through this introductory session we will review the various aspects myths of backups in SQL Server. We will pin down how developing a recovery strategy to meet business requirements is, in fact, more important than just a good backup strategy.
SessionID: 11467
Scratching the surface: An overview of SSRS and building your first BI Report
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 1 (BI)
Speaker: Christopher Seferlis
Title: Scratching the surface: An overview of SSRS and building your first BI Report
Abstract:
This session will act as an introduction to SSRS, its infrastructure, and the basics of report design. There will be a brief overview of the development environment, wizards, datasets, grouping, subscriptions, permissions, parameters and some basic graphing alongside the data.
SessionID: 11567
Check Engine Lights
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 3 (PERF)
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
SessionID: 13174
The Quest for the Golden Record:MDM Best Practices
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 1 (BI)
Speaker: Dennis Messina
Title: The Quest for the Golden Record:MDM Best Practices
Abstract:
In this session, we will focus on how to formulate a Master Data Management strategy and build a solution to find the single version of the truth, aka the Golden Record. We will demonstrate building a sample customer domain in this session, showing how to use various tools including MDS for data quality, matching, and deduplication across multiple data sources.
SessionID: 13857
Diving Into Query Execution Plans
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 3 (PERF)
Speaker: Edward Pollack
Title: Diving Into Query Execution Plans
Abstract:
SessionID: 14558
SQL Server 2012/2014 AlwaysOn Availability Groups
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 4 (ADM)
Speaker: George Walters
Title: SQL Server 2012/2014 AlwaysOn Availability Groups
Abstract:
Need HA and DR? Tired of Mirroring or Log Shipping restrictions? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.
SessionID: 14559
SQL Server 2012/2014 Failover Clustering
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 4 (ADM)
Speaker: George Walters
Title: SQL Server 2012/2014 Failover Clustering
Abstract:
Need to Geocluster? Tired of spamming your SAN with Tempdb? SQL Server 2012 and 2014 have significant improvements in Failover Clustering Instances. This will review shared-disk instance clustering and illustrate the new features.
SessionID: 16747
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 2 (DEV)
Speaker: John Flannery
Abstract:
SessionID: 20993
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 2 (DEV)
Speaker: Michael Nowill
Abstract:
Does only a small portion of your data change on a routine? Is index maintenance taking for ever? Do users mostly focus only on a subset of data such as the current year, month or day? Do you want to delete or insert massive amount s of data with almost no blocking? Well, step right up because data partitioning can do all this and more! We will take a look at the different option for partitioning, the pros and cons and how to implement them in SQL.
SessionID: 21669
Network or Perish
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 4 (ADM)
Speaker: Paresh Motiwala
Title: Network or Perish
Abstract:
As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities.
http://wcompute.org/2012/05/19/review-of-sqlsaturday-142-network-or-perish/
SessionID: 22592
Understanding Transaction Isolation Levels
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 3 (PERF)
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 22593
Locks, Blocks, and Deadlocks Oh My!
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 3 (PERF)
Speaker: Randy Knight
Title: Locks, Blocks, and Deadlocks Oh My!
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
SessionID: 25548
A dive into Data Quality Services
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 1 (BI)
Speaker: Steve Simon
Title: A dive into Data Quality Services
Abstract:
Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.
SessionID: 25881
Develop Impressive Dashboards using SSRS 2014
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 1 (BI)
Speaker: Sunil Kadimdiwan
Title: Develop Impressive Dashboards using SSRS 2014
Abstract:
Microsoft Reporting Services 2014 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2014.
SessionID: 26975
Power BI Components in Microsoft's Self-Service BI Suite
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 1 (BI)
Speaker: Todd Chittenden
Title: Power BI Components in Microsoft's Self-Service BI Suite
Abstract:
Microsoft has made extensive effort in the arena of self-service BI. By now most BI professionals have at least dabbled in power pivot and power view. But there is so much more. In this session we will look at some new components in Microsoft's arsenal of BI tools. Power Query is used to retrieve data from a much more varied set of data source types than was ever available before. Power Map can be used to quickly visualize geocentric data with layers and Power Point like slides. Lastly, the Power BI content on your Office 365 site supports sharing your workbooks with others, and has the coolest feature yet: Natural Language Q A.
SessionID: 8922
T-SQL : Bad Habits Best Practices
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 2 (DEV)
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits Best Practices
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
SessionID: 9648
Storing Data in Windows Azure
Event Date: 18-10-2014 - Session time: 00:00:00 - Track: Track 4 (ADM)
Speaker: Andy Roberts
Title: Storing Data in Windows Azure
Abstract: