Thank you all for attending my session here are the files to download and get stated with spatial data with SQL Server 2008 and Virtual Earth.

Everything (PPT,ASP.NET,Database)

Just the ASP.Net code

Just database backup

Just the script to build the database

Just the PowerPoint

Bing Maps AJAX SDK

Bing Maps Silverlight SDK

Aggregated data according to your business needs.  It is optimized for business terms.  For example, Rolling numbers by quarter.

Zero to Cube in 60 Minutes

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.

Adam Jorgensen(website), President – Pragmatic Works Consulting - has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups and other organizations. He regularly speaks at industry group events, Code Camps, and SQLSaturday events on strategic and technical topics.

Fact Tables – Actual facts such as sales, orders, or donations.

Dimension – any that starts with the word “by”.  For example, Sales by state or orders by gender.

Power Pivot (Website)

In this session we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

Chad Miller(website) is a SQL Server DBA and Manager of Database Administration at Raymond James Financial. He has 10 years experience as DBA, working with SQL Server 6.5 through SQL Server 2008. In his spare time Chad is the Project Coordinator/Developer of Codeplex projects SQL Server PowerShell Extensions (SQLPSX) and PoshRSS.

Tampa PowerShell user group www.tampapowershell.com/

Joe Healy’s TweetPhoto HERE

Troy Gallant (greatfuldba on Twitter) his website on Twitter

Troy offered a good overview of Transactional Replication in SQL Server. 

Microsoft uses a Magazine Publisher metaphor for labeling the various pieces. 

SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some of the primary reasons to employ replication include load balancing, offline processing & redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.

Troy has been a SQL Server professional for over 6 years The first four were in the role of a developer, and the last two as DBA for an international organization of over 900 employees. When not working, Troy enjoys MMO's, the Grateful Dead, and whiling away the hours picking his mandolin.

-----

PowerShell

Functions can be used from various areas and used in unexpected areas.

In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet using PowerShell.

Aaron Nelson(website) is a Senior SQL Server Architect, Database Developer, DBA, and Business Intelligence Developer with over 10 years experience in the architecture, design, development and maintenance of SQL Server. He is experienced managing enterprise-wide data needs in both transactional and data warehouse environments.

As promised here are the slides from the presentation.

PowerPoint Slides

PDF version on the slides

October 17, 2009

This session is …

a quick tour of the spatial features of SQL Server 2008

PowerPoint slides 

PowerPoint as PDF

Tyler Chessman's article in SQL Server Magazine's December 2008 issue is my primary source of information to implement my spatial solutions. Visit http://www.sqlmag.com and search for instant doc ID 100528.

Here is a link to the article

What is Spatial Data

• Spatial data represents the shape and physical location of an object.
• The object can be a house, business, sub-division, or a county.
• SQL Server 2008 has two new data types GEOMETRY and GEOGRAPHY.
• GEOMETRY works with flat objects.
• GEOGRAPHY considers the shape of the earth.

CLR Types

• GEOGRAPHY and GEOMETRY are CLR data types.
• You do not need to have CLR enabled on the SQL Server instance.
• Microsoft has provided a long list of OGC methods.
• These are methods that are part of the independent Open Geospatial Consortium list of specifications

STDistance Function explained

• The STDistance function requires an argument of the SQLgeometrytype
• Convert the latitude and longitude to SQLgeometrytype.
• Declare a variable of the geography type.
• Set the variable to geography::STGeomFromText('point(lon lat)',4326).
• Notice that the point is a string.
• Notice there is no comma between lat and lon
• 4326 is an SRID and is used to tell the function what method to use to calculate distance on a not-so-round planet.

STDistance in action

Declare @CodeGEOG geography =

geography::STGeomFromText('Point(-95.3410 29.7070)',4326);

Select top(5) addr.AddressID as id ,

addr.addressline1,addr.city,

addr.SpatialLocation, -- Will show the raw data

addr.SpatialLocation.AsGml() as SpationalGML,

addr.SpatialLocation.STAsText() as SpatialText,

addr.SpatialLocation.STGeometryType() as GeoType,

addr.SpatialLocation.STNumPoints() as Points,

addr.SpatialLocation.STDistance(@CodeGEOG) as distance_in_meters,

addr.SpatialLocation.STDistance(@CodeGEOG)/1609.344 as distance_in_miles

from dbo.Address addr

Where

addr.SpatialLocation.STDistance(@CodeGEOG)/1609.344 < 50

order by distance_in_miles

Wire the SQL up to Virtual Earth

The wire will get it’s own blog entry

Since it is 2009 it is about time to get up speed with SQL 2008.  Here is the link to down load the fully functional express edition.

http://www.microsoft.com/express/sql/download/

If you are using SSMS 2008 to connectr to a 2005 database you may get the error "Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”.   SQL 2008 has features that 2005 doesn't have.  Some of those features are displayed as columns in the database browser. This will cause the error to occur.   This in turn will prevent you from being able to connect to your database. This is a known issue with Microsoft and occurs when either a database is in offline mode or when SQL Server Management Studio cannot correctly read one or more databases. Therefore, certain properties of a database cannot be retrieved. However there is a work around for this if you follow the instructions below:

1. Close the error message.
2. Press F7 to open the Object Explorer Details pane.
3. Right-click the column headers, and make sure that only the following columns are selected:
   *Name
   *Date Created
   *Policy Health
   *Owner
4. Right click the Databases node, and then click Refresh.

For more information the please view the Microsoft knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956179

Spatial data represents the shape and physical location of an object.  For example, the object can be a house, business, sub-division, or a county.  SSQL Server 2008 has two new data types GEOMETRY and GEOGRAPHY.  GEOMETRY works with flat objects. GEOGRAPHY considers the shape of the earth. 

GEOGRAPHY and GEOMETRY or CLR data types. Though to implement them you do not need to have CLR enabled on the SQL Server instance.  Microsoft has provided a long list of OGC methods.  These are methods that are part of the independent  Open Geospatial Consortium list of specifications.

Here is a PDF of my presentation SQLSaturday.pdf (806.55 kb)