Nr: 217
SQLSaturday #217 - Columbus 2013
SessionID: 10021
PowerShell 101 for the SQL Server DBA
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Administration
Speaker: Allen White
Title: PowerShell 101 for the SQL Server DBA
Abstract:
The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.
SessionID: 10022
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Performance
Speaker: Allen White
Abstract:
SessionID: 11124
Up and Running with SSIS
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: SQL Development
Speaker: Julie Smith
Title: Up and Running with SSIS
Abstract:
This presentation is for absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour! List of scary acronyms and terms on the list for “demystification”: SSIS, BIDS, ETL, Configurations, Package Deployment, Package Execution, SQL Server Agent.
SessionID: 11764
SQL Audit - auditing doesn't have to be boring
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Administration
Speaker: Colleen Morrow
Title: SQL Audit - auditing doesn't have to be boring
Abstract:
Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.
SessionID: 11765
Quest for the Holy Grail of SQL Server Auditing
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Administration
Speaker: Colleen Morrow
Title: Quest for the Holy Grail of SQL Server Auditing
Abstract:
When and how was this view changed? Where did that index go? Who's accessing my sensitive data? In this demo-heavy session, we'll explore various methods of auditing events in SQL Server, how they work, and the inherent strengths and shortcomings of each in an epic quest to find the perfect SQL Server auditing solution.
SessionID: 13938
Making the Leap from Profiler to Extended Events
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Performance
Speaker: Erin Stellato
Title: Making the Leap from Profiler to Extended Events
Abstract:
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.
SessionID: 13939
Demystifying Database Statistics
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Administration
Speaker: Erin Stellato
Title: Demystifying Database Statistics
Abstract:
Database statistics are not made up numbers, like the statistics you may hear on TV or read in a news article. They are critical metadata used by SQL Server’s query optimizer. In this session, we will look at statistics from the ground up and remove the mystery that surrounds them. Demos and real-world examples will be used to explain what statistics are, why you should care about them, and what you can control. By the end of the session, you will understand: • How to view statistics and interpret the histogram • How and when to update statistics • How statistics affect the query optimizer • When you can let SQL Server manage statistics, and when you need to step in
SessionID: 14192
What's In YOUR DB Wallet?
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Administration
Speaker: Kevin Feasel
Title: What's In YOUR DB Wallet?
Abstract:
When you have one SQL Server instance to maintain, you can give that instance plenty of TLC. When you have a hundred instances, many things which worked before simply will not scale, potentially leaving your databases in peril. The next step (after justifiable panic) is to give yourself a force multiplier to help you keep your sanity on the job--specifically, an administrative database. This session will give you an idea of what kinds of tools should go into an administrative database, as well as how to use this to collect important metrics for reporting and auditing. Audience participation from more advanced database administrators is encouraged: we want to find out what's in YOUR DB wallet.
SessionID: 15699
Extend Your Knowledge with Extended Events!
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Performance
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15701
Looney Tuner? No, there IS a method to my madness
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Performance
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 16586
Reporting in Production: A Hadoop Case Study
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jeremiah Peschka
Title: Reporting in Production: A Hadoop Case Study
Abstract:
SessionID: 16587
Much Ado About Hadoop
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jeremiah Peschka
Title: Much Ado About Hadoop
Abstract:
By now you've probably heard the words "Big Data" and "Hadoop", but you're not sure what they mean, much less how to get started. Maybe you're struggling with storing a lot of data, rapidly processing a huge volume of data, or maybe you're just curious. There are a bewildering array of options and use cases within the Hadoop ecosystem. Every day I help customers understand their data problems, understand where Hadoop fits into their environment, and determine how they can use Hadoop to solve their problem. This session provides an introduction to what Hadoop is, when it's appropriate to use Hadoop, and guidance on how to get started.
SessionID: 22661
SSIS Templates Can Make Your Life Easier
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: SQL Development
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: 23653
Creating an SSIS template using BIML
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Russel Loski
Title: Creating an SSIS template using BIML
Abstract:
When creating an SSIS package, it is best practice to follow some kind of template. The package configuration needs to be set up. Logging needs to be set up. The work that you do to set up this template is tedious at best.
In this session we will develop a template SSIS package using BIML. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.
We will create a package that has some specific connection strings. We will tie those connection strings to configuration settings. Then we will add custom logging. We will then build individual SSIS packages to copy a list of tables to their destination.
SessionID: 23848
14 New T-SQL Functions
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: SQL Development
Speaker: Sam Nasr
Title: 14 New T-SQL Functions
Abstract:
The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
SessionID: 23850
Full-Text Search in SQL 2012 with Custom Proximity
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: SQL Development
Speaker: Sam Nasr
Title: Full-Text Search in SQL 2012 with Custom Proximity
Abstract:
Custom proximity search is a new feature introduced in SQL Server 2012 Full-Text Search. It's facilitated using the NEAR operator, allowing it to be used in the CONTAINS predicate or CONTAINSTABLE function. The NEAR operator allows for searching words near each other. It also allows the user to specify the maximum number of non-search terms separating the first and last search terms in a match. In addition, an optional parameter can be used to specify an exact order match.
SessionID: 26178
Indexing Deep Dive
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Database Performance
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
SessionID: 26180
TSQL Road Less Traveled: MERGE
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: SQL Development
Speaker: Kevin Boles
Title: TSQL Road Less Traveled: MERGE
Abstract:
Yeah, it has an arcane syntax - but that is why we have templates and snippets! :-P Merge is a very powerful TSQL construct that can both simplify your code and help with some otherwise difficult maneuvers such as the classic "Upsert".
SessionID: 28083
Design and Implement BI like Edison!
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Design and Implement BI like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
SessionID: 28084
Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular
Event Date: 08-06-2013 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Possible Musics: Choosing between Analysis Services 2012 Multidimensional and Tabular
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models, developed by business users, to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.