SQLSaturday #102 - Trinidad 2011
Event Date: 11/11/2011 00:00:00
Event Location:
- Courtyard By Marriott
- Invaders Bay, Audrey Jeffers Highway
- Port of Spain, , Trinidad and Tobago
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Joe Chang
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Jason Deyalsingh
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Hasani Holder
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Rushabh Mehta
Track and Room: Track 1 - N/A
Title: What’s new in SQL Server 2012
Abstract: Taking a look at some of the new exciting features in SQL Server 2012
Speaker(s):
- Nigel Sammy
Track and Room: Track 1 - N/A
Title: Zero to BI in 10 Minutes
Abstract: The story of self-service BI
Speaker(s):
- Rushabh Mehta
Track and Room: Track 1 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Hasani Holder
Hasani Holder is a software engineer at Teleios Systems with 3 years working on the MessageCentral team. My primary usage of SQL Server is to store and retrieve messaging transaction data however I also perform analysis on that data to find patterns, trends and anomolies. Recently I’ve been toying with Microsoft Data Mining to improve that analysis.
Joe Chang
Contact: http://sqlblog.com/blogs/joe_chang/default.aspx
Nigel Sammy
Twitter: - @NigelSammy
LinkedIn: Nigel Sammy
Contact: http://www.nigelpsammy.com/
Nigel Peter Sammy is a Microsoft Data Platform MVP with over 15 years of technical experience which includes 12 years of database and SQL Server experience. Nigel previously worked at Microsoft as an Account Technology Strategist where he was responsible for providing pre-sales technical/architectural support for Commercial and Public Sector customers. He was also responsible for delivering technical presentations and proof of concepts using SQL Server, Azure and Power BI . He is a co-author of Microsoft’s SQL Server 2012 Upgrade Technical Guide and a technical editor of Wrox’s Microsoft SQL Server 2012 and 2016 Reporting Services books. For the last 9 years he has been presenting for conferences locally and internationally.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Jason Deyalsingh
Contact: http://codeue.blogspot.com/
I currently work as a web architect for CLICO. I’ve been working with SQL server for only about 5 years, but I am fascinated by the product and database systems in general.
Sponsors
The following is a list of sponsors that helped fund the event: