Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 40
In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
Speaker:

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

More often than not, a SQL DBA will also be requested (or required) to administer *other* applications in the SQL universe.  These applications are often the BI stack, SSIS, SSRS, and SSAS.  In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work.  At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.

This session will focus on the SSIS, SSRS, and SSAS engines in this session.  Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a bunch of new T-SQL functions in SQL Server 2012, and as usual  there's a combination of the "this is really useful" and the "...but there's a caveat". In this presentation, Rob will take you through the new analytic functions, show you how they seriously enhance your reporting ability, and show you some of the ways that they don't behave the way you might expect. You may not be using SQL Server 2012 yet, but you're bound to recognise some of the problems that these functions solve.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Take advantage of the deep wealth of knowledge from our experts at SQL Saturday by asking them anything and everything you may want to know or troubleshoot about SQL Server
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

You’re minding your own business in your corner office – well, no, you’re a DBA, so it’s just your cubicle – when somebody says, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you know what SaaS and DaaS are? If not, you should. SQL Server as a service (SaaS) and database as a service (DaaS) are otherwise known as the private cloud – the ability to offer your customers (external or internal) a reliable, scalable, and manageable way to easily deploy SQL Server systems and databases. At the end of the day they essentially want to push a button and get what they asked for. This is what the private cloud experience should enable for them. While you may do some of this now, come learn how to take it to the next level and design a service offering that will enable your organization to be agile, yet not leave you tearing out your hair worrying about it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

I have this database which must meet all of these governmental regulations.  Just like the government to make life a lot harder but wait, now they say I most also meet International regulations.  Can this be true?  Why me?  Let's look at what we can do to help us pass audits and comply with the laws around us.  I need to install TDE, what do I do? Move the database to other server, can I do that?  I used certificates, can I change them.  I don’t like governments making me do all this stuff, it complicates my database.  What does TDE do to my backups?  Can I remove it? Auditing, no, let’s run for the hills.  Let’s see how Sql Server can help us with these issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. 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. 
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation describes SQL Server Data Mining (SSDM) for SQL Server Professionals. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Too often ETL systems do not incorporate error handling.  When things break at 2 AM – and they ALWAYS break at 2 AM – some poor on call person must get out of bed and deal with something that should have been caught and handled by the code itself.  This session will cover ways for you to help your poor on-call colleagues get a full night’s sleep, thereby gaining you their eternal gratitude.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

What are FileTables?  How do they work?  What are their limitations?  These questions and more will be answered in this demo filled presentation.  We will walkthrough the configuration and implementation of this feature.  We will show you some use cases on how this fucntionality can help you manage your data in whatever forms it exists.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Over the years, one of the most common questions I am asked is, "How can I configure a cluster on my machine?" Ask no more! Production should never be the only place you have clusters. Having the ability to create a cluster that you can use as a sandbox for testing or as an instruction tool for presentations and demonstrations is something every DBA should have in their arsenal.

This session will demystify the "magic" behind configuring a cluster on your laptop or desktop using either Vmware Workstation or Microsoft's Hyper-V in Windows Server 2008 R2, and show how to configure things like the virtual machines, the domain controller, and the iSCSI storage solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever thought about speaking at a user group or SQL Saturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session
Speaker:

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Presentation on licensing, huh.  Boring? Maybe. Important? Absolutely!  Being a DBA isn't just all fun and games.  There are also some serious things to take care of. Licensing SQL Server is one of those and doing it right can mean the difference between a few thousand dollars or a few hundred thousand dollars.  This session will discuss how to license SQL Server specifically for the transition from a physical to a virtual environment. You'll find that maybe, more than anything else, it will be the way SQL Server is licensed that determines how you configure your entire virtual infrastructure.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models,  working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: May 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 40
Back to Top cage-aids
cage-aids
cage-aids
cage-aids