SQLSaturday #158 - New York City 2012

Event Date: 08/04/2012 00:00:00

Event Location:

Microsoft Offices Midtown Manhattan
1290 Avenue of the Americas
New York City, New York

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Microsoft’s Big Play for Big Data

Abstract: Big Data entails collecting and analyzing large volumes of data obtained from Web, social media, scientific and other pools of fast-growing event-driven data. Recently, Microsoft announced its Windows Server and Windows Azure implementations of Hadoop, the open source distributed processing engine widely used in Big Data implementations. And the plot thickens, as Microsoft also fits SQL Server business intelligence (BI) tools on top of Hadoop, to make the analysis part of Big Data work with familiar and accessible Microsoft technologies.

Come to this session to get an overview of Big Data, Hadoop and its integration with te Microsoft BI stack. See how your skills can be applied to this rapidly growing part of the industry.

Speaker(s):

Andrew Brust

Track and Room: Track 1 - N/A

Title: Surviving Your Peak Database Load

Abstract: Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these time frames is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.

Speaker(s):

Ben DeBow

Track and Room: Track 8 - N/A

Title: Mastering Date-Time Based Analysis in DAX

Abstract: A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them. This session is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them.

Speaker(s):

Dan Clark

Track and Room: Track 5 - N/A

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract: Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census” has written a series of white papers on record linkage and particular a technique called “Blocking Indexs”. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of “real world” examples(Code) and you will leave a master of record linkage and the concepts behind it

Speaker(s):

Ira Warren

Track and Room: Track 8 - N/A

Title: SQL Server 2012 Columnstore index

Abstract: It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I’ll also show how the new Batch execution mode can improve performance as well

Speaker(s):

Kevin Goff

Track and Room: Track 2 - N/A

Title: SQL Server Internals Architecture

Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - …and much more.

Speaker(s):

Kevin Kline

Track and Room: Track 1 - N/A

Title: Full Text Indexing Basics

Abstract: Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan. I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.

Speaker(s):

John Miner

Track and Room: Track 5 - N/A

Title: Programming T-SQL Enhancements in SQL Server 2012

Abstract: As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL). In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine. In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new windowing enhancements with the OVER clause, running and sliding aggregations, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session!

Speaker(s):

Leonard Lobel

Track and Room: Track 3 - N/A

Title: Introducing SQL Server Data Tools

Abstract: With the release of SQL Server 2012, the new SQL Server Data Tools serves as your primary development environment for building applications on top of SQL Server. SSDT plugs in to Visual Studio with tooling designed specifically for the application developer. With SSDT, developers no long need to constantly switch between VS and SSMS. In this session, Lenni demonstrates how SSDT is used to develop for (and deploy to) on-premise and SQL Azure databases. You will learn how to use code navigation, IntelliSense, and refactoring with your database model, and how to design databases offline and under source control right from VS. Don’t miss out on this demo-centric information-packed session on the next generation of database tools for developers!

Speaker(s):

Leonard Lobel

Track and Room: Track 3 - N/A

Title: Enriching Applications with SSAS Data Mining

Abstract: Data mining as a technology is designed to analyze large volumes of data looking for patterns that accurately predict behavior. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this presentation, you will be introduced to Microsoft SQL Server 2005 and 2008 Data Mining and demonstrations on how to develop data mining models that can be embedded into your applications. Demonstrations are based on SQL Server 2008 R2 Data Mining. This presentation is a must for any developer looking to embed “Artificial Intelligence” into their solution design to take their applications to the next level.

Speaker(s):

Peter Myers

Track and Room: Track 6 - N/A

Title: SQL 2012 Error Handling. Pick your Destiny

Abstract: Gone are all the spaghetti errors of past versions of SQL. For example did you know that BEGIN TRAN…COMMIT TRAN is not enough to make everything work together? People are often shocked when they see the demo in this talk where the first statement fails and all others statements still commit. This can still happen to you in SQL 2012 if you are not aware of the options. In fact did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action and control it. This is possible with or without structured error handling. See both ways to control the outcome to the way you want it.

Speaker(s):

Rick Morelan

Track and Room: Track 8 - N/A

Title: SQL Azure Scalability with Federations

Abstract: With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits.

Speaker(s):

Scott Klein

Track and Room: Track 1 - N/A

Title: Writing Faster Stored Procedures and Functions

