Nr: 397
SQLSaturday #397 - Omaha 2015
SessionID: 10603
Whatcha Doin'? Passive Security for Hostile Environments
Event Date: 15-08-2015 - Session time: 08:30:00 - Track: Security
Speaker: Bob Pusateri
Title: Whatcha Doin'? Passive Security for Hostile Environments
Abstract:
Ideal database security settings usually exist in books, but rarely in reality. Is your CIO a member of the sysadmin role because they demanded it? Or maybe some users have rights for purely political reasons? Just because you can't enforce security through typical means doesn't mean you're powerless. Attend this session to learn about the features SQL Server provides that will allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments these techniques can still come in handy. The best security is often that which cannot be seen.
SessionID: 13920
Table Partitions for Archiving
Event Date: 15-08-2015 - Session time: 08:30:00 - Track: Developer
Speaker: Eric Zierdt
Title: Table Partitions for Archiving
Abstract:
What is Table Partitioning? How can it be used to move large amounts of data quickly? How can it be used with a data archiving strategy to quickly and easily drop archived data from a table? We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you.
SessionID: 15769
What is causing my database to grow?
Event Date: 15-08-2015 - Session time: 08:30:00 - Track: DBA
Speaker: Jared Karney
Title: What is causing my database to grow?
Abstract:
Have you ever received a call that an application is throwing errors about the database being out of space? This session will help you learn how to proactively deal with those calls! Sometimes it isn’t practical to limit the growth of our databases. As DBAs, it is our responsibility to make sure that we know the disk space that is used and free, the size of our databases, when they grew, and why they grew so that we can prepare for it or reduce it. We can also track the size and growth over time to be able to predict future trends. In this beginner session, Jared Karney will show you how you can track the size of your disks, databases, and database files using DMVs. He will show you how to structure tables and indexes for storing this data, demonstrate the Extended Events to track when a data or log file grows and what caused the growth to occur, and how you can automate the whole process using SQL Agent.
SessionID: 36449
APPLY Yourself
Event Date: 15-08-2015 - Session time: 08:30:00 - Track: Developer
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 38627
Become the DBA of the future! Everything you need to know about Azure
Event Date: 15-08-2015 - Session time: 08:30:00 - Track: Cloud Big Data
Speaker: Dandy Weyn
Title: Become the DBA of the future! Everything you need to know about Azure
Abstract:
Become the DBA of the future!
SessionID: 11142
Microsoft APS - SMP vs. MPP
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: Cloud Big Data
Speaker: Chaitanya Khaladkar
Title: Microsoft APS - SMP vs. MPP
Abstract:
Learn about how the MPP architecture can benefit hundreds of business use-cases and scenarios while providing phenomenal performance gains over a traditional SMP architecture.
SessionID: 15777
Size: Blue Color: M Wait, What!?!
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: Data BI
Speaker: Jason Dempster
Title: Size: Blue Color: M Wait, What!?!
Abstract:
How many times have you received data from a 3rd party or from within your own databases that has anomalies in it? What are the typical steps to clean up the data before it goes into the data warehouse or other systems? This session will demonstrate Data Quality Services, using both the client interface to define domains and rules, as well as the control included with Integration Services, allowing cleansing to occur within the data flow task.
SessionID: 25189
Navigating the Hadoop Stack
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: Cloud Big Data
Speaker: Scott Shaw
Title: Navigating the Hadoop Stack
Abstract:
Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.
SessionID: 37974
Social Networking Is Alive!!!
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: Soft Skills
Speaker: John Morehouse
Title: Social Networking Is Alive!!!
Abstract:
SessionID: 38017
Data Architecture 101
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: Soft Skills
Speaker: Pat Phelan
Title: Data Architecture 101
Abstract:
This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
SessionID: 9623
Event Date: 15-08-2015 - Session time: 10:00:00 - Track: DBA
Speaker: Andy Galbraith
Abstract:
How often do you review your SQL Servers for basic security, maintenance, and performance issues? If you say never, I'm not surprised - many of the servers I "inherit" as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)
Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
SessionID: 12159
Power BI
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: Data BI
Speaker: Dandy Weyn
Title: Power BI
Abstract:
Come see Dandy do real-time analytics on #SQLSatOmaha tweets and see how Power BI pulls all of the data together in a way that tells a story for any audience!
SessionID: 21140
Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: DBA
Speaker: Mark Skiles
Title: Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups
Abstract:
AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously.
SessionID: 26123
Establishing a SLA
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: Soft Skills
Speaker: Thomas Grohser
Title: Establishing a SLA
Abstract:
Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.
#160;
This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.
SessionID: 28137
Introducing Forensic Analytics with PowerPivot for Excel
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: Security
Speaker: William E Pearson III
Title: Introducing Forensic Analytics with PowerPivot for Excel
Abstract:
Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
SessionID: 32357
Scary Things A Database Owner Can Do
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: Security
Speaker: Paul Timmerman
Title: Scary Things A Database Owner Can Do
Abstract:
So you've setup your new SQL Server instance and it’s time to start adding databases to it. You followed security best practices at the instance level, but what about security within each database? Is that something you can control? Well, if like me, you work in a shop that mostly purchases software, then having users with database owner permissions is a reality, and likely not one you can change. But members of the db_owner role can only make changes that would adversely impact their own databases, right? Think again. During this session we’ll review some common database level settings and actions which can have a negative impact across the entire instance. We’ll discuss ways to mitigate these risks and monitor for their occurrence. Come learn how to not let poor choices made by a database owner impact your entire instance.
SessionID: 35629
Event Date: 15-08-2015 - Session time: 12:45:00 - Track: DBA
Speaker: Chris Shaw
Abstract:
After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;
We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160;
These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.
SessionID: 24638
Virtualize Clusters and AlwaysOn Availability Groups
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Shawn Meyers
Title: Virtualize Clusters and AlwaysOn Availability Groups
Abstract:
SessionID: 28140
Getting Started with MDX
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: Data BI
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 36448
Much Ado About Hadoop
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: Cloud Big Data
Speaker: Kevin Feasel
Title: Much Ado About Hadoop
Abstract:
Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
SessionID: 38303
What is Biml and why are SSIS people talking about it?
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: Data BI
Speaker: Bill Fellows
Title: What is Biml and why are SSIS people talking about it?
Abstract:
This session is designed for you, the experienced SSIS developer who's been hearing about Biml but hasn't taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.
SessionID: 38456
SQL Server Benchmarking: The Powershell Speedometer
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Michael Fal
Title: SQL Server Benchmarking: The Powershell Speedometer
Abstract:
SessionID: 39332
SQL Server 2016 Overview
Event Date: 15-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Phil Brammer
Title: SQL Server 2016 Overview
Abstract:
Come join Phil Brammer as he talks through the new features in SQL Server 2016. This session will touch on AlwaysOn, In-Memory, Query Store, and more!
SessionID: 25188
So You Want a Job in Big Data?
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: Cloud Big Data
Speaker: Scott Shaw
Title: So You Want a Job in Big Data?
Abstract:
SessionID: 26567
Fun with Availability Groups
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: Developer
Speaker: Christopher Wolff
Title: Fun with Availability Groups
Abstract:
Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
SessionID: 36608
The Database: The Elephant in the ALM Room
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: Developer
Speaker: Grant Fritchey
Title: The Database: The Elephant in the ALM Room
Abstract:
Many teams and individuals are still building their databases and maintaining them through old-fashioned manual processes. This, even as these same teams move towards an automated Application Lifecycle Management (ALM) through the adoption of DevOps best practices. These manual processes are hurting the ability of your database deployments to keep up with modern development. Is there a technical reason for this slow adoption of ALM best practices in the database world, or is there a cultural problem preventing a reassessment of these manual processes? Or, could it be both? This session will address these questions as it explores the challenges presented by ALM for databases. We will discuss the necessary first steps required to move from a manual database deployment process to a fully automated one. You will learn about tooling that can assist you in implementing these new processes. Your database deployments can take advantage of the same processes you use for application deployments.
SessionID: 37971
10 Things Every DBA Should Know!
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: DBA
Speaker: John Morehouse
Title: 10 Things Every DBA Should Know!
Abstract:
Are you just starting out in the database world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to either of those questions, then this is the session for you! John will be talking about things from both an administrative and developmental aspect that every DBA should know and understand. We'll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!
SessionID: 38281
Protecting Your Data with Encryption
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: Security
Speaker: Ed Leighton-Dick
Title: Protecting Your Data with Encryption
Abstract:
We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
SessionID: 38515
What SQL DBAs need to know about SharePoint
Event Date: 15-08-2015 - Session time: 15:45:00 - Track: DBA
Speaker: JD Wade
Title: What SQL DBAs need to know about SharePoint
Abstract:
With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, and supported methods for providing high availability and disaster recovery.