sqlsathistory

Nr: 102

Back to Main list

SQLSaturday #102 - Trinidad 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Hasani Holder	Track 1	Microsoft Data Mining Fundamentals
00:00:00	Jason Deyalsingh	Track 1	Database Integrity
00:00:00	Joe Chang	Track 1	Performance for SMB Developers - 2011
00:00:00	Nigel Sammy	Track 1	What's new in SQL Server 2012
00:00:00	Rushabh Mehta	Track 1	Zero to BI in 10 Minutes
00:00:00	Rushabh Mehta	Track 1	Journey into Business Intelligence

SessionID: 30298

Microsoft Data Mining Fundamentals

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Hasani Holder

Title: Microsoft Data Mining Fundamentals

Abstract:

In the book, Data Mining with Microsoft SQL Server 2008, the author defines data mining as “the process of analyzing data to find hidden patterns using automatic methodologies”. In this session, we will look at what data mining is and what are some advantages of using it. We will also take a look at what data mining can do for you by reviewing some of the problems that it can be used to address and the cost of implementing it. I will demonstrate how easy it is to use SQL Server Analysis Services (SSAS) and Business Intelligence Development Studio (BIDS) to build and analyze models using existing data.

SessionID: 30493

Database Integrity

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Jason Deyalsingh

Title: Database Integrity

Abstract:

Maintaining database integrity is an important part of every DBA's job. As with all things I.T, things do go wrong, and it's important to know how to respond to database corruption problems if they ever occur. This presentation will give a basic overview of how databases are made up, how corruption can occur, the different types of database corruption and the built-in tools SQL server has for dealing with these issues.

SessionID: 30591

Performance for SMB Developers - 2011

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Joe Chang

Title: Performance for SMB Developers - 2011

Abstract:

Is performance still important today, with powerful systems and storage, especially in small and medium business environments? The popular concept “code reuse” misinterpreted in SQL has catastrophic consequences. The cost based optimizer, a cornerstone of modern database engines, can lead to seriously bad execution plans. The immense power of modern system is distribute of many processors cores. The database must be designed for scalable parallel execution plans to benefit from modern system architecture. Finally, random IO performance appears to be solved with SSD. Well, now it is time to admit that there are CPU elements of disk IO that are not solved by SSD storage with immense IOPS capability.

SessionID: 32077

What's new in SQL Server 2012

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Nigel Sammy

Title: What's new in SQL Server 2012

Abstract:

Taking a look at some of the new exciting features in SQL Server 2012

SessionID: 32536

Zero to BI in 10 Minutes

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Rushabh Mehta

Title: Zero to BI in 10 Minutes

Abstract:

The story of self-service BI

SessionID: 32537

Journey into Business Intelligence

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Track 1

Speaker: Rushabh Mehta

Title: Journey into Business Intelligence

Abstract:

In this session we will talk about what Business Intelligence (BI) is and show various technologies that play a role into building a BI solution. Demonstrations will be done to show how to build a basic SSAS cube from scratch.

This site is open source. Improve this page.