Abstract: Stored procedures and functions are the mainstay of SQL Server coding. In this presentation you will learn techniques to locate problem code and to improve it’s performance. Step 1 is to discover where the time is going using server traces, code to analyzes the traces, and the new Extended Events. Once we know where the time is going we look at strategies to improve performance: Managing indexes on temp tables and why heaps are often the best choice for temp tables; determining if an index is helping; Rewriting scalar and multi-statement functions as inline functions and why it’s so important; mastering minimally logged operations and the “Go Faster” switch. Each technique is illustrated with examples

Speaker(s):

Andrew Novick

Track and Room: Track 7 - N/A

Title: Without A SQLTrace - Getting To Know Extended Even

Abstract: If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events.

Speaker(s):

AJ Mendo

Track and Room: Track 6 - N/A

Title: Know Backups and Know Recovery

Abstract: You say you have a backup strategy, but what is your recovery strategy?

In this session I will demonstrate several methods for performing much-needed backups and how to recover those backups to include FULL, DIFFERENTIAL, FILE GROUP, and TRANSACTION LOG. He will also demo performing a peace meal restore as well as backing up and restoring the tail end of the log after the data file becomes corrupt.

I will discuss industry best practices for backing up and recovering your data. The goal of this session is to educate you on the various backup strategies so you can decide which is best for your organization, demonstrate how to recover your databases, and to create the desire for you to go back and validate your current strategies

Speaker(s):

Tim Radney

Track and Room: Track 8 - N/A

Title: Real World Integration Services: Excel Spreadsheet

Abstract: You rarely hear of a data integration project that doesn’t involve a spreadsheet as a source document, a lookup reference, or an output. It’s the ambiguously ubiquitous container for business data because it’s so flexible and familiar to users. Unfortunately, the same features those business users crave tend to cause huge problems for data professionals.
In this session we’ll look at typical integration issues with Excel, explain why they occur, and show you more options than just the Excel Source or COM API. In a world where spreadsheets are the “database of choice” for business users, knowing how to get SSIS to interact reliably with Excel is an essential skill.

Speaker(s):

Todd McDermid

Track and Room: Track 5 - N/A

Title: SSAS 2012 Tabular vs. Multidimensional

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.

Speaker(s):

William E Pearson III

Track and Room: Track 7 - N/A

Title: Self-Managed BI with PowerPivot

Abstract: SQL Server 2012 PowerPivot will allow analysts to use Excel 2010 to load and prepare large volumes of data from various data sources to create a data model. The data model can then be enriched with calculations to become a data source for Excel PivotTable, PivotChart and CUBE function reports.

And as compelling as these BI experiences can be that’s not the end of the story. A PowerPivot workbook deployed to SharePoint Server 2010 can be used to create even more compelling BI experiences using Reporting Services and PerformancePoint Services.

In this presentation learn about the fundamentals of PowerPivot data model creation, and the exciting ways PowerPivot data models can be used to visualize and share data.

Speaker(s):

Peter Myers

Track and Room: Track 7 - N/A

Title: Get-PowerShell | Get-SQLServer

Abstract: PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).

Speaker(s):

SB Chatterjee

Track and Room: Track 1 - N/A

Title: Seven SQL Agent Jobs You Should be Running

Abstract: See those things around your ankles? You hope they’re your socks because no DBA wants to be caught with their pants down.

Whether you’re an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won’t buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what’s going on in your environment.

You’ll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You’ll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.

Speaker(s):

Mike Hillwig

Track and Room: Track 6 - N/A

Title: Running SQL Server on Solid State Drives

Abstract: Solid State Drives (SSD) are becoming one of the mainstream storage solutions, and many firms have started placing SQL Server database files on SSD in hope of gaining performance. However, how to best run SQL Server on SSD is not a settled question. Conflicting opinions abound. This session is packed with first-hand data points, sharing with you the results from a series of extensive performance tests on SSD, either with or without SQL Server. You will learn the basic performance characteristics of SSD, and what SQL Server/SSD configurations may give you best results.

Speaker(s):

Linchi Shea

Track and Room: Track 6 - N/A

Title: Much Ado about Indexes - Tips, Tricks and Tuning..

