Nr: 250
SQLSaturday #250 - Pittsburgh 2013
SessionID: 11875
SSIS Olympics
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Cory Stevenson
Title: SSIS Olympics
Abstract:
SessionID: 12010
SQL Server for the accidental DBA
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Craig Purnell
Title: SQL Server for the accidental DBA
Abstract:
So the DBA quit and now you’re stuck running the database server. We will review the SQL Server stack for non-database professionals. Also, a discussion of some of the most critical things that developers will need to know when managing a SQL Server where there is no professional DBA to be found. Some tips on how and where to reach out for help with problems and questions, and common gotchas and problems you may see in the field.
SessionID: 12451
Do Some SOLR Searching with .NET
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: David Hoerster
Title: Do Some SOLR Searching with .NET
Abstract:
You've designed your application, built it up, and it's working great. One of the last features to implement is searching and reporting. You think you can get away with just implementing some SQL LIKE statements for an initial search, but you need to search across many fields or perform faceted searches. You've put it off because you really don't want to deal with SQL Server Full-Text Indexing - maybe it's not your cup of tea or maybe it's just intimidating or maybe you're not using SQL Server. But there are alternatives to Full-Text Indexing that can be just as powerful and fairly simple. SOLR is one such open source tool to help you with your application's searching needs. We'll take a look at the SOLR project, how you can get it up and running very easily, how you can install it as a Windows Service (as opposed to a command window), and how you can use SOLR.net to program against it. We'll look at basic searches along with some cool features like faceting.
SessionID: 12907
Mastering Date-Time Based Analysis in DAX
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Dan Clark
Title: Mastering Date-Time Based Analysis in DAX
Abstract:
SessionID: 13318
DBA 911 - Database Corruption
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 14654
Opening Remarks - Gina Walters Keynote - Rick Heiges presents Community and Cool Stuff!
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Title: Opening Remarks - Gina Walters Keynote - Rick Heiges presents Community and Cool Stuff!
Abstract:
Rick will discuss what resources are available in the SQL Community. In addition, Rick will focus on what is new in SQL 2014 - especially Hekaton and Buffer Pool Extension of SSDs.
SessionID: 16198
Virtualization for SQL DBAs
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Joseph D'Antoni
Title: Virtualization for SQL DBAs
Abstract:
Want to know about VMWare, Hyper-V and what they mean for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.
SessionID: 17721
Table Partitioning: the Secret Weapon for your Big Data Problems.
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: John Sterrett
Title: Table Partitioning: the Secret Weapon for your Big Data Problems.
Abstract:
Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
SessionID: 17723
Building Your First AlwaysOn Failover Cluster Instance
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: John Sterrett
Title: Building Your First AlwaysOn Failover Cluster Instance
Abstract:
SessionID: 18177
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Kevin Selinger
Abstract:
Monitoring Tools are not just nice to have but a means of understanding what is going on "Under the Hood".Success is a result of proper planning ,setting up the necessary processes to maintain continuity and most importantly participation is a key ingredient in achieving any level of success.Let's take a look at the 3 P process that I have employed over the past 15 years of implimenting Monitoring Tools in the IT industry.
SessionID: 18275
SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Goff
Title: SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Abstract:
In this presentation, I'll compare the new Tabular Model in SSAS 2012 with the more "traditional" multidimensional OLAP in SSAS. I'll show which of the 2 approaches works better in specific scenarios, and why you'd want to use one method over the other for certain applications. If you are trying to decide which approach to use, or if you are an experienced OLAP developer who wants to know the pros and cons of moving to the Tabular Model, this presenation is for you!
SessionID: 18278
T-SQL for Application Developers - Attendees chose
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 20 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 20 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 18537
Powershell for the beginner
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Ken McFerron
Title: Powershell for the beginner
Abstract:
PowerShell is everywhere. This session will go over the basics and getting more comfortable using the PowerShell console, ISE, and running scripts. We will start from the very basics and get on track to have you wanting to use PowerShell all the time to see what else can be done. The session is not directed to just DBAs but any IT pro that wants to learn PowerShell.
SessionID: 18546
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Konstantin Melamud
Abstract:
This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
SessionID: 18882
Fundamentals of reporting
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: Katie Vetter
Title: Fundamentals of reporting
Abstract:
Although this session is part of the "Wanna be a DBA?" track, it also serves those who "Wanna be a Business Intelligence Developer." We'll discuss the life cycle of data, how it relates to reporting, and learn how to create a simple SSRS (SQL Server Reporting Services) report.
SessionID: 19348
Putting it all together
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: Madhu Kudaravalli
Title: Putting it all together
Abstract:
What are the resources required to become a DBA -Training, certifications, self study, shadowing, mentoring. How to transition from knowledge to practice and learning on the job. The job market for a DBA- trends, salaries, shortage etc.
SessionID: 19349
Becoming a DBA prerequisites
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: Madhu Kudaravalli
Title: Becoming a DBA prerequisites
Abstract:
This session will cover the prerequisites for becoming a database professional. It will cover the various areas that a database professional can choose from- SQL Server developer, SQL Server Administrator, SQL report writer, ETL developer, Business Intelligence .
SessionID: 19350
Database Design fundamentals
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: Madhu Kudaravalli
Title: Database Design fundamentals
Abstract:
We will cover the fundamentals of an RDBMS and go over a basic database design session
SessionID: 19842
Closing Remarks by Gina Walters and Raffle
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Matt Nelson
Title: Closing Remarks by Gina Walters and Raffle
Abstract:
Closing Remarks and Raffle
SessionID: 19843
Basic Administration
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: Matt Nelson
Title: Basic Administration
Abstract:
SessionID: 19881
Automating in the Cloud
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Matt Velic
Title: Automating in the Cloud
Abstract:
We've heard all the awesome Cloud deployment stories, but DBAs can use the Cloud too! Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common administration problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture of both Azure and Amazon, as well as some specifics as to the components of the solution.
SessionID: 20646
Troubleshooting your TCP/IP connections
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Mike Hays
Title: Troubleshooting your TCP/IP connections
Abstract:
Database professionals are often challenged to troubleshoot why a user cannot connect to a SQL Server instance. Attend this session to learn the basics of how SQL Server listens for connections and how it uses its browser service. Also learn what utilities the Windows operating system offers to help you in troubleshooting those connection issues.
SessionID: 20953
Handling catch all or sometimes queries
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael John
Title: Handling catch all or sometimes queries
Abstract:
This session will provide a number of different ways to handle "sometimes" queries, and provide techniques to make these perform faster.
Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career.
SessionID: 21698
Basic Best Practices for SSIS Development
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Nate Locklin
Title: Basic Best Practices for SSIS Development
Abstract:
This session will cover several basic best practices that can be used when developing SSIS packages, including logging, checkpoints, and package configurations. These best practices will provide re-usability, assist with troubleshooting, and dramatically improve your ETL work.
SessionID: 22243
Surviving a Technical SQL Interview
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Reed Powell
Title: Surviving a Technical SQL Interview
Abstract:
At some point every SQL interview is going to get technical. This session will go through my favorite questions as an interviewer and talk about their overall relevance and answers. We'll talk about how to handle the situations where you aren't sure of the answer - or when you know that you don't know the answer The questions will cover database design, DBA, SSIS and SSRS aspects of SQL server. Pointers to resources will also be given.
SessionID: 22649
SSIS Templates Can Make Your Life Easier
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Brian Davis
Title: SSIS Templates Can Make Your Life Easier
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
SessionID: 22650
Goodbye Next Next Next, Hello Automated Installs
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 22971
Basic Monitoring with Perfmon
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Rick Heiges
Title: Basic Monitoring with Perfmon
Abstract:
SessionID: 24006
Faster, Better Decisions with Self Service Business Analytics
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Sayed Saeed
Title: Faster, Better Decisions with Self Service Business Analytics
Abstract:
SessionID: 24617
Flash 101 – An Introduction to Flash Storage for SQL Server and Data Centers
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Stephen LeRoy
Title: Flash 101 – An Introduction to Flash Storage for SQL Server and Data Centers
Abstract:
SessionID: 25800
Monitoring and Baselines
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Steve Hood
Title: Monitoring and Baselines
Abstract:
During an incident you can look at every stat in SQL Server, but if you don’t know what normal is for that specific server then they won’t be very useful to you. Also, outside of incidents, it’s very beneficial to know what your most expensive queries are for the month instead of since the last recompile, or seeing when your page life expectancy drops instead of just noticing it’s low. Without proactively monitoring SQL Server you’re making your job more difficult and less productive at the same time.
This will cover OS Perf Counters, Wait Stats, Traces, Blocking, Query Stats, Index Stats, Database Sizes and Table Sizes, all presented in a format of what you should be watching and how it will help you.
SessionID: 26220
SQL Injection
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 26712
Know Backups and Know Recovery
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
SessionID: 26714
It is TEMPDB, Why Should You Care?
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Radney
Title: It is TEMPDB, Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 28193
Fundamentals of querying
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 0 - Wanna be a DBA?
Speaker: William Wolf
Title: Fundamentals of querying
Abstract:
We will query the database that we just designed covering basic selects, joins, functions, aggregates etc.
SessionID: 9101
Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: A.J. Mee
Title: Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM
Abstract:
Remember the days when Analysis Services solely represented an OLAP engine? Are you unclear about when to still build cubes vs. invoke the new Tabular engine in SSAS? Do you feel confused about where the self-service capabilities of PowerPivot end and where enterprise BI begins? If you answered YES to any of those questions, please join A.J. Mee (Principal BI Specialist at Microsoft) for some practical, real-world guidance around the three modes of SQL Server Analysis Services. As with most of A.J.'s presentations, the vast majority of the time will be spent providing demonstrations of the technology. Both traditional (i.e. relational) and non-traditional (i.e. unstructured/semi-structured) data sources may be incorporated into the demonstrations.
SessionID: 9166
Agile Database Development
Event Date: 14-09-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Aaron King
Title: Agile Database Development
Abstract:
In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.