sqlsathistory

Nr: 25

Back to Main list

SQLSaturday #25 (Sat) - Gainesville 2009

Start Time (24h)	Speaker	Track	Title
00:00:00	More College Students	GIS/BI/Special	Student Showcase Session 1
00:00:00	Robert Cain	Development	Introduction to SQL Server Integration Services
00:00:00	Robert Cain	Development	SQL Server Full Text Searching - An Introduction.
00:00:00	Julie Smith	Development	Cool Tricks to Pull from your SSIS Hat—
00:00:00	Cliff Jacobson	GIS/BI/Special	DBA vs ORM: Strategies for Data in a Code Focused
00:00:00	Chris Semerjian Allison Ainsworth	DBA	GIS Certificate Program at IESA
00:00:00	Dan Murray	GIS/BI/Special	Data Visualization and High Value Low Cost BI
00:00:00	Audrey Hammonds	Development	The T-SQL Trifecta: Enhancements for Everyone
00:00:00	Jeff Ammons	DBA	Data Persistence in a Web Hosted World
00:00:00	Neal Waterstreet	DBA	SQL Server Backups
00:00:00	Sergey Barskiy	Development	CLR integration
00:00:00	Sudhanshu Panda	GIS/BI/Special	SQL Application in Geographic Information Systems
00:00:00	Trevor Barkhouse	DBA	Deadlock Detection, Troubleshooting, Prevention
00:00:00	Trevor Barkhouse	DBA	Leveraging SQLDiag for Efficient Troubleshooting
00:00:00	Stuart Ainsworth	DBA	The Social DBA: Resources for Career Building

SessionID: 28368

Student Showcase Session 1

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: GIS/BI/Special

Speaker: More College Students

Title: Student Showcase Session 1

Abstract:

This session will highlight student presentation in the areas of GIS and/or SQL-related topics.

SessionID: 28756

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: Development

Speaker: Robert Cain

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.

SessionID: 28757

SQL Server Full Text Searching - An Introduction.

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: Development

Speaker: Robert Cain

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.

SessionID: 29361

Cool Tricks to Pull from your SSIS Hat—

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: Development

Speaker: Julie Smith

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.

SessionID: 29557

DBA vs ORM: Strategies for Data in a Code Focused

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: GIS/BI/Special

Speaker: Cliff Jacobson

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.

SessionID: 29665

GIS Certificate Program at IESA

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Chris Semerjian Allison Ainsworth

Title: GIS Certificate Program at IESA

Abstract:

Discover the requirements to get your certification in Geographic Information Systems to supplement your career.

SessionID: 29693

Data Visualization and High Value Low Cost BI

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: GIS/BI/Special

Speaker: Dan Murray

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.

SessionID: 30293

The T-SQL Trifecta: Enhancements for Everyone

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: Development

Speaker: Audrey Hammonds

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.

SessionID: 30672

Data Persistence in a Web Hosted World

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Jeff Ammons

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.

SessionID: 32118

SQL Server Backups

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Neal Waterstreet

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.

SessionID: 32883

CLR integration

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: Development

Speaker: Sergey Barskiy

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.

SessionID: 32975

SQL Application in Geographic Information Systems

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: GIS/BI/Special

Speaker: Sudhanshu Panda

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."

SessionID: 33728

Deadlock Detection, Troubleshooting, Prevention

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Trevor Barkhouse

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.

SessionID: 33729

Leveraging SQLDiag for Efficient Troubleshooting

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Trevor Barkhouse

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!

SessionID: 35452

The Social DBA: Resources for Career Building

Back to calendar

Event Date: 10-10-2009 - Session time: 00:00:00 - Track: DBA

Speaker: Stuart Ainsworth

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.

This site is open source. Improve this page.