Abstract: In my session, I will offer some practical tips and tricks on a wide-array of Index Analysis methods that will allow you to find out everything about a client’s indexes and were afraid to ask! What better way to optimize the performance of the database than talk about their indexes. What do you need to know in order to make these suggestions, and implement them. This session will cover the basics on indexes, and then demonstrate ways to improve DB performance. Missing Indexes, Duplicate Indexes, Fragmented Indexes, Covering Indexes, Clustered Nonclustered indexes, and the queries that love them. I will also demo ways in which you can correlate the worst performing queries with missing indexes

Speaker(s):

Robert Pearl

Track and Room: Track 3 - N/A

Title: SQL Azure - What is it and why do I need it?

Abstract: This session will take an exploratory look at Microsoft’s cloud-based relational database offering. We’ll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We’ll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.

Speaker(s):

Scott Klein

Track and Room: Track 1 - N/A

Title: What’s Buried in the Plan Cache?

Abstract: Creating a query plan can be a time consuming and expensive process. To avoid repeating these costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed.

In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.

Speaker(s):

Christina Leo

Track and Room: Track 3 - N/A

Title: How Not to Be a Cranky DBA

Abstract: Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.

Speaker(s):

Mike Hillwig

Track and Room: Track 4 - N/A

Title: Performance Tuning SQL Server Integration Services

Abstract: In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server’s resourcing. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient.

Speaker(s):

Brian Knight

Track and Room: Track 2 - N/A

Title: SQL Server Dos and Don’ts: Keys to DBA Nirvana

Abstract: Bad Windows builds? No HA? No backups? SQL Server considered the non-mission critical platform yet you have hundreds of instances? Over the years I’ve seen most, if not all of, the good, bad, and ugly of being a SQL Server DBA from being both a full time employee as well as a consultant. If you want to skip 20 years of ups and downs, come to this session to hear how you can be a better DBA for your SQL Server deployments, avoid pitfalls, and hopefully laugh at a few of my misadventures over the course of my career.

Speaker(s):

Allan Hirt

Track and Room: Track 4 - N/A

Title: Data Cleansing with SSIS 2012

Abstract: In this session, you’ll learn how to cleanse your data and apply simple to complex business rules in SSIS. Learn how to solve complex data problems quickly in SSIS using Data Quality Services (DQS). The speaker will show you how to incorporate scripting into your SSIS data flow to find and fix bad data. Then he’ll show how to use advanced fuzzy logic to satisfy data duplication issues. Lastly, he’ll show you how to implement advanced data cleansing and normalization in SQL Server 2012 SSIS with DQS and MDS.

Speaker(s):

Brian Knight

Track and Room: Track 2 - N/A

Title: Replicaton Technologies

Abstract: Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha’s, and performance tuning and troubleshooting techniques.

Speaker(s):

Hilary Cotter

Track and Room: Track 5 - N/A

Title: Virtualizing Tier-1 SQL Server Databases On VMware

Abstract: An SQL Server database is resource-intensive by its very nature and one of the most resource-intensive Business Critical applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for Virtualizing SQL Server on VMware. Key Takeaway 1 Key Database Best Practices Key Takeaway 2 Common Mistakes How to Avoid Them Key Takeaway 3 Many resources available and where to find them

Speaker(s):

Michael Corey

Track and Room: Track 4 - N/A

Title: READPAST Furious-Transactions.Locking.Isolation.

Abstract: Do you really understand SQL Servers’ Concurrency behaviour? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ_UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare?

I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.

Speaker(s):

Mark Broadbent

Track and Room: Track 4 - N/A

Title: Alright,WHY is the server REALLY running so slow!

Abstract: SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI’s may be incorporated into the mix.

Speaker(s):

Steve Simon

Track and Room: Track 3 - N/A

Title: Temporal Fact Tables: The Road Less Traveled

Abstract: Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate.

In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations.

Speaker(s):

Martin Schoombee

Track and Room: Track 5 - N/A

Title: Team Management Fundamentals

Abstract: Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, conflict resolution skills, communication skills and project/job tracking skills. Attendees will also learn:

How to motivate a team and keep the members of that team focused and on task.
How to resolve conflicts, address performance problems, and handle project/job missteps.
How to gain support for your ideas, earn upper management support, and communicate with top management.

Speaker(s):

Kevin Kline

Track and Room: Track 7 - N/A

Title: Introduction to Data Quality Services

Abstract: Get an overview of the problem domain, architecture and solution space for Data Quality Services. See how Data Quality Services works hand-in-hand with Master Data Management to create master data, matching rules and leverage both to deduplicate data

Speaker(s):

Marc Jellinek

