Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 37
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.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Remember the days when Analysis Services solely represented an OLAP engine?  Are you unclear about when to still build cubes vs. invoke the new Tabular engine in SSAS?  Do you feel confused about where the self-service capabilities of PowerPivot end and where enterprise BI begins?  If you answered YES to any of those questions, please join A.J. Mee (Principal BI Specialist at Microsoft) for some practical, real-world guidance around the three modes of SQL Server Analysis Services.  As with most of A.J.'s presentations, the vast majority of the time will be spent providing demonstrations of the technology.  Both traditional (i.e. relational) and non-traditional (i.e. unstructured/semi-structured) data sources may be incorporated into the demonstrations.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

We've heard all the awesome Cloud deployment stories, but DBAs can use the Cloud too! Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common administration problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture of both Azure and Amazon, as well as some specifics as to the components of the solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is for the Wanna be a DBA track.  It is geared toward anyone interested in starting a career as a DBA. The session will cover basic database adminstration tasks including backups, recovery, user permissions, security, and performance.
Speaker:

Session Type:
Regular Session

Track:
Track 0 - Wanna be a DBA?

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover several basic best practices that can be used when developing SSIS packages, including logging, checkpoints, and package configurations.  These best practices will provide re-usability, assist with troubleshooting, and dramatically improve your ETL work.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Perfmon is a standard windows monitoring tool available on every windows deployment.  It can provide a wealth of information about the activities within your system.  We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis.  This session will have a strong component of demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover the prerequisites for becoming a database professional. It will cover the various areas that a database professional can choose from- SQL Server developer, SQL Server Administrator, SQL report writer, ETL developer, Business Intelligence .
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 0 - Wanna be a DBA?

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you starting to plan for high availability and curious to see how clustering can keep your databases online and mitigate downtime during patching? Have you heard about clustering but have no idea what is required to build a successful cluster? If so, this session is for you.  During this session we will compare the pros and cons of Failover Cluster Instances to ensure you implement the best solution to handle you’re HA requirements. We will build a windows cluster from scratch and go over all the requirements including failover cluster manager, nodes, shared storage, active directory, client access points, quorums and installing a SQL Server clustered instance.  Finally, we will go over a basic framework to help you quickly perform a root cause analysis to determine why your SQL services went down.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Closing Remarks and Raffle
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

We will cover the fundamentals of an RDBMS and go over a basic database design session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 0 - Wanna be a DBA?

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

You've designed your application, built it up, and it's working great.  One of the last features to implement is searching and reporting.  You think you can get away with just implementing some SQL LIKE statements for an initial search, but you need to search across many fields or perform faceted searches.  You've put it off because you really don't want to deal with SQL Server Full-Text Indexing - maybe it's not your cup of tea or maybe it's just intimidating or maybe you're not using SQL Server.  But there are alternatives to Full-Text Indexing that can be just as powerful and fairly simple.  SOLR is one such open source tool to help you with your application's searching needs.  We'll take a look at the SOLR project, how you can get it up and running very easily, how you can install it as a Windows Service (as opposed to a command window), and how you can use SOLR.net to program against it.  We'll look at basic searches along with some cool features like faceting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable, all while helping clients increase organizational performance. With the recent release of SQL 2012, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL 2012 self-service reporting and talk about creating blended value from your BI platform.  We’ll show you why the combination of Microsoft Office 2013, SharePoint Server 2013 and SQL Server 2012 are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery, collaborative.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

“’More CPU/More Memory/More Spindles” has been the mantra for increasing performance for SQL Server environments that are resource bound.  This often leads to complicated file placements, complicated LUN/disk striping, complex partitioning schemes and creative resource handling.  Storage has been the last area of hardware technology that has improved performance for enterprise systems, but now the next generation of storage is here… Flash and it’s available and practical for database systems!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

We will query the database that we just designed covering basic selects, joins, functions, aggregates etc.
Speaker:

Session Type:
Regular Session

Track:
Track 0 - Wanna be a DBA?

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Although this session is part of the "Wanna be a DBA?" track, it also serves those who "Wanna be a Business Intelligence Developer." We'll discuss the life cycle of data, how it relates to reporting, and learn how to create a simple SSRS (SQL Server Reporting Services) report.
Speaker:

Session Type:
Regular Session

Track:
Track 0 - Wanna be a DBA?

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs!  From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project).  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

We have all had requirements for a procedure based upon many parameters that may or may not contain a value. These are typically seen as the code behind a search screen. The end users need to do this regularly, and they can be real performance killers.

This session will provide a number of different ways to handle "sometimes" queries, and provide techniques to make these perform faster.

Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

It is easy to schedule full backups to run each night, but is that the right decision for your organization?  You say you have a backup strategy, but what is your recovery strategy?  Do you have a well-executed recovery plan?  In this session I will cover several methods for performing much needed backups and how to recover those backups.  Full, Differential, File Group, Transaction logs and recovery the tail end of a the log.  He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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