Nr: 236
SQLSaturday #236 - St. Louis 2013
SessionID: 10440
Somebody got BIDS Helper in my Data Tools
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:
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
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: Data Platform
Speaker: David Klee
Abstract:
SessionID: 13720
SQL Server PDW 2012
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?
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
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Dan Guzman
Abstract:
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
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
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"
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
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev
Speaker: Jeff Fattic
Title: Database Change Management
Abstract:
SessionID: 18410
Women in Tech Panel
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: DBA I
Speaker: Kathi Kellenberger
Title: Women in Tech Panel
Abstract:
This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.
SessionID: 18411
T-SQL 2012 Analytic Functions
Event Date: 07-09-2013 - Session time: 00:00:00 - Track: App Dev
Speaker: Kathi Kellenberger
Title: T-SQL 2012 Analytic Functions
Abstract:
SessionID: 18957
Yesterday I Couldn’t Even Spell ‘DBA’.
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
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
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:
SessionID: 22171
Implementing AlwaysOn Availability Groups
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
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
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:
SessionID: 27099
SSRS Basics for the DBA
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
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
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
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:
- 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.
- 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.