Track and Room: Track 6 - N/A

Title: But it worked great in Dev! Perfomance for Devs

Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

Speaker(s):

Randy Knight

Track and Room: Track 3 - N/A

Title: Deploying SQL Server 2012 Multi-site Clusters

Abstract: This is a demo-driven session that will focus on designing and implementing a multi-site, geographically dispersed SQL Server 2012 Failover Cluster instance across multiple data centers. We will cover the considerations on implementing such an architecture to address high availability and disaster recovery requirements for your mission-critical databases.

Speaker(s):

Edwin Sarmiento

Track and Room: Track 8 - N/A

Title: Shred SQL Server XML.

Abstract: Practical XML usage for SQL Server 2005 and up. Working examples how to load, create, and shred the XML using XPath query methods. The XML tips and tricks.

Speaker(s):

Alex Grinberg

Track and Room: Track 6 - N/A

Title: Real-Life SQL 2012 Availability Group Deployments

Abstract: You want to deploy AlwaysOn, but you’re concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he’s found in real-life deployments of AlwaysOn.

Speaker(s):

Brent Ozar

Track and Room: Track 2 - N/A

Title: Creating a Performance Baseline for SQL Server

Abstract: Creating a performance baseline for a SQL Server instance provides many benefits including defining a starting point for optimization efforts, documenting the server, a reference point for capacity planning, and providing a reference for ongoing performance comparison. This session will provide a detailed presentation of an approach for collecting, storing, and presenting performance metrics for use in developing a baseline performance assessment of a SQL Server instance.

Speaker(s):

Ron Johnson

Track and Room: Track 8 - N/A

Title: Hadoop and its Ecosystem Components in Action

Abstract: It’s one thing to have a high-level understanding of Big Data, Hadoop and MapReduce; it’s quite another to feel comfortable working with the tools. In this demo-heavy session, ZDNet Big Data blogger and Visual Studio magazine columnist Andrew Brust will take a look at actual MapReduce code and see Hadoop ecosystem components HBase, Hive, Pig and Mahout in action.

Speaker(s):

Andrew Brust

Track and Room: Track 4 - N/A

Title: Moves like Jagger - Upgrading to SQL Server 2012

Abstract: In this diverse session we will take an in-depth look at moving to the SQL 2012 platform and the upgrade strategies at your disposal. Specifically we will take a deep dive into preparing and reporting for upgrade, upgrade strategies, performing the upgrade and knowing the upgrade was successful.

This session will also look at several advanced scenarios such as migrating to SQL Server 2012 on Server Core, AlwaysOn Availability Groups and AlwaysOn Fail-over Clustered Instances.

Attend this must see session and you too can have the “Moves like Jagger”.

Speaker(s):

Mark Broadbent

Track and Room: Track 4 - N/A

Title: Slowly changing dimensions- an integrated approach

Abstract: There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension. In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services

Speaker(s):

Mark Stacey

Track and Room: Track 7 - N/A

Title: Building Faster SQL Servers

Abstract: SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we’re going to run out of memory to cache. In this session, we take a lesson from Microsoft’s blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he’s worked with in the field.

Speaker(s):

Brent Ozar

Track and Room: Track 2 - N/A

Title: Advanced Charting Techniques in SSRS

Abstract: SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will talk about the basic functionalities of all the charts as well as some tips and tricks around them. Come to this session and take your charting skills to the next level.

Speaker(s):

Jason Thomas

Track and Room: Track 7 - N/A

Title: Implementing SQL Server 2012 on Windows Server Cor

Abstract: SQL Server DBAs have relied so much on graphical user interface (GUI) to administer and manage database servers. So, why take away the GUI? If you’re more into using the command-line and PowerShell to manage your servers, come to this session to learn how to implement SQL Server 2012 on Windows Server Core

Speaker(s):

Edwin Sarmiento

Track and Room: Track 1 - N/A

Title: What’s new in SQL Server 2012 - from A to Z

Abstract: In this presentation, I’ll go through all the new features in SQL Server 2012. I won’t cover any one area heavily - the goal is just to identify (and in some cases, briefly show) as many new features as possible….from the new columnstore index, to T-SQL enhancements, to a greatly iimproved SSIS tool, to a new model for creating analytic databases, and more. SQL Server 2012 has a large amount of new functionality that helps all sorts of database developers. After this presentation, I can almost promise you’ll be VERY interested in upgrading to SQL Server 2012.

