Nr: 273
SQLSaturday #273 - Tampa 2014
SessionID: 10041
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Allen White
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract:
You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
SessionID: 10148
Trimming Indexes Getting Your Database In Shape
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Bradley Ball
Title: Trimming Indexes Getting Your Database In Shape
Abstract:
Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them, and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op’s, and space and never even know it.
SessionID: 10674
Treating Tables Like Legos, Partitioning Basics
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
SessionID: 10758
The Modern Data Warehouse
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Brian Mitchell
Title: The Modern Data Warehouse
Abstract:
SessionID: 11114
BIML--Step by Step
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
SessionID: 11560
Check Engine Lights
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
Together we'll explore SQL Server "check engine lights", those little indications that SQL Server needs your attention. Ignore these and you could be stuck alongside the road with a broken engine.
SessionID: 11561
Your Best Interview Ever
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Chris Skorlinski
Title: Your Best Interview Ever
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I'll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure.
SessionID: 12535
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: David Klee
Abstract:
SessionID: 13279
Eternal story on temporal objects
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Dmitri Korotkevitch
Title: Eternal story on temporal objects
Abstract:
This session focuses on the temporary objects available in SQL Server. It talks about temporary tables, table variables, table-valued parameters and discusses their internal implementation and best use-cases for them. The session also covers some aspects of tempdb usage and monitoring and shows how to reduce tempdb load and improve its throughput.
SessionID: 13984
Dynamic File Loading Using SSIS Programming
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jorge Novo
Title: Dynamic File Loading Using SSIS Programming
Abstract:
Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization.
SessionID: 14019
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Eric Wisdahl
Abstract:
No budget? That's OK! Need Tools? We've get them! Don't know where to go? We'll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will show you several great tools, scripts, blogs and other resources to help you out. Best of all, it's all free! But wait, there's more. Order now and we'll include an extra two tips at no additional cost!
SessionID: 14310
An introduction to Business Intelligence and Big Data
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Frank Quintana
Title: An introduction to Business Intelligence and Big Data
Abstract:
An introduction to BI architecture with the focus on the Microsoft BI stack as well as an introduction to Hadoop and its impact on BI and analytics.
Anybody interested in BI and Big Data. Some knowledge of database and/or exposure to BI tools would be beneficial for better appreciation between the significance of BI and Big Data
SessionID: 14732
Statistics and Query Optimization
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Grant Fritchey
Title: Statistics and Query Optimization
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
SessionID: 15690
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Janis Griffin
Abstract:
SessionID: 15790
Maintenance and Backups: How Ola makes your life
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jason Carter
Title: Maintenance and Backups: How Ola makes your life
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
SessionID: 16116
Designing and Optimizing SSAS Hierarchies
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jose Chinchilla
Title: Designing and Optimizing SSAS Hierarchies
Abstract:
In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. A brief introduction will be made navigate hierarchies using MDX functions.
SessionID: 16308
How to be a GREAT DBA
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jeffrey Garbus
Title: How to be a GREAT DBA
Abstract:
This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.
Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
SessionID: 16514
Combining SQL Server, SSRS and SSAS with Tableau Dashboards
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jen Underwood
Title: Combining SQL Server, SSRS and SSAS with Tableau Dashboards
Abstract:
- Visual Analytics in Enterprise BI
- Solution Architecture
- SQL Server, SSRS and SSAS and other Microsoft BI data source connectivity
- Mobile BI
- Integration
- Predictive Visual Analytics
SessionID: 17051
SQL Server Amnesia: Diagnosing Memory Problems
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jonathan Kehayias
Title: SQL Server Amnesia: Diagnosing Memory Problems
Abstract:
SessionID: 17208
Unit Testing SSIS Packages
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: John Welch
Title: Unit Testing SSIS Packages
Abstract:
SessionID: 17400
What is a BI DBA?
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jorge Segarra
Title: What is a BI DBA?
Abstract:
Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!
SessionID: 18068
Discover, Document, Diagnose Your Servers on Your Coffee Break
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Kendal Van Dyke
Title: Discover, Document, Diagnose Your Servers on Your Coffee Break
Abstract:
Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?
You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
SessionID: 19967
Complex DAX Functions
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Mike Davis
Title: Complex DAX Functions
Abstract:
SessionID: 20416
Database Development Comes out of the Dark Ages
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: miguel Cebollero
Title: Database Development Comes out of the Dark Ages
Abstract:
SessionID: 20478
Introducing Cube World To Users From Flat Table Land
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Michael Antonovich
Title: Introducing Cube World To Users From Flat Table Land
Abstract:
This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.
SessionID: 22247
Big Data - HdInsight and Parallel Data Warehousing (PDW)
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Philip Pees
Title: Big Data - HdInsight and Parallel Data Warehousing (PDW)
Abstract:
SessionID: 22960
ETL: Avoiding Costly Mistakes
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Rafael Salas
Title: ETL: Avoiding Costly Mistakes
Abstract:
In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
SessionID: 23147
Loading a Data Warehouse with SSIS
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Robert Biddle
Title: Loading a Data Warehouse with SSIS
Abstract:
SessionID: 23266
Harvesting Web Data Using Data Explorer and XML
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Rob Volk
Title: Harvesting Web Data Using Data Explorer and XML
Abstract:
SessionID: 23438
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Ronald Dameron
Abstract:
Attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
DBAs will leave this session with an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data.
In addition, I’ll talk about our DBA’s real world experience with reduced permissions
SessionID: 24629
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Shawn Meyers
Abstract:
SessionID: 24917
Introduction to SQL Server Replication
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Chad Churchwell
Title: Introduction to SQL Server Replication
Abstract:
With replication being a source for many data warehouse systems, this session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.
SessionID: 25137
Database Design: Size DOES Matter
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25887
Can't we all just get along?
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Susan Rickman
Title: Can't we all just get along?
Abstract:
There comes a point in every career that you will need to talk to people that you do not agree with. It is important to advancement (and well-being) that you are able to make concise points that will draw interest from other teams, as opposed to alienating them.
How do you speak to your leadership team? Your peers? People who depend on you? People on whom you depend?
SessionID: 26015
Introduction to SSRS for DBAs
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Jon Bloom
Title: Introduction to SSRS for DBAs
Abstract:
Want to write SQL-Server SSRS reports? Not fluent in T-SQL or MDX? Learn how to create Custom Reports without writing any code. See examples in OLTP, OLAP and Hadoop Hive.
SessionID: 26706
You Inherited a Database, Now What?
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Tim Radney
Title: You Inherited a Database, Now What?
Abstract:
SessionID: 26708
Getting involved and Getting ahead
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Tim Radney
Title: Getting involved and Getting ahead
Abstract:
SessionID: 27561
Introduction to FileTables in SQL 2012
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Warren Sifre
Title: Introduction to FileTables in SQL 2012
Abstract:
SessionID: 27683
Windowing Functions in SQL Server 2012
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 9574
PCI For The SQLDBA
Event Date: 22-02-2014 - Session time: 00:00:00 - Track:
Speaker: Andy Warren
Title: PCI For The SQLDBA
Abstract:
Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We'll cover how PCI works from the requirements to the final audit, and eveything in between that you'll need to know something about. We'll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It's a complex topic, but that just makes it more interesting!