Nr: 394
SQLSaturday #394 - Iowa City 2015
SessionID: 11141
Event Date: 30-05-2015 - Session time: 08:30:00 - Track: DBA - Architecture and Tools
Speaker: Chaitanya Khaladkar
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: 19855
Event Date: 30-05-2015 - Session time: 08:30:00 - Track: Database Development
Speaker: Matt Wigdahl
Abstract:
SessionID: 24885
Every Byte Counts: Why Your Data Type Choices Matter
Event Date: 30-05-2015 - Session time: 08:30:00 - Track: Database 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: 28143
Introducing Forensic Analytics with PowerPivot for Excel
Event Date: 30-05-2015 - Session time: 08:30:00 - Track: Self-Service BI
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: 35961
Using Extended Events in SQL Server
Event Date: 30-05-2015 - Session time: 08:30:00 - Track: DBA - Architecture and Tools
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 17541
Introduction to PowerShell for the DBA
Event Date: 30-05-2015 - Session time: 09:45:00 - Track: DBA - Architecture and Tools
Speaker: Joshuha Owen
Title: Introduction to PowerShell for the DBA
Abstract:
SessionID: 18459
WIT Panel
Event Date: 30-05-2015 - Session time: 09:45:00 - Track: Personal Development
Speaker: Kathi Kellenberger
Title: WIT Panel
Abstract:
SessionID: 37617
Event Date: 30-05-2015 - Session time: 09:45:00 - Track: Enterprise BI
Speaker: Chaitanya Khaladkar
Abstract:
SessionID: 22806
Data Discovery with Power Query for Excel
Event Date: 30-05-2015 - Session time: 11:00:00 - Track: Self-Service BI
Speaker: Reeves Smith
Title: Data Discovery with Power Query for Excel
Abstract:
Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing.
This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
SessionID: 32355
An Introduction To Resource Governor in SQL Server
Event Date: 30-05-2015 - Session time: 11:00:00 - Track: DBA - Architecture and Tools
Speaker: Paul Timmerman
Title: An Introduction To Resource Governor in SQL Server
Abstract:
Do you have multiple databases with distinct workloads running on a single SQL Server Enterprise Edition instance? Have you ever had a runaway process or bad query from one system bring an entire instance to its knees, impacting a wide range of end users? If you answered yes to either of these questions, then come learn about Resource Governor for SQL Server. We’ll spend the first part of this introductory session going over the concepts you will need to know in order to implement Resource Governor successfully. Once we've covered the basics, we’ll spend the rest of the session working through a number of demos, reviewing exciting enhancements to Resource Governor in SQL Server 2014, and discussing scenarios in which you can use Resource Governor in your environment right away. Hardware resources are a valuable commodity. Learn how you can control them effectively in a multitenant environment, ensuring they are assigned where they need to be.
SessionID: 35607
TSQL Best Practices for SQL Engine Kindness
Event Date: 30-05-2015 - Session time: 11:00:00 - Track: Database Development
Speaker: Ben Miller
Title: TSQL Best Practices for SQL Engine Kindness
Abstract:
This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
SessionID: 35708
Strategies for SQL Server Index Analysis
Event Date: 30-05-2015 - Session time: 11:00:00 - Track: DBA - Troubleshooting and Performance Tuning
Speaker: Jason Strate
Title: Strategies for SQL Server Index Analysis
Abstract:
SessionID: 37304
Securing Microsoft SQL Server
Event Date: 30-05-2015 - Session time: 11:00:00 - Track: DBA - Architecture and Tools
Speaker: Rick Bielawski
Title: Securing Microsoft SQL Server
Abstract:
Having a good understanding what security features are available and what configurations are considered best practice can be crucial to your company's data security. My experience at many dozens of companies indicates that more than 90% of all database implementations don't follow some of the most fundamental best practices. Learn to view security differently and how key builtin security features can be leveraged to make your systems both more maintainable and more secure.
SessionID: 18458
Event Date: 30-05-2015 - Session time: 13:00:00 - Track: Database Development
Speaker: Kathi Kellenberger
Abstract:
SessionID: 24604
How to Determine What Data Is Corrupt
Event Date: 30-05-2015 - Session time: 13:00:00 - Track: DBA - Troubleshooting and Performance Tuning
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: 35653
The Many Paths of Consulting
Event Date: 30-05-2015 - Session time: 13:00:00 - Track: Personal Development
Speaker: David Klee
Title: The Many Paths of Consulting
Abstract:
People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.
This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.
SessionID: 35678
Power to the Prototypes: Using Power BI to Deliver Better SQL Reporting
Event Date: 30-05-2015 - Session time: 13:00:00 - Track: Self-Service BI
Speaker: Gina Meronek
Title: Power to the Prototypes: Using Power BI to Deliver Better SQL Reporting
Abstract:
SessionID: 35959
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 30-05-2015 - Session time: 13:00:00 - Track: Database Development
Speaker: Wayne Sheffield
Title: Table Vars and 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 represents 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: 22682
Mastering queries into XML data.
Event Date: 30-05-2015 - Session time: 14:15:00 - Track: Database Development
Speaker: Rick Bielawski
Title: Mastering queries into XML data.
Abstract:
If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this hour I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.
SessionID: 28142
Getting Started with Analysis Services 2012 Tabular
Event Date: 30-05-2015 - Session time: 14:15:00 - Track: Enterprise BI
Speaker: William E Pearson III
Title: Getting Started with Analysis Services 2012 Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
SessionID: 35670
Extending Your Availability Group for Disaster Recovery
Event Date: 30-05-2015 - Session time: 14:15:00 - Track: DBA - Architecture and Tools
Speaker: Ed Leighton-Dick
Title: Extending Your Availability Group for Disaster Recovery
Abstract:
Did you know that SQL Server Availability Groups can be a great solution for disaster recovery? Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup. Extending an availability group to multiple sites for disaster recovery becomes more complicated. A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration. In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
SessionID: 35706
Event Date: 30-05-2015 - Session time: 14:15:00 - Track: DBA - Architecture and Tools
Speaker: Jason Strate
Abstract:
SessionID: 35962
SQL Server Compression and what it can do for You
Event Date: 30-05-2015 - Session time: 14:15:00 - Track: DBA - Troubleshooting and Performance Tuning
Speaker: Jason Brimhall
Title: SQL Server Compression and what it can do for You
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: 12328
Event Date: 30-05-2015 - Session time: 15:30:00 - Track: DBA - Troubleshooting and Performance Tuning
Speaker: Dave Bland
Abstract:
SessionID: 21138
Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups
Event Date: 30-05-2015 - Session time: 15:30:00 - Track: DBA - Architecture and Tools
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: 22805
Increase your SSIS productivity with Biml
Event Date: 30-05-2015 - Session time: 15:30:00 - Track: Database Development
Speaker: Reeves Smith
Title: Increase your SSIS productivity with Biml
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
SessionID: 35608
PoShDBA: Practical PowerShell for the DBA
Event Date: 30-05-2015 - Session time: 15:30:00 - Track: DBA - Architecture and Tools
Speaker: Ben Miller
Title: PoShDBA: Practical PowerShell for the DBA
Abstract:
This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.
SessionID: 35652
Right-Sizing Your SQL Server Virtual Machine
Event Date: 30-05-2015 - Session time: 15:30:00 - Track: DBA - Architecture and Tools
Speaker: David Klee
Title: Right-Sizing Your SQL Server Virtual Machine
Abstract:
The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.