Speaker(s):

Kevin Goff

Track and Room: Track 2 - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Hilary Cotter

Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.

Hilary is also an author, or contributor on a number of books on SQL Server.

Brian Knight

Twitter: - @BrianKnight

Contact: http://www.bidn.com/people/brianknight

Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Christina Leo

Twitter: - christinaleo

Contact: http://christinaleo.net

Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.

Brian Knight

Twitter: - @BrianKnight

Contact: http://www.bidn.com/people/brianknight

Marc Jellinek

Contact: http://www.neudesic.com

Marc Jellinek is a Principal Consultant with Neudesic, focused on the Business Intelligence space. He has worked with every version of SQL Server since 6.0; with experience in leveraging the strengths of the relational database, Analysis Services, Integration Services and Reporting Services. He gained his experience working for Ernst Young, MLB Network and Microsoft.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

Linchi Shea

Twitter: - @linchi_shea

Contact: http://sqlblog.com/blogs/linchi_shea/

Mark Broadbent

Twitter: - retracement

LinkedIn: Mark Broadbent

Contact: http://tenbulls.co.uk

John Miner

Twitter: - JohnMiner3

LinkedIn: John Miner

Contact: http://www.craftydba.com

John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies.

Robert Pearl

Twitter: - @PearlKnows

LinkedIn: Robert Pearl

Contact: http://www.sqlservercentral.com/blogs/pearlknows/

Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Rick Morelan

Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Martin Schoombee

Twitter: - sqlmartin

LinkedIn: Martin Schoombee

Contact: http://www.martinschoombee.com

Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.

Mark Stacey

Twitter: - @MarkGStacey

Contact: http://MarkGStacey.net

Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies

Andrew Brust

Twitter: - andrewbrust

Contact: http://www.zdnet.com/blog/big-data

Andrew J. Brust is the Senior Director, Market Strategy and Intelligence at Datameer and writes a blog for ZDNet called quot;Big on Dataquot; (bit.ly/bigondata). Andrew is co-author of quot;Programming Microsoft SQL Server 2012quot; (Microsoft Press); an advisor to the NY Technology Council; serves as Microsoft Regional Director and MVP; is conference co-chair of Visual Studio Live!; and writes Visual Studio Magazine#39;s quot;Redmond Reviewquot; column.

Kevin Kline

Contact: http://KevinEKline.com

Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.

Peter Myers

Peter has 14 years of solid experience working in OLTP database design and Business Intelligence with SQL Server and SharePoint. In April 2012, Peter was awarded Microsoft MVP (Most Valuable Professional) for a sixth time. Peter enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server user group meetings and technical events, including TechEd in North America, Europe and Australia.

Alex Grinberg

LinkedIn: Alex Grinberg

I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book “XML and JSON Recipes for SQL Server”, also wrote number of articles for Simple-Talk and SQLServerCentral.com

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

Michael Corey

Twitter: - Michael_corey

LinkedIn: Michael Corey

Contact: http://michaelcorey.com/

Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael’s a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly

Ira Warren

Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Peter Myers

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

Andrew Brust

Twitter: - andrewbrust

Contact: http://www.zdnet.com/blog/big-data

Kevin Kline

Contact: http://KevinEKline.com

Edwin Sarmiento

Contact: http://bassplayerdoc.wordpress.com

Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”

Ron Johnson

Contact: http://rjssqlservernotes.wordpress.com/

A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.

Andrew Novick

LinkedIn: Andrew Novick

Contact: http://www.NovickSoftware.com

Andy Novick is a SQL Server MVP and consultant building business solutions with SQL Server. He has expertise in database design, T-SQL coding, SQL Server security, database performance tuning, partitioning, service broker, and database administration. Andy is a frequent speaker at local user group meetings and an author of two books on SQL Server.

SB Chatterjee

Contact: http://weblogs.asp.net/sbchatterjee/default.aspx

Architect/Tech-lead in Hartford CT with over 20 years IT experience. Worked at companies like Aetna, IBM, Microsoft, UNICEF, United Technologies and State of Connecticut. Holds graduate degrees in Computer Science, Business Administration and Economics. Awarded the Microsoft MVP Award for SharePoint products 2008 thru 2013. He is active in the SharePoint StackExchange and other forums. Twitter: @sbc111 Acting Director - CT.NET Dev Group (CTDOTNET) CT Dev Startups Group (CTDEVSTARTUP).

