Nr: 364
SQLSaturday #364 - Boston 2015
SessionID: 10699
Introduction to SQL Server - Part 1
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Introduction to SQL Server
Speaker: Brandon Leach
Title: Introduction to SQL Server - Part 1
Abstract:
SessionID: 10747
Watch Brent Tune Queries
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Performance Tuning
Speaker: Brent Ozar
Title: Watch Brent Tune Queries
Abstract:
You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.
SessionID: 17728
Introduction to Powershell for DBA's
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Database Administration
Speaker: John Sterrett
Title: Introduction to Powershell for DBA's
Abstract:
Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.
SessionID: 21684
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Database Administration
Speaker: Paresh Motiwala
Abstract:
Over the past many years, I have only come across very limited DBAs who actually openly admit use of third party tools that make their lives easier. Otherwise most DBAs find pleasure in writing complex queries to do routine stuff like backups, maintenance, monitoring; you name it.
I would like to share my experience as a DBA, where I have used tools unashamedly to improve my productivity.
Hopefuly after this session, you will find the same confidence in using third party tools. Then, use the time saved, to enhance your carreer.
SessionID: 9138
The future of the data professional
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Professional Development
Speaker: Adam Jorgensen
Title: The future of the data professional
Abstract:
The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA's, BI Developers, and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path.
SessionID: 9272
So You Want To Be A Consultant?
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Professional Development
Speaker: Allan Hirt
Title: So You Want To Be A Consultant?
Abstract:
The world of consulting can be rewarding on various levels. People often think they have the right stuff to be a consultant, but do you? Would you need to work for an agency or company that sells consulting services or could you strike out on your own? Or are you always going to be someone who needs to be a full time employee with a set schedule? What are the things you need to know if this is your ultimately succeed if this is your career path? Becoming a consultant is more than having the right technical skills. This session will cover the highs, lows, and realities of what it takes to be a successful consultant based on my experiences and those of my colleagues over the years.
SessionID: 9549
Hacking the SSIS 2012 Catalog
Event Date: 18-04-2015 - Session time: 09:45:00 - Track: Integration and SSIS
Speaker: Andy Leonard
Title: Hacking the SSIS 2012 Catalog
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!
SessionID: 10700
Introduction to SQL Server - Part 2
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Introduction to SQL Server
Speaker: Brandon Leach
Title: Introduction to SQL Server - Part 2
Abstract:
SessionID: 11293
Hacking Exposé - Using SSL to Protect SQL Connections
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Database Administration
Speaker: Chris Bell
Title: Hacking Exposé - Using SSL to Protect SQL Connections
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
SessionID: 16592
Leaving the Windows Open
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Application Development
Speaker: Jeremiah Peschka
Title: Leaving the Windows Open
Abstract:
Computing running totals, averages by state or group, and other complex aggregations are not easy to implement in many relational databases. Thankfully, many relational databases include support for window functions. Window functions are an extension to the ANSI SQL standard. More than just another part of SQL, window functions enable complex ranking, ordering, and other aggregations over a subset of rows in a query. Understanding the capabilities of window functions lets you extend application functionality, build rich and complex queries, and reduce overhead in the application tier.
SessionID: 21810
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Integration and SSIS
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 26132
Establishing a SLA
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Non Technical
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.
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: 27639
The Restore Cookbook
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Database Administration
Speaker: Warner Chaves
Title: The Restore Cookbook
Abstract:
How do you restore a database that has lost a file? How do you recover from a lost transaction log? How do you get rid of corruption in the fastest time?
At some point in time, these and other destructive scenarios will happen to your databases. And people will look at you and expect you to react swiftly and confidently.
Come see the scenarios and demos so you'll be prepared with the right ingredients to cook up your RESTORE recipe!
SessionID: 9274
Is That A Failover Cluster On Your Laptop/Desktop?
Event Date: 18-04-2015 - Session time: 11:00:00 - Track: Database Administration
Speaker: Allan Hirt
Title: Is That A Failover Cluster On Your Laptop/Desktop?
Abstract:
This session will demystify the "magic" behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V, and show how to configure things like the virtual machines, the domain controller, and the storage solution.
SessionID: 35995
Auto generating a process data warehouse using Effektor
Event Date: 18-04-2015 - Session time: 12:00:00 - Track: Sponsor Spotlights
Speaker: Kennie Pontoppidan
Title: Auto generating a process data warehouse using Effektor
Abstract:
SessionID: 11169
Standalone to High-Availability Clusters over Lunch—with Time to Spare
Event Date: 18-04-2015 - Session time: 12:30:00 - Track: Sponsor Spotlights
Speaker: Carl Berglund
Title: Standalone to High-Availability Clusters over Lunch—with Time to Spare
Abstract:
SessionID: 14006
Clusters Your Way: #SANLess Clusters for Physical, Virtual, and Cloud Environments
Event Date: 18-04-2015 - Session time: 12:30:00 - Track: Sponsor Spotlights
Speaker: SIOS Technology
Title: Clusters Your Way: #SANLess Clusters for Physical, Virtual, and Cloud Environments
Abstract:
Clustered implementations of SQL Server instances (FCIs) have traditionally used some sort of attached, or shared storage. However, sometimes that is not the best way to deploy an FCI, especially if you are looking to deploy in the cloud-be it Windows Azure or Amazon EC2. Sometimes you may even want a cost-effective disaster recovery solution without the need for SAN replication. Come hear Microsoft Cluster MVP Allan Hirt discuss your storage options to not only create a #SANLess cluster, but also to increase the availability of your SQL Server instances using SSD and flash-based PCIe storage or the cloud.
SessionID: 24007
Faster, Better Decisions with Self Service Business Analytics
Event Date: 18-04-2015 - Session time: 12:30:00 - Track: Sponsor Spotlights
Speaker: Sayed Saeed
Title: Faster, Better Decisions with Self Service Business Analytics
Abstract:
SessionID: 35939
Optimal Infrastructure Strategies for Cisco UCS, Nexus and SQL Server
Event Date: 18-04-2015 - Session time: 12:30:00 - Track: Sponsor Spotlights
Speaker: Kevin Schenega
Title: Optimal Infrastructure Strategies for Cisco UCS, Nexus and SQL Server
Abstract:
SessionID: 14552
SQL Server AlwaysOn Availability Groups
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Database Administration
Speaker: George Walters
Title: SQL Server AlwaysOn Availability Groups
Abstract:
Need HA and DR? Tired of Mirroring or Log Shipping restrictions? Reporting queries slowing down your production system? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.
SessionID: 17727
Automate your daily checklist with PBM and CMS
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Database Administration
Speaker: John Sterrett
Title: Automate your daily checklist with PBM and CMS
Abstract:
This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.
SessionID: 18360
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Kevin Goff
Abstract:
You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.
SessionID: 20442
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Database Administration
Speaker: Mike Walsh
Abstract:
SessionID: 23557
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Database Administration
Speaker: Robert Pearl
Abstract:
SessionID: 24738
Reduce, Reuse, Recycle: Automating Your BI Framework
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Stacia Varga
Title: Reduce, Reuse, Recycle: Automating Your BI Framework
Abstract:
Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.
SessionID: 25597
An introduction to Data Mining
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Application Development
Speaker: Steve Simon
Title: An introduction to Data Mining
Abstract:
With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
-
Defining what questions we want answered and how to go about this in an effective and efficient manner.
-
Creating the data model.
-
How to gather the necessary data, discussing the training and testing aspect.
-
Processing the model.
-
Extracting information from our finished model, discussing the implications of this information.
SessionID: 8928
T-SQL : Bad Habits Best Practices
Event Date: 18-04-2015 - Session time: 13:30:00 - Track: Application Development
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits Best Practices
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
SessionID: 10883
Using Extended Events in SQL Server
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 11862
Tired of the CRUD? Automate it!
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Application Development
Speaker: Jack Corbett
Title: Tired of the CRUD? Automate it!
Abstract:
After this session you will:
- Understand the basics of T4 templating
- Have a basic understanding of the Dac object model
- Be able to create a script that will create 100's or even 1000's of CRUD procedures in seconds.
SessionID: 12404
Highly Available SQL Server in Windows Azure IaaS
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: David Bermingham
Title: Highly Available SQL Server in Windows Azure IaaS
Abstract:
Thinking about making a move to the Azure cloud? This session will give a basic overview of the Azure IaaS service before doing a deep dive into explaining exactly what it takes to make sure your SQL Server deployments in the cloud are highly available.
SessionID: 15609
What is it like to work for Microsoft?
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Professional Development
Speaker: James Serra
Title: What is it like to work for Microsoft?
Abstract:
James has worked at Microsoft for the past year. Before that, he was an independent consultant as well as having worked as a permanent employee and contractor and numerous companies. What is different about Microsoft? What is it like to see how things work "behind the curtain"? How does it compare to what he anticipated it to be like? Come join this session to find out more working for Microsoft: benefits, compensation, training, career advancement, work-life balance, travel, types of jobs, etc. We will leave plenty of time to ask questions!
SessionID: 16231
Becoming a Top DBA--Learning Automation in SQL Server
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: Joseph D'Antoni
Title: Becoming a Top DBA--Learning Automation in SQL Server
Abstract:
Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
• Fully Automating SQL Server Installations
• Dynamically Adding Databases to an Availability Group
• Syncing jobs and logins between Availability Group members
• Patching SQL Servers automatically
• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
SessionID: 16741
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Application Development
Speaker: John Flannery
Abstract:
SessionID: 20441
Never Have to Say "Mayday!!!" Again
Event Date: 18-04-2015 - Session time: 14:45:00 - Track: Database Administration
Speaker: Mike Walsh
Title: Never Have to Say "Mayday!!!" Again
Abstract:
December 1978: 10 people die in a commercial airliner. Why? Bad troubleshooting skills and poor maintenance – disaster-causing attitudes. As you'll learn in this session, the doomed airliner ran out of fuel while the crew of three wasted time troubleshooting a false alarm. We can draw some parallels in the database world. Poor troubleshooting, disaster-causing attitudes, and a lack of disaster preparedness lead to needless downtime and serious user impact across our environments.
In this session, we'll look at case studies of real-life aviation disasters and production database downtime incidents. We'll see similarities in attitudes that cause disasters. Come learn about the importance of preparation, troubleshooting, and teamwork. This will be an interactive session where we’ll pick apart disasters, engage in discussion around case studies, and leave prepared to change attitudes in ourselves and our colleagues and avoid disasters at work.
SessionID: 13872
Query Optimization Crash Course
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Performance Tuning
Speaker: Edward Pollack
Title: Query Optimization Crash Course
Abstract:
Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?
This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
SessionID: 14414
Dealing With Difficult People
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Professional Development
Speaker: Gigi Bell
Title: Dealing With Difficult People
Abstract:
John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
SessionID: 14784
Execution Plans: What Can You Do With Them?
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Performance Tuning
Speaker: Grant Fritchey
Title: Execution Plans: What Can You Do With Them?
Abstract:
SessionID: 14981
Stress testing SQL Server
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Application Development
Speaker: Hilary Cotter
Title: Stress testing SQL Server
Abstract:
SessionID: 15518
Table partitioning for Azure SQL Databases
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Database Administration
Speaker: John Miner
Title: Table partitioning for Azure SQL Databases
Abstract:
Abstract:
The newest version of Azure SQL Database is currently in preview.
Table partitioning has been added to this offering to replace Azure federations.
Do you know how to effectively leverage this new feature for data warehousing?
Coverage:
1 - Various editions of Azure SQL database.
2 - How Service objective relates to performance.
3 - Difference between horizontal and vertical partitioning.
3 - Table / Index partitioning in Azure SQL database.
4 - A review of MERGE, SPLIT and SWITCH statements.
5 - Implementing a sliding window.
6 - Introduction to data compression.
7 - Difference between ROW and PAGE compression.
8 - Adding compression to partitions to reduce space.
9 - Review findings from performance tests.
SessionID: 20237
Database Virtualization and Drinking out of the Fire Hose
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Database Administration
Speaker: Michael Corey
Title: Database Virtualization and Drinking out of the Fire Hose
Abstract:
A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.
SessionID: 25883
Balanced Scorecards using SSRS
Event Date: 18-04-2015 - Session time: 16:00:00 - Track: Business Intelligence
Speaker: Sunil Kadimdiwan
Title: Balanced Scorecards using SSRS
Abstract:
Scorecards allow company executives and management teams monitor their progress against key metrics. These metrics could be financial, customer, internal business operations etc. In this session, I will show you to utilize SSRS to develop balanced scorecards.