Nr: 142
SQLSaturday #142 - Waltham 2012
SessionID: 10077
Building your first BI Semantic Model Tabular
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Ayad Shammout
Title: Building your first BI Semantic Model Tabular
Abstract:
SQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.
SessionID: 10511
What’s New in BI in SQL Server 2012
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Brian Knight
Title: What’s New in BI in SQL Server 2012
Abstract:
In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named SQL Server 2012. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the Tabular Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.
SessionID: 10514
What’s in SQL Server 2012 for the DBA?
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Brian Knight
Title: What’s in SQL Server 2012 for the DBA?
Abstract:
In this session, you’ll learn how the new SQL Server 2012 features like Always On will help you create a better high availability experience for your users and applications. Then, you’ll learn about the new table types (file table) and how you can use it to create a better content management system. Lastly, we’ll cover new indexing strategies that SQL Server 2012 now allows called Column Store indexes to potentially give your queries a 500x boost!
SessionID: 10792
Table Compression
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Brimhall
Title: Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11839
Inroduction to Triggers
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Jack Corbett
Title: Inroduction to Triggers
Abstract:
SessionID: 11840
Transitioning from SQL Trace to Extended Events
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Jack Corbett
Title: Transitioning from SQL Trace to Extended Events
Abstract:
Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
SessionID: 13602
To click or to type, that is the question
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: David Taylor
Title: To click or to type, that is the question
Abstract:
When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee's Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.
SessionID: 15563
Loading a Data Warehouse using SSIS 2012
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: James Phillips
Title: Loading a Data Warehouse using SSIS 2012
Abstract:
N/A
SessionID: 16185
SQL 2012 -- All About HA and DR
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Joseph D'Antoni
Title: SQL 2012 -- All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.
SessionID: 16186
It Costs How Much? SQL Server Licensing
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Joseph D'Antoni
Title: It Costs How Much? SQL Server Licensing
Abstract:
Did you know that as of June 30th the model for licensing SQL Server is changing? Learn about what these changes mean to you and your IT organization. We will discuss the impact to hardware architecture, virtualization environments, and DR. Understand the strategies you are your organization can take to minimize the financial impact of these licenses changes.
SessionID: 16728
Data Partitioning in SQL 2012
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: John Flannery
Title: Data Partitioning in SQL 2012
Abstract:
SessionID: 16823
Hadoopla - Microsoft and the Hadoop Ecosystem
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Jim O'Neil
Title: Hadoopla - Microsoft and the Hadoop Ecosystem
Abstract:
Big Data is the buzz word du jour, and Hadoop (the open source map/reduce framework) is a primary part of the conversation. We'll cover what Hadoop does (and doesn't do) as well as the various other technologies that touch upon it. We'll also look at what Microsoft is doing with Hadoop, both in the cloud and on-premises and how it's a part of the overall Microsoft BI offering.
SessionID: 17837
What's New in T-SQL 2012 Denali
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Kailash Chintamani
Title: What's New in T-SQL 2012 Denali
Abstract:
New Code introduction and New DMV's In sql Server 2012.
New Coding features in management Studio
SessionID: 17974
Best Practices for Monitoring Databases on VMware
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Kathy Gibbs
Title: Best Practices for Monitoring Databases on VMware
Abstract:
SessionID: 20549
New Server in an Hour? No Problem!
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Mike Hillwig
Title: New Server in an Hour? No Problem!
Abstract:
"We need a new server before you leave on vacation!" Never mind that it's Friday at 2:00 PM and you need to be in the airport in a couple of hours. This isn't the time to panic. Mike Hillwig deploys new servers every week and has a streamlined process that allows him to deploy a new server in an hour from delivery of the Windows server. We're not talking just installing SQL Server. This is having the new server production-ready in an hour, including scripts to backup, monitor, and maintain databases. With a little bit of advanced planning, following a few simple rules, and some scripting, you can be ready for just such an emergency. And you'll still catch you flight!
SessionID: 20630
Aviation Disasters - And IT Lessons From Them
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Mike Walsh
Title: Aviation Disasters - And IT Lessons From Them
Abstract:
SessionID: 21667
Network or Perish
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Paresh Motiwala
Title: Network or Perish
Abstract:
As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities.
SessionID: 21668
Best Practices Document
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Paresh Motiwala
Title: Best Practices Document
Abstract:
As DBAs we are often straddled with writing a best practices document. In this session, I will start with a bare bones template and then we can collectively come up with a Best Practices Document by the end of the session. I challenge you that this document can come in handy, no matter where you go.If time permits, we can also discuss how to implement this in organizations with varying degrees of acceptance.
SessionID: 24011
Get-PowerShell | Get-SQLServer
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: SB Chatterjee
Title: Get-PowerShell | Get-SQLServer
Abstract:
SessionID: 24029
What is this cache and how did it get so big?
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Doug Brendle
Title: What is this cache and how did it get so big?
Abstract:
Ever wonder what's in your SQL Plan cache? Wonder why or how the plan cache got so big? This session will cover what the cache is, how it is used, and how poor application and query design can make it worse. Rather than put participants to sleep with dozens of slides we will get down and dirty with lots of demos including .Net code and some cool DMVs to guide the way.
SessionID: 25878
Intuitive and ad-hoc reporting using Power View
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Sunil Kadimdiwan
Title: Intuitive and ad-hoc reporting using Power View
Abstract:
In this session I will give you an overview of the key features of Power View and then I will develop some of these views.
SessionID: 27547
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Varsham Papikian
Abstract:
SessionID: 27548
New in SQL Server 2012 for Devs: SSMS and T-SQL
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Varsham Papikian
Title: New in SQL Server 2012 for Devs: SSMS and T-SQL
Abstract:
SQL Server 2012 has a re-designed SSMS which is based on VS2010 Shell. There are many new features which should help us to be more productive. During the session I will demonstrate the new features in SSMS. I will also show a few existing but 'hidden' features. Then I will discuss a few new T-SQL features introduced in SQL Server 2012.
SessionID: 27959
Getting Started with MDX: The (Very) Basics
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: William E Pearson III
Title: Getting Started with MDX: The (Very) Basics
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
SessionID: 27966
Serene Velocity: Reporting Services and SSAS Data
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: William E Pearson III
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract:
SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
SessionID: 34589
New High Availability options with SQL Server 2
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Andy Roberts
Title: New High Availability options with SQL Server 2
Abstract:
Introduction to new availability options in SQL Server 2012 including enhancements to Failover and the new AlwaysOn Availability Groups to provide multiple readable secondaries!
SessionID: 34592
What’s new in SQL Server 2012 SSIS
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Roberts
Title: What’s new in SQL Server 2012 SSIS
Abstract:
SQL Server 2012 gave more than a facelift to SSIS! This session will discuss improvements to the design, deployment and runtime environments.
SessionID: 9673
Writing Faster Procedures and Functions
Event Date: 19-05-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Andrew Novick
Title: Writing Faster Procedures and Functions
Abstract:
Stored procedures and functions are the mainstay of SQL Server coding. This presentation shows techniques to improve performance using the lessons learned by Andy Novick over years of development. We start with the most important techniques to learn where time is going using standard server traces and SQL Server Extended Events. Once we know where the time is going we look at strategies to decrease - Achieving Minimally Logging--Managing indexes on temp tables o Why heaps are often the best choice o How to discover if an index is helping o How building non-clustered indexes on heaps is faster- Rewriting scalar and multi-statement functions to as inline functions- Temp tables vs temp variables- The Magic, Go Faster Switc