AJ Mendo

Twitter: - @SQLAJ

Contact: http://sqlaj.wordpress.com/

AJ has over 14 years of experience working with a variety of databases. He has worked for military, civilian, and federal government organizations supporting a wide variety of applications.

AJ is a frequent speaker at user groups, SQLSaturday#39;s, and PASS Virtual Chapters, and is a board member POSSE and CACTUSS. He is a PASS Programs Committee volunteer, and he loves being a part of the SQL Community.

Todd McDermid

Twitter: - @Todd_McDermid

LinkedIn: Todd McDermid

Contact: https://toddmcdermid.blogspot.com

Todd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd has been known to blog, forum troll, code open-source extensions, and present on BI topics across the continent.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Steve Simon

Contact: http://www.infogoldusa.com

Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Business Intelligence paper at Oracle Open World in San Francisco . Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor chair of the Oracle/SQL Server VC

Edwin Sarmiento

Contact: http://bassplayerdoc.wordpress.com

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Ben DeBow

Contact: http://www.sqlha.com/blog/

Ben DeBow is a MDCBA, MCSE and MCITP focused on SQL Server consolidations, data architecture and performance tuning for organizations both large and small. Ben specializes in solving diverse and complex data and infrastructure challenges for large, global environments. Ben is a longtime member of the SQL community, volunteering the last 8 years as a SQLPass committee member, trainer and SQLPass presenter. Besides his work as a consultant, Ben is a cyclist, avid traveler and photographer.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

Kevin Goff

Twitter: - @KevinSGoff

Contact: http://www.KevinSGoff.net

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP

Database architect/developer/speaker/author

Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

Frequent speaker at community events in the Mid-Atlantic region.

Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Jason Thomas

Twitter: - @SqlJason

LinkedIn: Jason Thomas

Contact: http://www.SqlJason.com

Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).

SQLSaturday #158 - New York City 2012

Sessions

Title: Microsoft’s Big Play for Big Data

Title: Surviving Your Peak Database Load

Title: Mastering Date-Time Based Analysis in DAX

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Title: SQL Server 2012 Columnstore index

Title: SQL Server Internals Architecture

Title: Full Text Indexing Basics

Title: Programming T-SQL Enhancements in SQL Server 2012

Title: Introducing SQL Server Data Tools

Title: Enriching Applications with SSAS Data Mining

Title: SQL 2012 Error Handling. Pick your Destiny

Title: SQL Azure Scalability with Federations

Title: Writing Faster Stored Procedures and Functions

Title: Without A SQLTrace - Getting To Know Extended Even

Title: Know Backups and Know Recovery

Title: Real World Integration Services: Excel Spreadsheet

Title: SSAS 2012 Tabular vs. Multidimensional

Title: Self-Managed BI with PowerPivot

Title: Get-PowerShell | Get-SQLServer

Title: Seven SQL Agent Jobs You Should be Running

Title: Running SQL Server on Solid State Drives

Title: Much Ado about Indexes - Tips, Tricks and Tuning..

Title: SQL Azure - What is it and why do I need it?

Title: What’s Buried in the Plan Cache?

Title: How Not to Be a Cranky DBA

Title: Performance Tuning SQL Server Integration Services

Title: SQL Server Dos and Don’ts: Keys to DBA Nirvana

Title: Data Cleansing with SSIS 2012

Title: Replicaton Technologies

Title: Virtualizing Tier-1 SQL Server Databases On VMware

Title: READPAST Furious-Transactions.Locking.Isolation.

Title: Alright,WHY is the server REALLY running so slow!

Title: Temporal Fact Tables: The Road Less Traveled

Title: Team Management Fundamentals

Title: Introduction to Data Quality Services

Title: But it worked great in Dev! Perfomance for Devs

Title: Deploying SQL Server 2012 Multi-site Clusters

Title: Shred SQL Server XML.

Title: Real-Life SQL 2012 Availability Group Deployments

Title: Creating a Performance Baseline for SQL Server

Title: Hadoop and its Ecosystem Components in Action

Title: Moves like Jagger - Upgrading to SQL Server 2012

Title: Slowly changing dimensions- an integrated approach

Title: Building Faster SQL Servers

Title: Advanced Charting Techniques in SSRS

Title: Implementing SQL Server 2012 on Windows Server Cor

Title: What’s new in SQL Server 2012 - from A to Z

Speakers

Sponsors