Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 45
Description:This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and testing PowerShell working with both SMO and SQLPS module to build SQL PowerShell scripts.  This is not a language intro but it will get you started to learn PowerShell.  Covering PowerShell V2/V3 and SQL Server tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Cloud

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever had a discussion where someone said well X is best practices but that is impossible to implement?  This session is a step by step installation guide to best practices for SQL Server.  When you install with best practices in mind, maintaining them is much simpler.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Admin

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The latest version of PowerPivot brings even more BI power to the masses the addition of defined hierarchies, KPI’s, perspectives, formatted measures, and more.  This session focuses on showing how to use some of the latest features of PowerPivot to give your power users the tools they need to perform their own analysis of their business data.  In fact, when your users begin to use Office Excel 2013, PowerPivot is already built-in and does not require a separate download.  Stay ahead of the curve and attend this session so you can help your users effectively use this tool.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker:

Session Type:
Regular Session

Track:
Career Skills

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session Luis will cover beginning to end these two technologies key to  delivering a real time reporting. Come join him to discuss  different scenarios and some gotcha's he has learned and dealt with in real world implementations. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover the stages and steps of a data conversion project, some best practices and other considerations. The session includes information that could be useful to someone involved in planning, managing or developing a data conversion project.
Speaker:

Session Type:
Regular Session

Track:
SSIS

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you  now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
Speaker:

Session Type:
Regular Session

Track:
Reporting

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The choice of the database backend is one of the most important tasks during system design stage. This session compares various options available to users, such as on-premises SQL Server installation; Windows Azure SQL Database; Amazon Elastic Compute Cloud (EC2) and Amazon Relation Database Service (RDS). It analyzes pros, cons and platform limitations for different types of the systems, architecture and design requirements for each platform and discusses conversion of the systems from one platform to another. 
Speaker:

Session Type:
Regular Session

Track:
Cloud

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

A beginning to intermediate look at Requirements Analysis, Needs Assessment, and Software Satisfaction followup
Speaker:

Session Type:
Regular Session

Track:
Admin

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

At its heart, the DBA Repository solution employs SSIS and SSRS to centralize important SQL Server information for the DBA to analyze with ad hoc queries or reports. It was recently updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine and his book SQL Server Tacklebox, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS. Rodney will also show you how to use the fundamental package contructs so that you can easily expand the freely available project in your own environment. Two additional packages will be demonstrated, Error Log gathering and SSRS audit logs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Reporting

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology.  Discussed will be design decisions for snapshot, transactional, and merge replication.  Also discussed will be agent profiles and optimizations for replication.  What type of replication to use to solve business needs will also be covered.
Speaker:

Session Type:
Regular Session

Track:
Admin

Level: Advanced

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

No budget?  That's OK!  Need Tools?  We've get them!  Don't know where to go?  We'll show you!  The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out.  In this session we will walk through a list of twenty great tools, scripts, blogs and other resources to help you out.  Best of all, it's all free!  But wait, there's more.  Order now and we'll include an extra two tips at no additional cost!  
Speaker:

Session Type:
Regular Session

Track:
Admin

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers.  Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent.  We'll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.  This includes the biggest perpetrator, Group Policy Objects.
Speaker:

Session Type:
Regular Session

Track:
SSIS

Level: Advanced

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we'll cover an introduction to SQL Server Performance tuning. We will go through a step-by-step process to identify causes of poor-performing systems.
Speaker:

Session Type:
Regular Session

Track:
Perf Tuning

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

As we all know data is not static.  It is constantly changing, constantly moving and just moving data from one place to another is a simple enough task.  In this session Brad will explore how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files.  He will then discuss some of the DOs and DON’Ts of the SSIS ETL world.  We will discuss ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination.  Other topics: partially blocking vs fully blocking, which transforms are right for what jobs, what to avoid.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View has the capability of creating eye-popping visualizations within SharePoint 2010.  It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions.  This session walks you through creating your first Power View report and shows you how to create an impressive reporting solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The IT industry is now being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process as defined by the Project Management Institute. It will also focus on the tools that data professionals can use to deliver projects ontime and on budget.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Career Skills

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, Tom will share stories from those in the community to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Career Skills

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 45
SQLSaturday