jntu online bits for 2-1 1st mid all branches

                        2-1 CSE AND IT

Business Intelligence with SQL Server 2005: Transform Data into Decisions

Just came across a set of PerformancePoint webcasts on http :// thesource.ofallevil. com/events/series/sqlserverbi . mspx. Check out:

TechNet Webcast: Performance Management 101 with PerformancePoint Server 2007 (Level 200)
Thursday, January 18, 2007
1:00 P.M.–2:00 P.M. Pacific Time
Join us and learn how Office PerformancePoint Server 2007 enables businesses to deliver performance management capabilities broadly by providing an application that is easy to use and less costly to deploy than traditional solutions.

TechNet Webcast: Microsoft Business Intelligence: Introduction to PerformancePoint Server 2007 (Level 200)
Friday, January 19, 2007
8:00 A.M.–9:00 A.M. Pacific Time
Discover how Office PerformancePoint Server 2007 provides you with critical visibility into the factors that affect your business, allowing you to make decisions and take actions that drive better business outcomes.

SQL Server Proximity Search

George, a good friend of mine created a blog post showing how you can do a SQL Server Zipcode Latitude/Longitude proximity distance search without using the geography data type. I searched the internet to see if anyone had something similar with the geography data type available in 2008 and could not find anything that showed some useful stuff. Yes there is a lot available with geometry and polygons but nothing I was looking for. George challenged me and I did the 2008 version.

There is nothing really complicated. if you run this
DECLARE @g geography;
DECLARE @h geography;
SET @h = geography::STGeomFromText('POINT(-77.36750 38.98390)', 4326);
SET @g = geography::STGeomFromText('POINT(-77.36160 38.85570)', 4326);
SELECT @g.STDistance(@h)/1609.344;

You will see that the distance in miles between those two points is 8.8490611480890067

In the end the code runs between 15 and 60 millisecond to get all the zipcodes within 20 miles of zipcode 10028, pretty impressive if you ask me

All the code including sample data for all the zip codes in the US can be found here

The reason I did not post it here is because George created the 2000 version so it would be weird if the 2008 version was somewhere else, but no worries I will have a post here tomorrow about "what do you wish you knew when you were starting?" Michelle Ufford  tagged me so look forward to that