sqlsathistory

Nr: 123

Back to Main list

SQLSaturday #123 - Western Cape 2012

Start Time (24h) Speaker Track Title
00:00:00 Brian Knight DBA What’s in SQL Server 2012 for the DBA?
00:00:00 Brian Knight BI What’s New in BI in SQL Server 2012
00:00:00 Brian Knight DEV Performance Tuning SQL Server Integration Services
00:00:00 Torque-IT Torque-IT BI TBA - Presented by Torque-IT
00:00:00 Gary Hope DBA SQL 2012 High Availabilty
00:00:00 Saratoga Software BI BI LifeCycle
00:00:00 Mark Stacey DBA BI for the DBA - DeepDive
00:00:00 Alain King DEV Agile for Developers

SessionID: 10506

What’s in SQL Server 2012 for the DBA?

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Brian Knight

Title: What’s in SQL Server 2012 for the DBA?

Abstract:

In this session, you’ll learn how the new SQL Server 2012 features like Always On will help you create a better high availability experience for your users and applications. Then, you’ll learn about the new table types (file table) and how you can use it to create a better content management system. Lastly, we’ll cover new indexing strategies that SQL Server 2012 now allows called Column Store indexes to potentially give your queries a 500x boost!

SessionID: 10507

What’s New in BI in SQL Server 2012

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: BI

Speaker: Brian Knight

Title: What’s New in BI in SQL Server 2012

Abstract:

In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named SQL Server 2012. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the Tabular Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.

SessionID: 10508

Performance Tuning SQL Server Integration Services

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: DEV

Speaker: Brian Knight

Title: Performance Tuning SQL Server Integration Services

Abstract:

In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server's resourcing. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient.

SessionID: 11398

TBA - Presented by Torque-IT

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: BI

Speaker: Torque-IT Torque-IT

Title: TBA - Presented by Torque-IT

Abstract:

TBA - Presented by Torque-IT

SessionID: 14393

SQL 2012 High Availabilty

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Gary Hope

Title: SQL 2012 High Availabilty

Abstract:

Loooks at SQL 2012 High Availabilty

SessionID: 17772

BI LifeCycle

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: BI

Speaker: Saratoga Software

Title: BI LifeCycle

Abstract:

A 3 way approach to BI

SessionID: 31720

BI for the DBA - DeepDive

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Mark Stacey

Title: BI for the DBA - DeepDive

Abstract:

Business Intelligence requirements create a completely different workload to a traditional SQL implementation - both in terms of the load placed upon the infrastructure, as well as the load placed upon the database engine itself.

As BI adoption grows, DBAs are going to be expected to maintain and enhance both the BI infrastructure, and make sure that the databases support the requirements adequately. In this session, Mark will dive into the tradeoffs of various architectures for a BI platform, and work through the nuances of managing SSIS, SSAS and SSRS, both in terms of administering the instances, and also cover how a BI workload differs from an OLTP workload

SessionID: 9176

Agile for Developers

Back to calendar

Event Date: 03-03-2012 - Session time: 00:00:00 - Track: DEV

Speaker: Alain King

Title: Agile for Developers

Abstract:

We will look at what Agile Software development means and then look at some examples of the benefits that our developers have seen by working in an Agile environment