sqlsathistory

Nr: 312

Back to Main list

SQLSaturday #312 - Sacramento 2014

Start Time (24h)	Speaker	Track	Title
00:00:00	Ben Miller	Track 4	SQL Server TDE
00:00:00	Jason Brimhall	Track 2	SQL 2012 Extended Events
00:00:00	DIlip nayak	Track 4	Benchmark your SQL server storage system
00:00:00	Eric Courville	Track 2	PowerShell - Making the most of SQL Server Commandlets
00:00:00	Eric Freeman	Track 3	What is the cardinality estimator?
00:00:00	Jason Horner	Track 5	Dimensional Modeling Design Patterns: Beyond Basics
00:00:00	Joseph D'Antoni	Track 1	The Modern Analytics Architecture
00:00:00	Jim Murphy	Track 5	AlwaysOn - Finally, A usable 'mirror'!
00:00:00	Kalen Delaney	Track 3	Hekaton Data: A Whole New World
00:00:00	Keith Tate	Track 4	The Curious Case of Isolation Levels
00:00:00	Matt Henderson	Track 2	Violin Memory Lunch Session: Flash Storage 101 and How it Modernizes Database Design
00:00:00	Mickey Stuewe	Track 3	Scalable SSRS Reports Achieved Through the Powerful Tablix
00:00:00	Mickey Stuewe	Track 2	Changing Your Habits to Improve the Performance of Your T-SQL
00:00:00	Mike Tutor	Track 1	Tools You Probably Aren’t Using. Why Not?
00:00:00	Mitchell Bottel	Track 2	Want a promotion? It’s up to you!
00:00:00	Prakash Heda	Track 5	Streamlining SQL Server Implementations Across Organization
00:00:00	Randy Knight	Track 1	Understanding the SQL Server Transaction Log
00:00:00	Stacia Varga	Track 4	Introducing Power BI
00:00:00	Dan Hess	Track 5	Lightning talks - SacSQLUG
00:00:00	Steve Wake	Track 1	Capture Change and Apply it With Change Data Capture SSIS
00:00:00	Kevin Boles	Track 1	Common TSQL Mistakes
00:00:00	Kevin Boles	Track 2	Windowing Functions: THE Reason to Upgrade to 2012+
00:00:00	Todd Kleinhans	Track 5	The Life Cycle of a Query in 3D
00:00:00	Tom Keller	Track 3	Managing Oracle and Migrating to SQL Server: Tips from the Trenches
00:00:00	Trent Sherman	Track 5	SQL Server on VMWare Monitoring: Optimized for Performance
00:00:00	Michael Fal	Track 3	Improving Database Restores with Powershell
00:00:00	Jonathan Amen	Track 3	Self-Service BI Solution from Data to Report Builder 3
00:00:00	Ami Levin	Track 1	Physical Join Operators
00:00:00	Andrew Eichenbaum	Track 4	An Analytics Sandbox in A World of Big Data
00:00:00	Andrew Nakamura	Track 4	Powershell 101 for the DBA
00:00:00	Angel Abundez	Track 2	Discover Power BI for Office 365

SessionID: 10218

SQL Server TDE

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Ben Miller

Title: SQL Server TDE

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy in general as well as how it relates to SQL Server TDE.

SessionID: 10839

SQL 2012 Extended Events

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Jason Brimhall

Title: SQL 2012 Extended Events

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.

SessionID: 12127

Benchmark your SQL server storage system

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: DIlip nayak

Title: Benchmark your SQL server storage system

Abstract:

This session will cover the process of benchmarking the underlying SQL server storage, test its performance and limits by using readily available tools.

SessionID: 13879

PowerShell - Making the most of SQL Server Commandlets

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Eric Courville

Title: PowerShell - Making the most of SQL Server Commandlets

Abstract:

PowerShell is the Windows IT Pro's new best friend however it has not gotten much love from SQL Server in the past. Still with the newest releases including Preview version 5 we can do some amazing things and there is no reason we can't share the love back to our favorite RDBMS! Lets automate SQL Server together with PowerShell.

SessionID: 14349

What is the cardinality estimator?

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Eric Freeman

Title: What is the cardinality estimator?

Abstract:

We will go over the redesign of the SQL Server Query Optimizer cardinality estimation process. Including how to enable/disable the new behavior in SQL 2014. We will begin by going over the importance of the estimates and how to improve the accuracy of estimates. We will also have a demo where you can see the difference with the new cardinality estimation process.

SessionID: 15821

Dimensional Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract:

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 16168

The Modern Analytics Architecture

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Joseph D'Antoni

Title: The Modern Analytics Architecture

Abstract:

