Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 33
Integration Services in SQL Server 2012 gives DBAs and BI developers new features that save time and money in terms of development and management. Whether you're automating DBA tasks, ETL processes, or System Integrations, SSIS has something for everyone. 

Come learn about:

-Improvements in the design interface 
-SSIS Parameters 
-Easier Deployment with the SSIS Catalog 
-New Standard Reports for monitoring SSIS 
-New ways to control SSIS on the server. 

If you're on SQL Server 2008, not to worry. I will show you an additional 3rd party tool that gives you a lot of this functionality. But nothing beats the ROI with SSIS 2012.
Speaker:

Session Type:
Regular Session

Track:
Quest/Dell Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online.  Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot!  Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
Speaker:

Session Type:
Regular Session

Track:
Quest/Dell Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL 2012 AlwaysOn Availability Groups is a new unified High availability(HA) and disaster recovery(DR) solution introduced in SQL 2012.  This solution is an answer to both HA and DR requirements that is flexible, integrated, and easy to deploy. You'll see a demo that includes: •Setting up the Availability Group •Setting up multiple secondaries •Manual Failover •Automated Failover •AG Listener •and much more... You'll learn: •How to set up, manage, and maintain Availability groups in SQL 2012 •Create availability group failovers between data centers •How to utilize the replicas for backup and other tasks
Speaker:

Session Type:
Regular Session

Track:
Quest/Dell Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will introduce big data analytics for the business analyst with PowerPivot and Power View. It will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in Excel 2013.

Demonstrations will include creating a big data solution by using HDInsight Server; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with local data; and, analyzing the PowerPivot model data by using Power View.
Speaker:

Session Type:
Regular Session

Track:
Red Gate Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn from a Microsoft Certified Master how to secure your SQL Server
 infrastructure and your Windows installations to enhance resiliency
 and minimize exposure to attacks—all without touching any of your
 code!
Speaker:

Session Type:
Regular Session

Track:
SIOS Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. You will discover how DQS sets itself apart from conventional data cleansing routines and go through examples on how to begin your own Data Quality Project which includes data cleansing and deduplication. But what really makes DQS unique and powerful is its ability to access shared knowledge, so we will show you how to access and use this shared knowledge to your benefit
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Red Gate Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration. 

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Quest/Dell Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Just about anyone can click through a SQL Server installation and get it working. But, it is not running close to efficient, and as the workloads grow, it will only get worse. This session by David Klee (@kleegeek) provides valuable details on how to tweak and tune your SQL Server installations to ensure maximum performance, as well as tips on capacity management so you know when you need to add more hardware to take your server to the next level.
Speaker:

Session Type:
Regular Session

Track:
Nimble Storage Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker:

Session Type:
Regular Session

Track:
Nimble Storage Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Maybe your job consists of setting up security and dealing with backups. Maybe you're a DBA who supports multiple teams in development, QA, and production. Or maybe your day is spent attending meetings, setting up new servers, designing new apps, supporting old apps, and dealing with the myriad sources of pain that make up the daily life of most DBAs. This entertaining lunch-time session explains how Red Gate's tools can take the pain out of the difficult, time-consuming tasks you face each day.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Red Gate Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

The leading edge Hybrid storage technology can significantly impact SQL application performance by providing Cache Accelerated IOPS at extremely low solid state latency.  In this session you’ll learn:·         How hybrid storage architecture benefits datacenter applications·         What are the SAN features that can accelerate data protection and recovery operations·         Instant and zero space re-purposing tools that have minimal to no disk overhead·         SQL application integration
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Nimble Storage Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This lunch session will serve to introduce the audience to high level challenges that face SQL Server DBA's, and how third party solutions can help.  Specific examples and use cases will be provided to demonstrate Dell Software solutions.  Specific challenges are Performance Management, Query Optimization and Tuning, and Backup and Recovery will be discussed.  The session will wrap up with a demonstration of Dell's freeware offerings for SQL Server, providing all attendee's with software they can take with them to immediately assist with complex and time consuming database problems.Tools to be discussed:Spotlight on SQL Server EnterprisePerformance Analysis for SQL ServerLiteSpeed for SQL ServerToad for SQL Server - FreewareProject Lucy - Freeware
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Quest/Dell Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SIOS Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything?  Log file obesity is a problem that can challenge DBAs of any level.  This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.  
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

A recent survey by Information Week found that data quality is the greatest barrier to BI adoption in enterprises.  MDS addresses this challenge with modeling, validation, alerting and security capabilities.  In this presentation, you will learn how to use MDS to model your data to ensure correctness, update it with changes from your ERP, and create workflows with notifications.  Next you will learn the capabilities of DQS and see how it addresses data standardization, completeness and other challenges.  You will then see how to use them together to enable Enterprise Information Management.  BI professionals will come away with knowledge on how to use tools that address the greatest risk to success for BI projects - data quality.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Nimble Storage Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you suffering from High CPU, Low Memory, Query Timeouts, Decreasing Page Life Expectancy, CXPACKET Waits, or just a slow running application?  I'll show you how to become a "Read Hunter" to track down top logical reads queries bringing down your SQL Server performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SIOS Room

Level: Advanced

Session Code:

Date: July 27

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. We will then see how to use Reporting Services to present data with a minimum amount of latency.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SIOS Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services Report Manager provides a great web platform for managing and delivering many types of reports. We will review delivering reports with Report Manager and explore integrating SSRS as the engine for report presentation within web and windows applications. We will also look at  options to feed reports to your document management system and push reports to the cloud for remote access and mobile devices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SIOS Room

Level: Intermedia

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Ready to begin your first SQL Database application?  Wondering what others have learned as the moved data into the cloud?  I'll cover best practices you'll need while planning your move to SQL Database in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Red Gate Room

Level: Beginner

Session Code:

Date: July 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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