SQLSaturday #4 Tweener(Sat) - Orlando 2008
Event Date: 06/07/2008 00:00:00
Event Location:
- Orange County Convention Center
- 9990 International Drive
- Orlando, Florida
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: Using DDL Triggers
Abstract: In this session we’ll create a database object (table, proc, functions) backup system using DDL Triggers in SQL Server 2005. This system is beneficial to both DBA’s and developers.
Speaker(s):
- Chris Rock
Track and Room: SQL for DBA’s - N/A
Title: SOA Using SQL Server 2005 Service Broker
Abstract: This session will introduce the Service Broker in SQL Server 2005. During this session we will discuss an overview of Service Broker architecture and delve into the objects needed to create a Service Broker solution. Finally, we will build a sample solution from start to finish using the Adventureworks database.
Speaker(s):
- Judy Pipia
Track and Room: SQL for Developers - N/A
Title: Using SSIS to Solve Common Business Problems
Abstract: SSIS is a powerful tool used to automate data integration. Come learn about SSIS and how you can use it in your organization to solve common business problems.
Speaker(s):
- Wes Dumey
Track and Room: Business Intelligence - N/A
Title: SQL Server 2008 New Feature Overview
Abstract: Learn what’s new in SQL Server 2008 for the DBA, Developer and BI professional. This session is demo-packed with the best features of why you should upgrade to SQL Server 2008.
Speaker(s):
- Brian Knight
Track and Room: SQL for DBA’s - N/A
Title: Introduction to Master Data Management (MDM)
Abstract: This session will provide an overview of the Master Data Management and also introduce the business value of MDM.In addition, we will look at Microsoft’s master data management software.
Speaker(s):
- Rushabh Mehta
Track and Room: Business Intelligence - N/A
Title: Using CASE in TSQL
Abstract: Most languages support an extended version of the IF/THEN syntax and in TSQL it’s CASE. It’s syntax is a little finicky and to add to the confusion there are two different ways to use it! We’ll look at how to use it both ways and show how it contrasts with the IF/THEN syntax. This is a beginner level session.
Speaker(s):
- Michael Antonovich
Track and Room: SQL for Developers - N/A
Title: CLR User Defined Functions - Real World Examples
Abstract: This exciting session will talk about why CLR UDF’s are a good choice in many cases, why using UDF’s will simplify your code, and then go into setting up environments for testing and debugging. We’ll also be discussing a few hard learned tips and tricks that will help you when you start using UDF’s.
Speaker(s):
- Jon Winer
Track and Room: SQL for Developers - N/A
Title: Analysis Services 2005 – Tips Tricks
Abstract: A collection of examples for MDX, cube processing, dimension and hierarchy designs, aggregation designs, and security modeling, for the everyday developer. Accelerate your development with these samples!
Speaker(s):
- Robert Skoglund
Track and Room: Business Intelligence - N/A
Title: Introduction to SQL Server Full Text Searching
Abstract: Microsoft SQL Server contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries could include words and phrases or multiple forms of a word or phrase. Come learn how to setup your own “Windows Live” like searches in your applications. Give your users search capabilities into their data. It’s as easy as 1-2-3!
Speaker(s):
- Robert Cain
Track and Room: SQL for DBA’s - N/A
Title: Home Runs and DMX, Intro to Microsoft Data Mining
Abstract: This session is intended to utilize the steroid era of baseball to introduce attendees to data mining with Microsoft technologies. The demonstration-oriented session will create data mining models, evaluate their effectiveness, and demonstrate accessing data mining model results using Data Mining Add Ins for Office 2007. Finally, in the spirit of the scientific method, all data will be available to attendees with which to attempt re-creation of the experiments / examples.
Speaker(s):
- Barry Ralston
Track and Room: Business Intelligence - N/A
Title: XML Features in SQL 2005
Abstract: XML in SQL 2000 wasn’t very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn’t a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!
Speaker(s):
- Kendal Van Dyke
Track and Room: SQL for Developers - N/A
Title: Statistics in SQL Server
Abstract: Ever wonder what statistics have to do with performance? How to create and maintain them? What does it mean when someone says “the stats were corrupted”? We’re going to explain all that in more in this session that will take a topic that often seems dense and complex and make it approachable and usable!
Speaker(s):
- Andy Warren
Track and Room: SQL for DBA’s - 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.
Robert Skoglund
Robert Skoglund – Microsoft Worldwide Business Intelligence Technical Community Lead and Technical Lead for Enterprise Services Big Data Strategy – has deep knowledge of the Microsoft products required for delivering enterprise-class BI and data warehousing solutions. With experience implementing both MSF and SCRUM project management principles, he has implemented successful BI, DW, system integration, and application development solutions. Robert joined Microsoft in 2001 and has worked in many client-facing consultancy roles in the retail, financial services, and manufacturing sectors.
A PASS member, Robert hosts a monthly BI User Group at the Microsoft office in his home town. He was one of the first independent Microsoft Certified Trainers (circa 1994), and regularly presents technical sessions at such events as TechReady, xDM, TechEd North America, and SharePoint Connections.
Brian Knight
Contact: http://www.pragmaticworks.com
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was recently on the Board of Directors of the Professional Association for
Judy Pipia
Judy is an independent consultant and MCT with the MCAD, MCSD, MCTS:SQL Server 2005, MCITP: Database Development certifications. Currently, Judy is teaching for Microsoft Certified Learning Providers across the country.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Michael Antonovich
Twitter: - @MPAntonovich
LinkedIn: Michael Antonovich
Contact: http://sharepointmike.wordpress.com
Mike Antonovich is the Assistant Director of Web Services for Orange County Public Schools, Orlando, FL, overseeing the SharePoint Portal and .NET applications team. Mike has been using SQL since 1998 and SharePoint since 2007 and has a passion for all topics BI. He#39;s spoken at over 25 SQLSaturday events since the first one in Orlando. He has published seven computer books ad has spoken at two PASS Summits on BI related topics.
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
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Jon Winer
Contact: http://www.channelintelligence.com
Jon Winer is a Senior Developer with Channel Intelligence specializing in C#, XML, and SQL Server. Jon has more than 10 years experience as a developer and enjoys finding pragmatic ways to employ the latest bits of technology.
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Chris Rock
Chris Rock is a developer, DBA, and trainer for End to End Training. Chris is a frequent presenter at area Code Camps and has written several articles on SQLServerCentral.com and SQLTeam.com. He also blogs about all things SQL and .Net related at http://www.rocksthoughts.com
Wes Dumey
Contact: http://www.durableimpact.com
Wes is a Senior Consultant with Durable Impact Consulting, a Florida-based data warehouse and business intelligence firm. Wes has over 10 years experience working with clients around the world, both large and small, on their business intelligence and operational needs.
Barry Ralston
Contact: http://www.sqlbipro.com
Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft Corporation’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida in sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.
Sponsors
The following is a list of sponsors that helped fund the event: