SQLSaturday #25 (Sat) - Gainesville 2009
Event Date: 10/10/2009 00:00:00
Event Location:
- Gainesville State College
- 3820 Mundy Mill Rd
- Gainesville, Georgia
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: SQL Application in Geographic Information Systems
Abstract: This session relates to the SQL application in Geographic Information System (GIS). ArcGIS software users are using SQL Server 2008 for the advancement of their computing and geospatial decision making. SQL Server 2008 supports ArcGIS users with tools they need to seamlessly use and extend spatial analysis for enterprise-based computing and webGIS development. The use of SQL service in managing the data intensive GIS’s geodatabase is very well known. In this session, application of SQL software in geospatial application will be presented with a real world example. It would suggest how SQL application is advancing GIS. The real world application is about a “Tree-inventory WebGIS development for Gwinnett Technical College.”
Speaker(s):
- Sudhanshu Panda
Track and Room: GIS/BI/Special - N/A
Title: DBA vs ORM: Strategies for Data in a Code Focused
Abstract: Microsoft released LINQ, LINQ to SQL, Entity Framework, and ADO.NET Data Services (Astoria) that are a few of many technologies that have dramatically changed how developers think about accessing data. This gives code-focused data access a big endorsement, but what implications exist for the data? How is authentication/authorization handled? Is performance good and how does optimization fit into the approach? This session will give an overview of the mechanics of how the technologies work, the pros/cons with the solutions produced, and include a frank discussion of the associated political struggles that may be created from ignorance and improper optimizations.
Speaker(s):
- Cliff Jacobson
Track and Room: GIS/BI/Special - N/A
Title: Leveraging SQLDiag for Efficient Troubleshooting
Abstract: Over the years, Microsoft Customer Service and Support (formerly known as Product Support Services) has developed a number of amazing tools for troubleshooting SQL Server. Thankfully, many of these tools have been shared with the public. Trevor will demonstrate the configuration and usage of PSSDiag (for SQL Server 2000) and SQLDiag (for SQL Server 2005 and 2008), which are for collecting a variety of useful diagnostic data. Then he will cover analyzing the data using RML Utilities as well as a few scripts of his own. Come and see how these tools can save you massive amounts of troubleshooting time!
Speaker(s):
- Trevor Barkhouse
Track and Room: DBA - N/A
Title: SQL Server Full Text Searching - An Introduction.
Abstract: Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it’s as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
Speaker(s):
- Robert Cain
Track and Room: Development - N/A
Title: Deadlock Detection, Troubleshooting, Prevention
Abstract: As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, and 2008.
Speaker(s):
- Trevor Barkhouse
Track and Room: DBA - N/A
Title: Introduction to SQL Server Integration Services
Abstract: SQL Server Integration Services is Microsoft’s powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for BI but for data conversion as well.
Speaker(s):
- Robert Cain
Track and Room: Development - N/A
Title: Data Persistence in a Web Hosted World
Abstract: Living in the hosted world takes patience and knowlege of the environment. Learn what it takes to survive in a world where you don’t own your servers and have to adapt your code and practices to a restricted habitat. Just what are your options for storing data in a web-world for a low, monthly fee? Geared towards start-ups, groups, and individuals who want to use the Microsoft stack of web and database technologies.
Speaker(s):
- Jeff Ammons
Track and Room: DBA - N/A
Title: Data Visualization and High Value Low Cost BI
Abstract: My talk is geared to all levels of technical proficiency. Beginners through advanced. The beginner will gain insight into the world of high value low cost business information and my incremental approach to linking data visualization to Excel, Access and eventually MS SQL Server.
The advanced database professional will gain insight into the value of appropriate and context aware visual analytics. My speech includes 30 minutes of live ad hoc visual analysis with practical commentary gained from personal experience implementing the tools and methods for many clients over the past two years.
Speaker(s):
- Dan Murray
Track and Room: GIS/BI/Special - N/A
Title: Student Showcase Session 1
Abstract: This session will highlight student presentation in the areas of GIS and/or SQL-related topics.
Speaker(s):
- More College Students
Track and Room: GIS/BI/Special - N/A
Title: The Social DBA: Resources for Career Building
Abstract: As the Internet has matured, several resources are available for database professionals to share ideas and build their own careers. This session is intended to identify and explore those resources, and help attendedees become more connected to the SQL Server community at large. Special attention will be paid to the following topics: building a blog, Twitter, and online forums.
Speaker(s):
- Stuart Ainsworth
Track and Room: DBA - N/A
Title: GIS Certificate Program at IESA
Abstract: Discover the requirements to get your certification in Geographic Information Systems to supplement your career.
Speaker(s):
- Chris Semerjian Allison Ainsworth
Track and Room: DBA - N/A
Title: SQL Server Backups
Abstract: In this session we will go over backup and restore basics for all versions of SQL Server and take a look at database compression in SQL Server 2008.
Speaker(s):
- Neal Waterstreet
Track and Room: DBA - N/A
Title: Cool Tricks to Pull from your SSIS Hat—
Abstract: Cool Tricks to Pull from your SSIS Hat—Variables, For Each Loops, and the SSIS Expression Language.
This presentation will cover in-depth how to dynamically control files being sent through a For Each Loop. I’ll cover using the SSIS Expression Language to dynamically create and name file destinations, the many uses of variables in SSIS, using the SSIS Expression Language to control Variable values, creating meaningful audit data, and using the ADO Object type in a For Each loop.
Speaker(s):
- Julie Smith
Track and Room: Development - N/A
Title: CLR integration
Abstract: Integrating CLR assemblies into SQL Server to enabled support custom image creation and encompassing complex business logic in SQL server/SSRS. Other common usages of CLR asseblies will be also covered.
Speaker(s):
- Sergey Barskiy
Track and Room: Development - N/A
Title: The T-SQL Trifecta: Enhancements for Everyone
Abstract: There have been many useful enhancements to T-SQL provided with SQL Server 2008 and 2005. Come learn about three of them: MERGE, TRY…CATCH, and multi-row INSERT statements. If you’ve ever written an UpSert, given yourself carpal tunnel syndrome cutting and pasting INSERT statements, or conveniently forgotten to write in robust error handling because it was too cumbersome, find out how T-SQL can work better for you and for your code.
Speaker(s):
- Audrey Hammonds
Track and Room: Development - 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 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.
Dan Murray
Contact: http://www.thedatarevolution.com
Dan has a diverse background in accounting, finance, operations and information technology. Currently, he’s the Chief Operating Officer of Microsoft Gold Partner, InterWorks Inc., a full-service technology consultancy. Dan’s initial work in visual analysis occurred in 2007 while the VP CIO of Blastrac Inc when he developed a High Value, Low Cost BI solution using Excel and MS SQL Server in conjunction with Tableau Software.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Sergey Barskiy
Contact: http://DotNetSpeak.com
Sergey Barskiy is an architect with Tyler Technologies. He is a Microsoft MVP. He holds the following certifications: MCPD, MCTS, MCSD for .NET, MCAD for .NET, MCDBA, MCP. He has been working with Microsoft technologies for 15 years. He is a frequent speaker at various regional and national conferences, such as VS Live, DevLink, CodeStock, and Atlanta Code Camp as well as local user groups. He is one of the organizers of Atlanta Code Camp and Atlanta Windows Apps users group.
Neal Waterstreet
Twitter: - @nealwaterstreet
LinkedIn: Neal Waterstreet
Contact: http://www.nealwaterstreet.com
Neal is a BI Architect/Consultant with more than 20 years of industry experience. Neal is skilled in the entire BI spectrum, including dimensional modeling, ETL design and development using Integration Services (SSIS), designing and developing multidimensional cubes and Tabular models using Analysis Services (SSAS) and Master Data Management using Microsoft Data Services (MDS). He’s also involved with the database community and is the co-founder and co-leader of the PASS Healthcare Virtual Chapter and the Atlanta Modern Excel User Group.
Trevor Barkhouse
Trevor Barkhouse is Support Escalation Engineer for Microsoft Corporation, on the team that supports SQL Server. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, CodeStock 2011, and two PASS Community Summits (North American).
Cliff Jacobson
Cliff is a senior developer at Visioneering Games, a casual games company in Atlanta. Cliff spans the range of WPF, WinForm, WebForm, and TSQL development with a preference for C# in ASP.NET Cliff is a former MCT, a regular at many Atlanta area user groups, and has presented on many new technologies from Microsoft.
Stuart Ainsworth
Twitter: - @codegumbo
LinkedIn: Stuart Ainsworth
Contact: http://codegumbo.com
Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.
Trevor Barkhouse
Trevor Barkhouse is Support Escalation Engineer for Microsoft Corporation, on the team that supports SQL Server. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, CodeStock 2011, and two PASS Community Summits (North American).
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.
Jeff Ammons
Contact: http://http://ammonsonline.com/jeffablog
Jeff works as a Developer/DBA for the Atlanta Journal-Constitution. He has worked with lots of technologies over the years including Java and Oracle PL/SQL in addition to the .Net stack (ranging from Windows Mobile to MVC). He is President of the Gwinnett, Georgia, Microsoft User Group (GGMUG.com).
**Chris Semerjian Allison Ainsworth **
Contact: http://www.gsc.edu/iesa
Chris Semerjian is the Assistant Director of the Institute for Environmental and Spatial Analysis (IESA) at Gainesville State College, and is an expert in geospatial analysis. Allison Ainsworth is a member of the teaching faculty at IESA, and specializes in environmental communication.
Audrey Hammonds
Contact: http://www.linkedin.com/in/audreyhammonds
Audrey Hammonds is the Senior Database Architect at The Network, Inc. Fourteen years ago, she volunteered for DBA training to escape COBOL, and never looked back. A firm believer that good fundamentals and solid design can save a database professional’s sanity, she has devoted much of her career to designing (hopefully) elegant databases and straightening up others’ not-so-elegant databases. Audrey has run the gamut from Database Developer to Production DBA to Architect.
More College Students
TBA
Sudhanshu Panda
Contact: http://www.gsc.edu/academics/divisions/iesa/faculty/Pages/InformationTechnology.aspx
Dr. Sudhanshu Sekhar Panda, GISP is an Asst Prof, GIS/Env. Sci. at Gainesville State College. He has his BS in Ag. Engg. from India. His MS in Environmental Remote Sensing for GeoInformation Development (ERGD) was from Asian Institute of Technology, Bangkok, Thailand. He has his PhD in Ag. Engg. from NDSU, Fargo, North Dakota. His expertise include soil and water engineering, Geospatial technology, data mining, environmental modeling, DSS development, IT application in environmental area
Sponsors
The following is a list of sponsors that helped fund the event: