Event Location:
Gainesville State College
3820 Mundy Mill Rd
Gainesville, Georgia
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
This session will highlight student presentation in the areas of GIS and/or SQL-related topics.
Speaker(s): More College Students,
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,
Abstract:
Discover the requirements to get your certification in Geographic Information Systems to supplement your career.
Speaker(s): Chris Semerjian Allison Ainsworth ,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/arcanecode
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.
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.
LinkedIn: http://www.linkedin.com/in/juliesmith0503/
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.
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.
LinkedIn: http://www.linkedin.com/in/nealwaterstreet
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 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 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.
LinkedIn: https://www.linkedin.com/in/stuartainsworth
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 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).
LinkedIn: http://www.linkedin.com/in/arcanecode
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.
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).
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.
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.
TBA
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
The following is a list of sponsors that helped fund the event.