Nr: 294
SQLSaturday #294 - Philadelphia 2014
SessionID: 10088
SQL Server Backup and Recovery Fundamentals
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Ayman El-Ghazali
Title: SQL Server Backup and Recovery Fundamentals
Abstract:
Backup and Recovery are essential parts of and DBA's job. After all, if you lose your data you lose your job so you need a great backup strategy. In this session we will cover Recovery Models, Backup Types, Backup Strategy, Restores, RTO, RPO, and understanding how your Transaction Log is maintained through backups.
SessionID: 10681
Treating Tables Like Legos, Partitioning Basics
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
SessionID: 10853
SQL 2012 Table Compression
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Jason Brimhall
Title: SQL 2012 Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11197
Your SQL Server Environment--Fair or Foul?
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Carlos L Chacon
Title: Your SQL Server Environment--Fair or Foul?
Abstract:
Determine what's in play and what's not.
This presentation will focus on steps you can take to determine the performance of your SQL Server and where you may need to spend some time optimizing. We will review tools and scripts that are available from Windows Server and the SQL community so you won't have to go and ask your boss to buy something.
SessionID: 11271
The Spy Who Loathed Me - An Intro to SQL Security
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Chris Bell
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract:
You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
SessionID: 11675
The Business Intelligence Management Data Mart
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Chris Schmidt
Title: The Business Intelligence Management Data Mart
Abstract:
SessionID: 12402
High Availability with Windows Server 2012 R2 and SQL Server 2014
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: David Bermingham
Title: High Availability with Windows Server 2012 R2 and SQL Server 2014
Abstract:
This lecture takes a close look at the new features of Windows Server 2012 R2 clustering and how it affects your SQL Server availability. In addition, the new availability features of SQL Server 2014 will be reviewed. This session is geared for those new to Windows Server clustering and SQL Server AlwaysOn but will also be beneficial to those with experience looking to learn about the new high availability features in both Windows Server 2012 R2 and SQL Server 2014.
SessionID: 12899
Using Hive to Query and Process Big Data
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: Dan Clark
Title: Using Hive to Query and Process Big Data
Abstract:
SessionID: 13239
Parsing T-SQL using the TransactSql.ScriptDom library (C#)
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Dominic Falso
Title: Parsing T-SQL using the TransactSql.ScriptDom library (C#)
Abstract:
T-SQL is a very complicated language to parse, so it can be intimidating to get started. We'll go over basic concepts of what a lexer/parser is and what to expect from it. Then, using the TransactSql.ScriptDom library in the SQL Server SDK, we'll do some examples to get our feet wet.
SessionID: 13854
(a Few of) My Favorite DMVs
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Edward Pollack
Title: (a Few of) My Favorite DMVs
Abstract:
We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
SessionID: 14778
Common Problems in Backup and Recovery and How to Handle Them
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Grant Fritchey
Title: Common Problems in Backup and Recovery and How to Handle Them
Abstract:
The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we'll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we'll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you'll gain from this session could help to save your business.
SessionID: 16161
Beyond Stereotypes: Equality, Gender Neutrality, and Valuing Team Diversity
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Joseph D'Antoni
Title: Beyond Stereotypes: Equality, Gender Neutrality, and Valuing Team Diversity
Abstract:
SessionID: 16162
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: Joseph D'Antoni
Title: In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
Abstract:
SessionID: 16249
Bulk Insert, Temp Tables Computed Columns, T-SQL Techniques
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Joshua Lynn
Title: Bulk Insert, Temp Tables Computed Columns, T-SQL Techniques
Abstract:
SessionID: 16377
Analysis Services Relational Querying – Why Bother?
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Jeff Burke
Title: Analysis Services Relational Querying – Why Bother?
Abstract:
Data is more valuable when it is timely. Overnight processing windows are not always available in systems that need intra-day loads or in global systems. With a good design, relational queries can leverage the constantly improving database technologies including the use of columnar indexes and massively parallel processing (MPP) to provide business value at speed and scale.
This session will review the case for relational querying as well as the behaviors of Analysis Services operating in ROLAP and direct query modes.
SessionID: 17008
Effective Data Warehouse Storage Patterns
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: John Miner
Title: Effective Data Warehouse Storage Patterns
Abstract:
Abstract:
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What are Federations in Azure SQL?
SessionID: 17510
Visual Analytics with HDInsight and Power View
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Josh Fennessy
Title: Visual Analytics with HDInsight and Power View
Abstract:
BIG DATA! There, I've said it. But, what exactly does it mean for YOU?
This session will help to dispel some of the Big Data confusion. This session will focus on HD Insight, Microsoft's Hadoop based implementation. Loading data and querying a database is one thing and that will certainly be covered. Exploring how we can integrate data from HD Insight into our existing analytic solutions is one of the real world implementations this session will be focused on. This is one of the keys to successfully selling management on the needs for a Big Data solution. It's not just another database, it's a tool to enhance existing analytic structures.
During this session, we'll start with a brief overview of Hadoop and HDFS. Next we'll take a look at HD Insight, and explore some of the features therein.
Finally, integration with SSAS and Power View (using Excel 2013) will be shown, which will close the loop on Big Data visualizations.
SessionID: 17871
Database Design Contentious Issues
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * NULL/NOTNULL * Classwords and other Naming Standards * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 18550
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Konstantin Melamud
Abstract:
This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
SessionID: 18870
Think like SSIS and Build a package
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Ravi Kumar
Title: Think like SSIS and Build a package
Abstract:
You wouldn't drive to a new place without direction? Then why build a SSIS package without having a road map on how to build it. Learn how to think like SSIS, make your ETL life easy, and convert a Process into an SSIS Package. Expect to participate activity in the class.
SessionID: 19047
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: Leonard Lobel
Abstract:
SessionID: 19586
Optimizing Bulk Insert Operations
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: Mark Wojciechowicz
Title: Optimizing Bulk Insert Operations
Abstract:
SessionID: 19646
Analysis Services Terms and Concepts for the DBA
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Mark Vaillancourt
Title: Analysis Services Terms and Concepts for the DBA
Abstract:
Despite some overlapping concepts, the worlds of the Relational engine and Analysis Services really are quite different. With more and more organizations realizing the power of Analytics, there is a good chance a BI initiative will come your way at some point.
This session is intended for the DBA that wants/needs to learn more about SQL Server Analysis Services. The goal is to provide a meaningful base of knowledge that will allow you to effectively participate in discussions of Analysis Services in your organization.
Through both slides and demos, you will learn:
-- The differences between SSAS Multidimensional and SSAS Tabular
-- Key terms like Measures, Dimensions, Hierarchies
-- Storage options such as MOLAP, HOLAP, ROLAP, and Direct Query
-- Monitoring with Extended Events
-- Overviews of MDX, DAX, and XMLA
-- and more
Come take a few steps into the exciting world of Business Intelligence with SQL Server Analysis Services.
SessionID: 20042
Practical SQL Azure: Moving into the Cloud
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: Tim Corey
Title: Practical SQL Azure: Moving into the Cloud
Abstract:
SQL Azure has been around for a few years now but you are still running all of your databases locally. You would like to use the cloud but you just aren't sure where to start. Come to this session and we will get you started down the right path. We will start by going over the basics of SQL Azure, including what it is, how to set it up and what the benefits and drawbacks are of it. Next, we will look at how to move an existing database into SQL Azure. Finally, we will look at how to take advantage of the benefits of the cloud to make your SQL database safer and more redundant. By the end of this session, you should have a good understanding of where you could go with SQL Azure and how to get there.
SessionID: 20209
Put Your Data on the Map
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Mark Hudson
Title: Put Your Data on the Map
Abstract:
Columbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server supports geospatial data. Reporting Services provides map galleries. Come see how we leverage those knowns to present our data in a geographical way.
SessionID: 21719
Securing a Multi-Database Application
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Sebastian Meine
Title: Securing a Multi-Database Application
Abstract:
It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.
In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
SessionID: 21805
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI II
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 22640
Getting Started with Hekaton (In-Memory OLTP)
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: Brian Davis
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract:
SessionID: 23551
DBA for Dummies
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Robert Pearl
Title: DBA for Dummies
Abstract:
SessionID: 24420
Indexing Fundamentals
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Steve Hood
Title: Indexing Fundamentals
Abstract:
A solid understanding of clustered and nonclustered indexes and a thorough look at their costs and benefits. This will include looking in execution plans to see how indexes are used, going through the buffer cache to see the memory costs and benefits, and a complete look at how they fit into a strategy to improve page life expectancy and server performance.
SessionID: 24644
Introducing Power BI
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: Stacia Varga
Title: Introducing Power BI
Abstract:
SessionID: 25440
SQL Server Reporting Services Best Practices
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Steve Simon
Title: SQL Server Reporting Services Best Practices
Abstract:
In this hands on presentation, we shall be discussing some best practices that one should follow during the project life cycle from development to the production and implementation phases.
We shall be discussing the pros and cons of utilizing shared datasets, the pluses and pitfalls of utilizing embedded reports, report utilization logging, utilization of graphics and the portability of solutions from one server to another.
SessionID: 26013
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: BI I
Speaker: Tamera Clark
Abstract:
SessionID: 26816
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: Timothy McAliley
Title: Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure
Abstract:
SessionID: 27520
Extended Properties and how to automate DB Documenting process.
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Slava Murygin
Title: Extended Properties and how to automate DB Documenting process.
Abstract:
Do you know what Extended Properties are?
Do you use Extended Properties for your database objects?
Do you know how to simplify the process of setting Extended Properties for automated Documenting of your Database?
If any of your answers is "NO" then you have to attend this session.
SessionID: 27630
The Super Trace: Introduction to Extended Events
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Warner Chaves
Title: The Super Trace: Introduction to Extended Events
Abstract:
SessionID: 27721
Table Vars Temp Tables - What you NEED to Know!
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA I
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 28341
An Introduction to SQLCLR
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Justin Dearing
Title: An Introduction to SQLCLR
Abstract:
This talk will cover writing stored procedures and user defined functions with SQLCLR. Basic familarity with T-SQL, C# and Visual Studio is presumed for the audience.
During this talk we will demonstrate the following with SQLCLR
- A Better RAISERROR()
- Reading and writing JSON and CSV formats
- Reading and writing XLSX files without ad hoc queries
We will also discuss the administrative and security concerns of SQLCLR, and how to customize Visual Studio's behavior during the deploy process.
SessionID: 9086
45 Minutes to Your First SSAS Tabular Model
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Kerry Tyler
Title: 45 Minutes to Your First SSAS Tabular Model
Abstract:
SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.
SessionID: 9202
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: DBA II
Speaker: Saska Cvetkovic
Abstract:
SessionID: 9266
Hybrid Solutions: The Future of SQL Server Disaster Recovery
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: SQL 2014
Speaker: Allan Hirt
Title: Hybrid Solutions: The Future of SQL Server Disaster Recovery
Abstract:
The cloud is a polarizing buzzword in IT, especially for DBAs. The reality is that all of us will be affected by it over the next few years in one way or another much like we have been by virtualization. One of the best uses for the cloud is creating disaster recovery easier than we have been able to do in the past. This session will discuss the cloud from a SQL Server DBA perspective and how things like hybrid on premise/cloud solutions can be architected today to bring resiliency to current solutions with features like availability groups in SQL Server 2012 and 2014.
SessionID: 9920
Using Apache Solr with SQL for Text Searching
Event Date: 07-06-2014 - Session time: 00:00:00 - Track: Misc
Speaker: Ashton Hobbs
Title: Using Apache Solr with SQL for Text Searching
Abstract:
Big Data is quickly becoming THE thing to do. Even Microsoft is getting in on the game with HDInsight and Azure. In this session we will cover how to use Apache Solr, a Lucene based Open Source search engine, to provide text indexing and search capabilities and how to integrate it with SQL Server. Not only can Solr provide a full range of indexing and search features, but it can also be used to help improve performance of some queries commonly used in SQL Server by offloading them to Solr (the ubiquitous field search procedures as one example).
The session will cover some basics about how Solr works, starting and customizing Solr, indexing documents, search features, and how to integrate with SQL Server.