The traditional data warehouse has been around a long time, and it isn’t going away anytime soon. However, with other options such as Hadoop and new analytic and data mining techniques, the warehouse is no longer the center of our business analytics universe. In this session, we will cover these new platforms and our approach for integrating them into your warehouse environment.

SessionID: 16817

AlwaysOn - Finally, A usable 'mirror'!

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Jim Murphy

Title: AlwaysOn - Finally, A usable 'mirror'!

Abstract:

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.

SessionID: 17851

Hekaton Data: A Whole New World

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Kalen Delaney

Title: Hekaton Data: A Whole New World

Abstract:

SQL Server 2014's In-Memory OLTP stores your data and indexes in a whole new way. In this session we'll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.

SessionID: 18856

The Curious Case of Isolation Levels

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Keith Tate

Title: The Curious Case of Isolation Levels

Abstract:

Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.

SessionID: 20142

Violin Memory Lunch Session: Flash Storage 101 and How it Modernizes Database Design

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Matt Henderson

Title: Violin Memory Lunch Session: Flash Storage 101 and How it Modernizes Database Design

Abstract:

NAND flash storage is the new wave of technology hitting datacenters and solutions design. With a new technology comes a new set of pros versus cons, new economics and changes in solutions architecture that highlight what it has to offer. This session will give an overview of how the technology works, what to look out for, how to properly POC/test each vendor’s solution and how to modernize your database architecture with this new technology.

SessionID: 20401

Scalable SSRS Reports Achieved Through the Powerful Tablix

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Mickey Stuewe

Title: Scalable SSRS Reports Achieved Through the Powerful Tablix

Abstract:

Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control.

In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.

SessionID: 20402

Changing Your Habits to Improve the Performance of Your T-SQL

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mickey Stuewe

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract:

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

SessionID: 20615

Tools You Probably Aren’t Using. Why Not?

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Mike Tutor

Title: Tools You Probably Aren’t Using. Why Not?

Abstract:

Policy Based Management (PBM) and Central Management Server (CMS) are tools you already have if you have at least one SQL 2008 instance. These powerful but often overlooked tools are simple to use, and together they give you a central point from which to manage all your SQL instances. You can even manage your SQL 2000 and 2005 servers as well. This live demo session will show you how easy it is to use these 'hidden gems' that have been lying about in your SSMS toolbox. Real world solutions for real world problems in just minutes.

SessionID: 20836

Want a promotion? It’s up to you!

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mitchell Bottel

Title: Want a promotion? It’s up to you!

Abstract:

Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career without looking like “That Guy”. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out.

SessionID: 22281

Streamlining SQL Server Implementations Across Organization

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Prakash Heda

Title: Streamlining SQL Server Implementations Across Organization

Abstract:

In this session Prakash will walk through the process he has implemented to alleviate many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production. There are several variables to consider when supporting SQL Servers in the real world, including Cloud/VMware/Physical systems, Different SQL server versions, OS/Memory/Disk related configurations. You will learn…- A process which help configure SQL servers with optimal performance considerations- Consistent SQL support Env's help improve DBA productivity and reduce production issues- Configuration changes to be requested from windows admin/ network admin/ storage admin to be planned in advance- Flexibility to easily add new SQL configurations to support new applications

SessionID: 22550

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 24648

Introducing Power BI

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Stacia Varga

Title: Introducing Power BI

Abstract:

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we'll review the BI components available in the cloud BI stack. We'll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you'll have a better understanding of what's possible and whether it's time to launch your BI-in-the-cloud solution.

SessionID: 24952

Lightning talks - SacSQLUG

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Dan Hess

Title: Lightning talks - SacSQLUG

Abstract:

Have you ever wondered what four guys from Sacramento have to say about SQL Server? Come find out when Mitch Bottel, Dan Hess, Dilip Nayak and Joe Simmons talk about our favorite DBMS, sharing experiences and tips/tricks and well as telling you how to do your job quickly and more efficiently. We'll discuss SQL Server Management Studio (SSMS) in depth, talk about FREE SQL Server tools that every DBA should know about and finish off with a hands on presentation on using certificates to sign stored procedures.

Presenters are board members for the Sacramento SQL Server user group:

Mitch Bottel - president; Dan Hess - vice president/treasurer; Dilip Nayak - event coordinator; Joe Simmons - public relations;

SessionID: 25708

Capture Change and Apply it With Change Data Capture SSIS

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Steve Wake

Title: Capture Change and Apply it With Change Data Capture SSIS

Abstract:

Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.

SessionID: 26414

Common TSQL Mistakes

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FIFTY times now and it is always very highly rated!

SessionID: 26416

Windowing Functions: THE Reason to Upgrade to 2012+

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012+

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26965

The Life Cycle of a Query in 3D

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in 3D

Abstract:

Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift Virtual Reality Headset for 3D Gaming and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.

SessionID: 27037

