Nr: 446
SQLSaturday #446 - Oregon 2015
SessionID: 37178
Who Has What to Which? (The Permissions Superset)
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Admin
Speaker: Robert Davis
Title: Who Has What to Which? (The Permissions Superset)
Abstract:
Do you know who has access to your database and what permissions they have? If you answered yes, you're most likely wrong. Permissions in SQL Server don't work the way almost everyone think they do. We'll look at different scenarios you are likely to see day-to-day and explore what permissions the users are actually getting (likely not what you expect).
This exercise will demonstrate why it is important to be strict about granting permissions and cleaning up old security accounts. You will learn how to think of permissions as a superset.
SessionID: 38942
How I survived supporting a Java team
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Professional Development
Speaker: Rick Lowe
Title: How I survived supporting a Java team
Abstract:
After spending the last decade or so completely devoted to the Microsoft stack, I spent the last year supporting the SQL Server instance for a team of Java developers. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. I did find, however, that there were cultural differences which made my biggest challenges different from what I was used to dealing with in the .Net world. Come hear about my misadventures with JBoss, server side cursors, and NOCOUNT settings.
SessionID: 39631
A Programmatic Journey Through SSISDB
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Integration Services
Speaker: Wolfgang Strasser
Title: A Programmatic Journey Through SSISDB
Abstract:
With the advent of SQL Server Integration Services Catalog (SSISDB) a new place of storing, executing and monitoring SSIS packages came into existence. In this session, Wolfgang will show you different aspects of programmability in the context of SSISDB. Beginning with a short overview of the underlying database objects, a deeper look at SSISDB's stored procedures will follow. A side-step from TSQL to C# and the available Integration Services SDK illustrates a different view accessing SSISDB.
Concluding, the analysing and reporting aspect of SSISB programmability is shown with some exemplified SQL Server Reporting services reports.
SessionID: 40108
Every Byte Counts: Why Your Data Type Choices Matter
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Development
Speaker: Andy Yun
Title: Every Byte Counts: Why Your Data Type Choices Matter
Abstract:
Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!
When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
SessionID: 40218
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Business Intelligence
Speaker: Reza Rad
Abstract:
SessionID: 40221
A Journey into Azure Machine Learning with R
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Architecture
Speaker: Leila Etaati
Title: A Journey into Azure Machine Learning with R
Abstract:
This session will show how they can use Azure ML to as a data mining tools. They become familiar with all steps of creating a prediction scenario from importing data, cleaning it, choosing the right algorithm, how evaluate the result, executing R code, and so forth.
SessionID: 40274
Dealing With Errors in SSIS 2014
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Integration Services
Speaker: David Dye
Title: Dealing With Errors in SSIS 2014
Abstract:
Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail.
You will learn:
•To identify the different error handling methods in control flow, data flow, and script tasks
•Be able to utilize event handlers to proactively handle errors
•Be able to redirect data error and proactively handle data flow errors
•Be able to identify error descriptions and log error details
SessionID: 40420
Anatomy of an I/O Tuning Exercise
Event Date: 24-10-2015 - Session time: 09:15:00 - Track: Tuning
Speaker: Theresa Iserman
Title: Anatomy of an I/O Tuning Exercise
Abstract:
SessionID: 37408
How to Determine What Data Is Corrupt
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Admin
Speaker: Frank Gill
Title: How to Determine What Data Is Corrupt
Abstract:
There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will. Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt. And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
SessionID: 38674
Choosing Projects for Hadoop in the Cloud
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Architecture
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: 38841
Slow Query: Bring It On
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Tuning
Speaker: Amit Banerjee
Title: Slow Query: Bring It On
Abstract:
In this session, you will learn about:
- Using Live Query Statistics to perform live troubleshooting while it is running
- Using Query Data Store and becoming a SQL superhero by answering questions about query performance with a click of a few buttons
SessionID: 39147
Extended Events In Real Life
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Admin
Speaker: Seth Washeck
Title: Extended Events In Real Life
Abstract:
Extended Events, introduced in SQL Server 2008 are here to stay. When combined with the fact that Profiler for Trace is a deprecated feature we're going to need to learn how to use Extended Events to monitor our server. In this session we're going to step through some real-world uses of Extended Events including Statistics capture, Default Trace replacement, system_health analysis, and insight into the DBCC CHECKDB process (NEW IN SQL 2014)!
SessionID: 39874
Dynamic SQL: Build Fast, Flexible Queries
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Development
Speaker: Jeremiah Peschka
Title: Dynamic SQL: Build Fast, Flexible Queries
Abstract:
Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. In this session, we’ll be dispelling these misconceptions and demonstrating how dynamic SQL can become a part of every DBA’s tool kit.
SessionID: 40297
What is Biml and why are SSIS people talking about it?
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Integration Services
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: 40432
Life Lessons in Communication
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Professional Development
Speaker: Tom Roush
Title: Life Lessons in Communication
Abstract:
Communicating. We all do it, every day. But can you do it better? You present to management, share with peers, advise your direct reports. A common thread of success or failure here is how well you get your message across.
Can you share bad news and soften the blow with humor while respecting the nature of the news you have to deliver?
Can you support your direct reports when they make a very human mistake?
Do you know how you communicate your support without micromanaging them can make a huge difference in the quality of their work for years to come?
These questions and more will be answered, with stories, with humor, and with experience (both good and bad).
Once you've figured these things out, how do you communicate your own skills to the world?
After attending, you’ll be on the road to better, more direct communication, whether it’s with your management, your peers, or your reports.
SessionID: 40523
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Features
Speaker: Jason Horner
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract:
Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements. This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices. This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 40950
Better Report Development and Management Techniques
Event Date: 24-10-2015 - Session time: 10:30:00 - Track: Business Intelligence
Speaker: Ted Stathakis
Title: Better Report Development and Management Techniques
Abstract:
Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.
SessionID: 37794
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Integration Services
Speaker: Cathrine Wilhelmsen
Abstract:
You already know how to build a staging environment in an hour, so let us dive straight into some advanced features of Biml. We will start by exploring the metadata modeling feature in Mist. Then we will look at how to create our own C# classes and methods, and how to centralize and reuse code. Finally, we will create a framework of transformers that allow you to modify existing objects both interactively and automatically.
If you already think Biml is powerful, just wait until you have a toolbox full of transformers ready to do the heavy lifting for you!
(No Autobots were harmed in the making of this session.)
SessionID: 38088
Revenge: The SQL! - Director's Cut
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Admin
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 38397
Designing Building Highly Available Solutions
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Architecture
Speaker: John Martin
Title: Designing Building Highly Available Solutions
Abstract:
Building a system that is Highly Available is something that requires a lot of thought and work up-front, it is not something that is easy to add after the system is built.
In this session I will help you understand the questions you need to ask, the options that are available to you and design principals technology that can be leveraged to build a solution that can meet your needs and the needs of your business. Covering elements from the physical storage all the way out to the client application connectivity, we will look at just what it takes to build something that can sustain component failures and keep functioning.
So no matter whether your systems are cloud resident, on-premises or hybrid we will look at how you can make sure they work as planned.
SessionID: 38706
Distributed Replay: Testing With Your Data, Your Way!
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Tuning
Speaker: Melody Zacharias
Title: Distributed Replay: Testing With Your Data, Your Way!
Abstract:
SessionID: 38865
Hyper-V for SQL Server Virtualization
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Development
Speaker: Allan Hirt
Title: Hyper-V for SQL Server Virtualization
Abstract:
SessionID: 39060
Datazen - An overview
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Business Intelligence
Speaker: Frank Geisler
Title: Datazen - An overview
Abstract:
SessionID: 40004
Introduction to Microsoft Azure DocumentDB
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Features
Speaker: Jeff Renz
Title: Introduction to Microsoft Azure DocumentDB
Abstract:
This session demonstrates how to create a DocumentDB instance in Azure, work with JSON documents, create ad hoc queries with familiar SQL syntax, and create application logic as stored procedures, triggers, and user defined functions (UDFs), using standard JavaScript.
SessionID: 40427
Event Date: 24-10-2015 - Session time: 11:45:00 - Track: Admin
Speaker: Julie Koesmarno
Abstract:
SessionID: 39472
RED GATE: Automating Your Database Deployments
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Architecture
Speaker: Grant Fritchey
Title: RED GATE: Automating Your Database Deployments
Abstract:
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
SessionID: 40231
SANDISK: Flash and SQL Server—Re-Thinking Best Practices
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: J May
Title: SANDISK: Flash and SQL Server—Re-Thinking Best Practices
Abstract:
SessionID: 40332
WHERESCAPE: Data Warehouse Automation with WhereScape
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Business Intelligence
Speaker: Douglas Barrett
Title: WHERESCAPE: Data Warehouse Automation with WhereScape
Abstract:
This session is an introduction to data warehouse automation with WhereScape - come and learn how far can automation go in building documenting your data warehouse. Hand coding can all but be eliminated.
This session will include a demonstration of WhereScape 3D RED - data warehouse automation tools – building high quality data warehouses leveraging the native features of SQLServer (2008- 2014). RED is used by very large companies around the world - to small/medium sized ones, accelerating delivery and documentation. No other toolset can beat it. Better than that though is engagement with business units during development, ensuring that the data warehouse development is correctly prioritized, relevant and up to date.
SessionID: 41507
PROFISEE: Accelerate SQL Server Master Data Services with Profisee Maestro
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Business Intelligence
Speaker: John McAllister
Title: PROFISEE: Accelerate SQL Server Master Data Services with Profisee Maestro
Abstract:
SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners. Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users.
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: 41635
DH2i: Stand-alone to High-Availability Clusters in Minutes
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: OJ Ngo
Title: DH2i: Stand-alone to High-Availability Clusters in Minutes
Abstract:
SessionID: 41648
CISCO: Lowering IT Complexity, Addressing SQL Server Management C
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: John McAbel
Title: CISCO: Lowering IT Complexity, Addressing SQL Server Management C
Abstract:
SessionID: 41657
PERNIXDATA: 'Leveraging In-Memory Computing Underneath Virtual SQ
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: David Klee
Title: PERNIXDATA: 'Leveraging In-Memory Computing Underneath Virtual SQ
Abstract:
In-memory computing is gaining widespread acceptance as a way to speed database performance by moving hot data into main memory. But, In-memory solutions tend to be limited in functionality, lack scalability, are cumbersome to deploy and configure, and are extremely expensive.
PernixData FVP solves these challenges by turning in-memory computing into an infrastructure layer solution that benefits all virtualized applications. SQL Server plays exceptionally well with FVP. Come learn more about this exciting technology today!
SessionID: 41665
Moving Beyond Unconscious Bias
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: Misc Speakers
Title: Moving Beyond Unconscious Bias
Abstract:
People love patterns. We simplify our lives by categorizing all day long – things, activities, and even people. Categories let us make sense of a constant bombardment of sensations. But what happens when we unconsciously categorize someone at work? How do these categories box us in? Let’s talk about what we can do to shake up those categories and drive towards a more diverse and productive workplace.
SessionID: 41683
MICROSOFT: SQL Server Stretch Database
Event Date: 24-10-2015 - Session time: 13:15:00 - Track: Admin
Speaker: Anthony van Gemert
Title: MICROSOFT: SQL Server Stretch Database
Abstract:
Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries.
Come find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!
SessionID: 37171
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Tuning
Speaker: Prakash Heda
Abstract:
While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!
In this session, Prakash walks you through with scenario demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
SessionID: 37510
Optimizing desktop Power Pivot models using Power Query
Event Date: 24-10-2015 - Session time: 14:15: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: 38454
Reliable data consistency with constraints and access layers
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Development
Speaker: Uwe Ricken
Title: Reliable data consistency with constraints and access layers
Abstract:
This session demonstrates the usage of database core concepts for data modelling which prevents data manipulation from outside (application / direct). By usage of constraints, schemas and reusable data layers your data model becomes more reliable.
Control data access by using dedicated access methods with stored procedures and Views. This session demonstrates with two small independent applications the topic of reusability of common database objects.
SessionID: 38669
PowerShell for Absolute Beginnners
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: PowerShell
Speaker: Michael Wells
Title: PowerShell for Absolute Beginnners
Abstract:
Have you wanted to learn PowerShell, but didn't know where to start? Have you been scared off by all the pipes and curly braces, or maybe you're just not sure what PowerShell can do for you? This session will teach you the very basics of PowerShell and give you the fundamentals you need to start writing your own scripts and functions. You'll also get a list of resources to continue learning and take your skills to the next level.
SessionID: 38735
Enterprise Auditing with SQL Server Audit
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Features
Speaker: Colleen Morrow
Title: Enterprise Auditing with SQL Server Audit
Abstract:
In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options.
Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly.
SessionID: 39202
Top 5 SQL Server 2016 Hybrid Cloud Features
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Architecture
Speaker: Scott Klein
Title: Top 5 SQL Server 2016 Hybrid Cloud Features
Abstract:
Microsoft SQL Server 2016 builds on the awesome hybrid capabilities in SQL Server 2014 which simplify cloud adoption and help you unlock new hybrid scenarios. Building on this momentum, this demo-filled session will highlight these features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud to provide new disaster recovery and backup solutions. In this session we will look at 5 great hybrid scenarios that are made possible by both great new features as well as enhanced features of SQL Server 2016. We’ll not only look how to use and implement these hybrid features, but also look at look at and discuss scenarios around why you would use these hybrid cloud features to expand your on-premises options without adding complexity. We’ll look at how you can easily move workloads from your datacenter to Windows Azure while still maintaining a complete view of your infrastructure with increased proficiency.
SessionID: 39380
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Reporting Services
Speaker: Gabi Münster
Abstract:
SessionID: 40174
SQL Server Storage Engine under the hood
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Admin
Speaker: Thomas Grohser
Title: SQL Server Storage Engine under the hood
Abstract:
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements. SQL Server uses a series of different IO patterns depending on the workload. This session looks at them one by one and shows the difference and how to best optimize for it.
Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.
#160;
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
SessionID: 41506
Event Date: 24-10-2015 - Session time: 14:15:00 - Track: Features
Speaker: Misc Speakers
Abstract:
SessionID: 38373
The DBA with his Head in the Clouds
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Admin
Speaker: Martin Cairney
Title: The DBA with his Head in the Clouds
Abstract:
With Azure data centres located round the globe, will your company be looking more at cloud options? The Azure VM approach doesn't change your day to day role much, but Azure SQL Database certainly does.
In this session we will compare the core features of Azure SQL Database against SQL Server in an Azure VM, including the limitations and how to create, access and configure it. We'll then compare scaling-up and scaling-out and the change in perspective that a DBA needs to manage a mixed environment. Finally, we'll look at some of the DBA activities that are still needed on Azure SQL Database and how these can be achieved easily.
SessionID: 38377
SQL Server Security Basics
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Reporting Services
Speaker: Bob Pusateri
Title: SQL Server Security Basics
Abstract:
The past few years seem to have had more than their fair share of high-profile data breaches, not all of which were caused by sophisticated hacking attempts. This session explains basic methods for securing your SQL Server by making sure you're not leaving the proverbial front door unlocked (or in some cases, wide open). We will discuss the different levels and methods that can be used for granting and restricting rights, as well as the pros and cons of each. You learn steps you can take to design databases with securability in mind from the beginning, so that you can better protect your data later. We also demonstrate scripts that can help audit user rights and make sure logins don't have any more permissions than they need. Security doesn't need to be scary! Attend this session and gain a solid foundation on which to build your DBA career.
SessionID: 38481
Power BI is Awesome!
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Business Intelligence
Speaker: Steve Wake
Title: Power BI is Awesome!
Abstract:
SessionID: 39227
Treating Tables Like Legos, Partitioning Basics
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Architecture
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!
Partitioning allows us to break a table or index down into smaller more manageable chunks. Partitioning can enable us to perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations.
In this 75 minute session we’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll look at how partitioning effects things under the hood to solidify our understanding of how it works. At the end of this session you’ll have a firm understanding of partitioning and be armed with the knowledge needed to make decisions on how and when to implement partitioning.
SessionID: 39434
SSRS 101 – Creating Reports For Diagnostic Data
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Reporting Services
Speaker: Mickey Stuewe
Title: SSRS 101 – Creating Reports For Diagnostic Data
Abstract:
SessionID: 40254
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Tuning
Speaker: Hugo Kornelis
Abstract:
What to do? Blaming SQL Server is a good start, but won’t solve the problems. You can of course hire a database consultant to make all your performance problems (and all your money) disappear - but why not first take a look yourself?
This session will show you seven simple things, that might alleviate most of your database related performance problems. Use these tricks at your workplace, and you can be the hero of the department!
SessionID: 40422
Beginning Automation with Powershell
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: PowerShell
Speaker: Amy Herold
Title: Beginning Automation with Powershell
Abstract:
SessionID: 40431
The TSQL Review for the Busy Data Professional
Event Date: 24-10-2015 - Session time: 15:30:00 - Track: Development
Speaker: Carlos L Chacon
Title: The TSQL Review for the Busy Data Professional
Abstract:
How does the way I write my query affect the way data gets returned to me? If I use an inner join here, how does that affect my results? This session will review some of the ways we write queries and how these decisions affect us. We will also review database design concepts and how our architecture can influence our ability to make data available to users.
SessionID: 37981
Row-level Security in SSRS and SSAS
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Business Intelligence
Speaker: Chris Hyde
Title: Row-level Security in SSRS and SSAS
Abstract:
It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.
SessionID: 38092
Execution Plans for Mere Mortals
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Tuning
Speaker: Mike Lawell
Title: Execution Plans for Mere Mortals
Abstract:
As a beginner database professional, execution plans are intimidating. In this session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.
You will understand how, why and when the execution plan will be created and saved to plan cache.
Reading the execution plan will be much less intimidating as we walk through the flow and process of a graphical execution plan.
After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance tuning opportunities.
Finally, you will be able to capture the execution plan, save it for analysis and comparison after modifications have occurred.
SessionID: 38194
You did WHAT to my transaction log?!
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Admin
Speaker: Tony Davis
Title: You did WHAT to my transaction log?!
Abstract:
You won't believe what people will do to the transaction log when they get into trouble. The log is full! The application is experiencing strange errors! Do something! In this session, I will apply commonly suggested advice from internet search results and various forums, in search of a fast remedy for explosive log growth. How bad could it be?!
I will illustrate with simple graphics exactly what's in the transaction log, and why it is fundamental to SQL Server's ability to ensure that the associated database is always in a consistent state. I will explain the factors that can prevent reuse of log space and how to tackle the root causes of rapid log growth, rather than simply alleviating the symptoms using dangerous quick fixes. I'll also offer tips on how to avoid excessive logging becoming a bottleneck, and affecting the performance of user transactions.
SessionID: 38637
The Reporting Machine!
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Reporting Services
Speaker: Tillmann Eitelberg
Title: The Reporting Machine!
Abstract:
In this demo based session, we will give you a complete overview into a customer project, where we used SSIS, SSRS and MDS to do exactly that.
You will see, how we:
- import statistical data with R and SSIS
- stuck report parts together, to get complete reports with almost 100 pages
- define themes for different corporate designs
- define languages for different reports
- render the reports with different rendering extensions
- developing Office add-ins to automate SSIS, SSRS and MDS
SessionID: 38770
PowerShell and the Art of SQL Server Deployment
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: PowerShell
Speaker: Michael Fal
Title: PowerShell and the Art of SQL Server Deployment
Abstract:
SessionID: 39028
Understanding Solving Columnstore Problems
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Features
Speaker: Niko Neugebauer
Title: Understanding Solving Columnstore Problems
Abstract:
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode Query Processing with another depth.
Can you make your Columnstore queries ran even faster ?
Can you actually lower the Degree of Parallelism and get a better performance ?
How much memory does Columnstore Index actually use when working with queries ?
How can you test your Columnstore queries in Row Mode and what is the actual difference between Row Batch Modes.
The answers on those questions are to be revealed at this session.
SessionID: 39233
Using DevOps to replace a culture of FearOps
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Development
Speaker: Martin Catherall
Title: Using DevOps to replace a culture of FearOps
Abstract:
DevOps is about aligning SQL Server DBAs and Development teams to utilize agile methodologies and continuous improvement to optimize application rollouts.
Hamish Watson and Martin Catherall will discuss how to break down the silos that may exist between the teams and remove “FearOps” to improve the quality and maximize the uptime of deployed applications.
DevOps methodologies can help teams to respond faster to competitive pressures by replacing error prone (human) processes with automation for improved traceability and repeatable deployments.
Hamish has over 16 years’ experience in Enterprise Systems Management and 10 years in deploying and managing SQL Server.
He has incorporated DevOps methodologies over the past 5 years in assisting his small team of operations consultants to manage over 2,400 applications running across 400+ servers both on premise and in a hybrid cloud.
Martin is an SQL Server MVP, C# developer and SQL DBA and is also a PASS Regional Mentor for
SessionID: 39839
What you're missing out on if you're not using Master Data Services
Event Date: 24-10-2015 - Session time: 16:45:00 - Track: Architecture
Speaker: Steve Moss
Title: What you're missing out on if you're not using Master Data Services
Abstract:
Even if you don’t have a full-fledged Master Data project, there are use cases where SQL Server Master Data Services brings helpful tools to the table. For example, if you have data in Excel that your business wants to manage for compliance and/or wants to integrate, or have a requirement to augment data in a data warehouse dimension (such as adding and maintaining an attribute or grouping that isn’t present in the upstream system), MDS has functionality that can help you solve the problem.
This presentation will outline some of the core MDS functionality and will provide detailed walk-throughs of functionality used to solve business problems using MDS.