Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 30
Too often we get wrapped up in the latest release of feature of database products. This presentation provides a broader perspective on databases, their life cycles and the life of a DBA. Based on 40 years in IT, we discuss why we do this and why it’s so hard for others to understand why we do what we do.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Amazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers).  What do they offer, why would one use them, how do they differ, what special considerations are there?  What exactly does “Platform as a Service” (PaaS) mean with SQL?
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Many DBAs have heard the term Analysis Services, but don't really know what it's for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.

This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever been in Kansas and have a random house drop on you?  Ok, probably not, but the moral of the question is that you never know when a house might fall out of the sky and you certainly don't want to be caught under it when it does!.  Not understanding database backups & restores is just like having a house crash down on around your ears.  Loud, noisy and sometimes hard to put the pieces back together.  As a follower of the Yellow Database Road, You have to be ready for said event.  Now how do you do that you ask?  You come to this session about Backups & Restores.  We'll talk about how to use them to help avoid having a house fall on your head!  
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Discussion of the reasons Blue Cross Blue Shield of Nebraska decided to implement table partitioning and data compression, how we implemented it, what issues we encountered and some examples of how we resolved the issues.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The new Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel and Power View.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Tuning disk subsystems for optimal SQL Server performance is typically the domain
of very experienced, enterprise DBAs. It normally requires years of experience the hard disk
subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance,
and allow for the most scalability. This session removes the need for those years of experience
by answering questions like:

How does RAID compare to SAN, hard disk to SSD?
What is needed to properly monitor and tune the performance of my disk subsystem?
How do I tune my SQL Server for improved IO performance?

Configuring hardware can be very intimidating, especially when the application needs to scale.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Everything that's old is new again, as Windows Server moves back to the terminal interface.  With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure.  This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Now days the technician spends more and more of their time conversing with non-technical business users. The problem is, we speak different languages. This results in confusion, frustration and the impression that IT is difficult to work with. This discussion will focus on how to better communicate with business users to provide products and solutions that meet their needs, get them to understand the issues in providing those products and helping the business user to expand their thinking beyond the ordinary.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Yes, how to be a DBA and retire rich.  This is a session in the ‘off the beaten path’ or the ‘miscellaneous track’.  You will learn nothing SQL Server technical in this session, but will learn about the Modern Portfolio Management theory in Finance.  I will conduct a practical discussion on how to structure your 401(K) portfolio or your general investment portfolio for the most optimal asset allocation and maximum return while minimizing taxes and expenses.  You can use the practical tips in this session to consider options to streamline your portfolio to maximize returns.  This session may serve as a wakeup call to do something about your portfolio.  When it comes to retirement, clearly, luck is not a strategy.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 06

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 6

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql.  It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases.  Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Power Pivot is an amazing tool for mashing up data from a variety of sources ~ in this session, we will combine data from NASA, OpenGOV, and other publicly available sources, as well as from a prebuilt cube, to show the power of user driven analysis, and visualisation in Excel.
Using DAX, you will see how to create filtered measures, and then dive into the new enhancements for the date table, relationshios, perspectives and KPIs.
As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as Performance Point and Crescent (PowerView)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this demo-rich session, we will explore database and ETL architectures that let you smoothly move data from your application databases across the enterprise in real-time to your data warehouse. You will see how to use SQL Server features such as replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load data fast and dependably. We will develop an actual sample system during the session and discuss and walk through alternative real-time architectures, including the use of Data Vault methodologies. We will then see how to use Reporting Services and Power View to present data with a minimum amount of latency.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you opt for bullet charts over big, round gauges? Do 3-D pie charts make you sad? Have you ever redesigned a graph to get a better data-to-ink ratio?  Whether you answered yes to all of these questions or you are unfamiliar with all of the above terms, come to this session to learn about design concepts as well as helpful features and tools available when using Reporting Services to visually represent data in an efficient and effective manner.  We will also discuss common challenges faced in the workplace when trying to implement the ideals in real life.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

 Secure, Enable, Maintain, Sustain.   In depth discussion on a SSAS security framework with SSIS maintenance toolkits.   Create security roles in the cube that enable the business based on underlying data patterns.   Presentation covers creation of roles in the cube, with a demo creating SSIS roles with a toolkit based on the adventureworks db model and cube.   Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports.   This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions.  Presented in English.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Social Networking is all over the news today. Did you see that on Facebook?  Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No?  Never heard of Twitter? Don't have any fear as this session is for you!  Social networking can be a very confusing place and when you don't know where to start, that makes it even worse.  In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one.  We'll be covering Facebook, LinkedIn and Twitter.   
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a deep dive session in the new HA/DR options for SQL Server 2012.  Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups.  Experience how to set up active secondary’s and off load backups to the secondary servers.  You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Advanced

Session Code:

Date: October 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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