Managing Oracle and Migrating to SQL Server: Tips from the Trenches

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Tom Keller

Title: Managing Oracle and Migrating to SQL Server: Tips from the Trenches

Abstract:

Part 1: Have you inherited an Oracle-based application, and are you not sure what you need to know to keep it running? Here are the basics, explained in terms familiar to Microsoft SQL administrators, including: - making sure you have, and keep, SYSDBA access - locating the ALERT log and checking for non-default PARAMETER - enabling ARCHIVELOG mode, scheduling RMAN backup, and testing restore - management of TABLESPACE and DATAFILE - using DBMS_MONITOR and TKPROF to trace SQL queries - using STATSPACK for performance troubleshooting Part 2: Have you gotten the go-ahead to convert an Oracle database to SQL Server, and are you not sure how? Here is a proven and repeatable (and free) process, which achieves consistent results without requiring the source Oracle database to be read-only during the conversion. Microsoft's SSMA (SQL Server Migration Assistant) is just the beginning!

SessionID: 27107

SQL Server on VMWare Monitoring: Optimized for Performance

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 5

Speaker: Trent Sherman

Title: SQL Server on VMWare Monitoring: Optimized for Performance

Abstract:

Your SQL Server instance has been placed on a VMWare virtualized machine (VM), now what. When a SQL Server instance moved to a virtualized architecture, the DBA typically loses visibility to CPU, Memory, Storage and network metrics. This session will cover basic virtualization concepts specifically related to VMWare, VMWare tools, as well as discuss specific tools to help restore the visibility of server metrics and correlate those metrics directly to SQL Server performance. Monitoring the server metrics along with monitoring overall SQL Server performance provides for an effective solution to manage monitor your SQL Server/VMWare virtualized environment.

SessionID: 34775

Improving Database Restores with Powershell

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Michael Fal

Title: Improving Database Restores with Powershell

Abstract:

Database restores are a key function of any database administrator's job. However, it can be an extremely time consuming task to sort through your backups, find the right files, and then get your database up and running. In an emergency this will have a disastrous impact on your Recovery Time Objective(RTO) and lead to the dreaded angry-CTO-in-your-cube effect. By leveraging some easy-to-use Powershell scripts, you can avoid the second disaster and the pain that comes with it. By attending this session, you will understand how you can use the Powershell automation framework for database restores, see scripts that will let you restore faster, and learn techniques to extend these tools for migrating data and testing backups.

SessionID: 9369

Self-Service BI Solution from Data to Report Builder 3

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Jonathan Amen

Title: Self-Service BI Solution from Data to Report Builder 3

Abstract:

In this presentation I'll show you a no SQL code required, all SQL Server 2012 self-service BI solution from the data warehouse all the way up to Report Builder 3. This is a solution I've put in place at Sutter, and it's something simple enough to use at virtually any company.

SessionID: 9389

Physical Join Operators

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Ami Levin

Title: Physical Join Operators

Abstract:

SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

SessionID: 9490

An Analytics Sandbox in A World of Big Data

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Andrew Eichenbaum

Title: An Analytics Sandbox in A World of Big Data

Abstract:

As Big Data becomes the norm to deal with data volume, variety and velocity, it becomes increasingly harder for the Data Analyst to understand and work with data sets. To overcome this we introduce Platfora, a Hadoop-backed data analysis framework which nicely complements more traditional data warehousing and BI solutions. We'll go over ingestion of new data and building of data sets and visualizations in a system that requires no more work than interacting with a graphical interface. More specifically, we will do so in the context of peer-to-peer lending, to show how insights on loan applicants and their risk profiles can be quickly revealed with no ETL development or demanding data transformation.

SessionID: 9559

Powershell 101 for the DBA

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Andrew Nakamura

Title: Powershell 101 for the DBA

Abstract:

Andy has over 15 years experience in the DBA field. Starting with SQL 6.5 to 2014, he is always retooling himself to be on the cutting edge of technology. He currently works for USC Keck Medical center as the Senior DBA and is using the techniques in this session in production.

SessionID: 9663

Discover Power BI for Office 365

Back to calendar

Event Date: 12-07-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Angel Abundez

Title: Discover Power BI for Office 365

Abstract:

Come learn about the new innovations and capabilities in Power BI for Office 365. Using Excel, SQL Server, and the power of the cloud, you will see what the BI landscape in Office 365 looks like and what you can potentially leverage today using the most popular BI tool on the planet. Come learn how to refresh your data with on-premise data sources, create visually compelling experiences on mobile devices, do time-series forecasting, and provide data governance through the Data Catalog and Natural QA.

We will discuss what you will need in your Office 365 environment to get going, and some best practices when trying to set this up for your department or enterprise.

This site is open source. Improve this page.