sqlsathistory

Nr: 236

Back to Main list

SQLSaturday #236 - St. Louis 2013

Start Time (24h) Speaker Track Title
00:00:00 Bill Fellows BI Somebody got BIDS Helper in my Data Tools
00:00:00 David Klee Data Platform It's All About the Performance, Right?
00:00:00 Eddie Hendrix BI SQL Server PDW 2012
00:00:00 Gill Rowley DBA I You're THE DBA. Now What?
00:00:00 Dan Guzman BI Designing High-Performance Database Applications
00:00:00 James Davis DBA II SQL Server on VMware, what a DBA should know
00:00:00 JD Wade Data Platform What SQL DBAs need to know about SharePoint
00:00:00 don conrad DBA II AlwaysOn, Clustering, Mirroring: What are they? What aren't they"
00:00:00 Jeff Fattic App Dev Database Change Management
00:00:00 Kathi Kellenberger DBA I Women in Tech Panel
00:00:00 Kathi Kellenberger App Dev T-SQL 2012 Analytic Functions
00:00:00 Larry Toothman DBA II Yesterday I Couldn’t Even Spell ‘DBA’.
00:00:00 Mike Hays DBA I Introduction to Trace Flags
00:00:00 Meagan Longoria BI Don’t Miss Out on Excel Cube Functions
00:00:00 Pierre LaFromboise DBA II Implementing AlwaysOn Availability Groups
00:00:00 Tim Plas DBA I Protecting SQL Data for Availability and DR
00:00:00 Tim Ford Data Platform Management Studio Features for Working Less and Getting More Done
00:00:00 Travis Whitley DBA I SSRS Basics for the DBA
00:00:00 Virginia Mushkatbat Data Platform Data Flow Architectures in Software Development Life-Cycle
00:00:00 Aaron King App Dev Agile Database Development
00:00:00 Andy Thiru App Dev Moving Enterprise database to cloud

SessionID: 10440

Somebody got BIDS Helper in my Data Tools

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI

Speaker: Bill Fellows

Title: Somebody got BIDS Helper in my Data Tools

Abstract:

Do you develop SSIS packages, SSRS reports or SSAS cubes (multidimensional or tabular)? Then this class is for you! We'll cover the capabilities this free tool empowers you to perform as well as address some of the grating little quirks of BIDS/SSDT. 

Analysis Services Multidimensional: Roles Report, Printer Friendly Dimension Usage

Tabular: Tabular Actions Editor, Tabular Display Folders, Tabular HideMemberIf

SSRS: Delete Dataset Cache Files

SSIS: Deploy packages from BIDS/SSDT, Identify items with configuration/expressions, Create packages based on templates, Find differences between packages

Learn about this perfect combination from Meagan Longoria and Bill Fellows and you'll never want to have your BIDS without the helper.

SessionID: 12544

It's All About the Performance, Right?

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Data Platform

Speaker: David Klee

Title: It's All About the Performance, Right?

Abstract:

Just about anyone can click through a SQL Server installation and get it working. But, it is not running close to efficient, and as the workloads grow, it will only get worse. This session by David Klee (@kleegeek) provides valuable details on how to tweak and tune your SQL Server installations to ensure maximum performance, as well as tips on capacity management so you know when you need to add more hardware to take your server to the next level.

SessionID: 13720

SQL Server PDW 2012

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI

Speaker: Eddie Hendrix

Title: SQL Server PDW 2012

Abstract:

Although many have still not heard much about Microsoft's Parallel Data Warehouse Appliance the 2012 release of the product is our 7th version to market. I will cover the basic differences between SMP and MPP data warehouse systems, how the Microsoft PDW works, and what features and sizes are available in PDW 2012. We'll also talk about how PDW 2012 allows you to integrate your typical relational data with your Big Data in one integrated environment.

SessionID: 14640

You're THE DBA. Now What?

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I

Speaker: Gill Rowley

Title: You're THE DBA. Now What?

Abstract:

Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.

SessionID: 14916

Designing High-Performance Database Applications

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI

Speaker: Dan Guzman

Title: Designing High-Performance Database Applications

Abstract:

Performance matters. A well-designed application will reduce hardware and licensing

costs while providing an enjoyable end-user experience with maximum scalability. This session covers the key considerations of database application design from a holistic performance perspective.

SessionID: 15548

SQL Server on VMware, what a DBA should know

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA II

Speaker: James Davis

Title: SQL Server on VMware, what a DBA should know

Abstract:

More and more companies are virtualizing with VMware, and databases are the next logical step. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMware environment.

SessionID: 16144

What SQL DBAs need to know about SharePoint

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Data Platform

Speaker: JD Wade

Title: What SQL DBAs need to know about SharePoint

Abstract:

With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, supported methods for providing high availability and disaster recovery, and the part SharePoint and SQL each play in the Microsoft Business Intelligence story.

SessionID: 16251

AlwaysOn, Clustering, Mirroring: What are they? What aren't they"

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA II

Speaker: don conrad

Title: AlwaysOn, Clustering, Mirroring: What are they? What aren't they"

Abstract:

We hear these names bandied about, but what exactly are they? How do they benefit the end user? How do they differ? What problems do they solve? How does a DBA implement them?

We will address these technologies showing what they do. We'll describe the typical situations where they are used. We'll list the major costs associated with each. We'll give bullet points that can help management decide whether to implement a given option.

SessionID: 16708

Database Change Management

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev

Speaker: Jeff Fattic

Title: Database Change Management

Abstract:

For too long have database developers had to suffer with inferior tools and processes! Database development is just as important as application development and it deserves equivalent tooling. In this session, we'll demonstrate how SQL Server Data Tools allow you to utilize source code control, generate deployment and rollback scripts, refactor databases, and much more.

SessionID: 18410

Women in Tech Panel

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I

Speaker: Kathi Kellenberger

Title: Women in Tech Panel

Abstract:

SessionID: 18411

T-SQL 2012 Analytic Functions

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev

Speaker: Kathi Kellenberger

Title: T-SQL 2012 Analytic Functions

Abstract:

Learn how the new analytic functions introduced with SQL Server 2012 can take your T-SQL skills to the next level! Solve complicated requirements with better performing and easier to write queries.

SessionID: 18957

Yesterday I Couldn’t Even Spell ‘DBA’.

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA II

Speaker: Larry Toothman

Title: Yesterday I Couldn’t Even Spell ‘DBA’.

Abstract:

Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator. Once the initial shock passes they realize that they need help. The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help.

SessionID: 20639

Introduction to Trace Flags

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I

Speaker: Mike Hays

Title: Introduction to Trace Flags

Abstract:

Trace flags alter the way SQL Server behaves. Learn the how why to use them. Understand the difference between documented and undocumented trace flags. Review a couple trace flags that your SQL Server might benefit from.

SessionID: 20969

Don’t Miss Out on Excel Cube Functions

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI

Speaker: Meagan Longoria

Title: Don’t Miss Out on Excel Cube Functions

Abstract:

Cube functions have existed since Excel 2007, but they’re not as well known nor as well publicized as other methods to obtain data from Analysis Services/PowerPivot sources. Business Analysts may feel confined to tabular (symmetrical) reports with pivot tables. BI Developers may avoid Excel because they want the ability to write calculations in MDX and the extensive formatting capabilities of Reporting Services. And Power View limits you to the sets, calculations, and captions available in the data source and doesn’t provide drillthrough detail. We’ll start with the basics of how to write and use cube functions, then employ them to build a nicely formatted, asymmetrical, parameter-driven report that overcomes the previously noted limitations. In addition to facilitating new methods for data retrieval and report design, learning cube functions can help business analysts understand the MDX language and BI developers appreciate the power of Excel’s formulas and formatting options.

SessionID: 22171

Implementing AlwaysOn Availability Groups

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA II

Speaker: Pierre LaFromboise

Title: Implementing AlwaysOn Availability Groups

Abstract:

SQL Server 2012 introduced a new set of high availability features collectively called AlwaysOn. Availability Groups are an AlwaysOn alternative to database mirroring. In this session we will discuss the advantages of Availability Groups and walkthrough a basic implementation.

SessionID: 26583

Protecting SQL Data for Availability and DR

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I

Speaker: Tim Plas

Title: Protecting SQL Data for Availability and DR

Abstract:

This session provides a comparison of SQL High Availability Disaster Recovery options, presented by a practitioner who has implemented and managed all the SQL High Availability and Disaster Recovery approaches (and various combinations thereof). We will provide an overview of all the various HA DR options, then compare trade-offs for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.

SessionID: 26870

Management Studio Features for Working Less and Getting More Done

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Data Platform

Speaker: Tim Ford

Title: Management Studio Features for Working Less and Getting More Done

Abstract:

As SQL Server Professionals we spend countless hours inside a single tool - Microsoft SQL Server Management Studio - yet odds are you don't know of some of the enhancements that exist inside Management Studio that provide you with the ability to re-use code, parameterize frequently-run scripts, and store all these scripts right at your fingertips. In this session Tim will dive into some of the less familiar areas of SSMS and give you ideas on how you can work less... and get more accomplished. We will also touch upon some additional functionality that Red Gate's SQLPrompt offers for taking this one step further.

SessionID: 27099

SSRS Basics for the DBA

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I

Speaker: Travis Whitley

Title: SSRS Basics for the DBA

Abstract:

Many SQL Server DBAs support Reporting Services administratively, but may not know how a report is actually developed. This session will outline some fundamentals of SQL Server Reporting Services, as well as walk through the development of a parameterized report from end to end.

SessionID: 27457

Data Flow Architectures in Software Development Life-Cycle

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Data Platform

Speaker: Virginia Mushkatbat

Title: Data Flow Architectures in Software Development Life-Cycle

Abstract:

The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.

SessionID: 9168

Agile Database Development

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev

Speaker: Aaron King

Title: Agile Database Development

Abstract:

In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.

SessionID: 9945

Moving Enterprise database to cloud

Back to calendar

Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev

Speaker: Andy Thiru

Title: Moving Enterprise database to cloud

Abstract:

Windows Azure provides several different ways of storing and managing data. Windows Azure SQL Database and SQL Server in Windows Azure Virtual Machines are solutions in Windows Azure for working with relational data. If you are familiar with SQL Server, Windows Azure SQL Database will be a natural extension of your knowledge and skills.

In this session, you will learn:

  1. Windows Azure SQL Database - Learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walk through how to manage and administer your Windows Azure SQL servers and databases.
  2. Provision the SQL Server VM on Windows Azure - We will learn provisioning the Virtual Machine through the Windows Azure Management Portal. Once created, we will open the VM through the Remote Desktop . Finally, we will connect to SQL server using SSMS.