Monthly Archives: January 2012

Love my new job title

Database architect…  This is the job title I have wanted for years.

Posted in SQL Server | Tagged | Comments Off on Love my new job title

Visualizing Spatial Data

http://msdn.microsoft.com/en-us/magazine/ee335706.aspx Visualizing Spatial Data Bob Beauchemin In SQL Server 2008, Microsoft introduced spatial data support with two new built-in data types, geometry and geography. Although you could “see” the data in spatial columns in three formats—Well-Known Text, Well-Known Binary, and … Continue reading

Posted in SQL Server | Tagged | Comments Off on Visualizing Spatial Data

cubes are great

http://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/ Five Basic Steps for Implementing an Analysis Services Database 05 January 2010 by Robert Sheldon To learn an application, nothing beats getting it up and running. Getting started with Analysis Services can be frustrating unless you have a clear … Continue reading

Posted in SQL Server | Tagged | Comments Off on cubes are great

Much ADO About Text Files

http://msdn.microsoft.com/en-us/library/ms974559.aspx Much ADO About Text Files  Greg Stemp Microsoft Corporation March 5, 2004 Summary: Demonstrates how script writers can use Microsoft ActiveX Database Objects (ADO) techniques to retrieve data from logs and other text files. (14 printed pages) If we … Continue reading

Posted in SQL Server | Tagged | Comments Off on Much ADO About Text Files

Microsoft to enable Linux on its Windows Azure cloud in 2012 | ZDNet

Wow this is interesting… http://m.zdnet.com/blog/microsoft/microsoft-to-enable-linux-on-its-windows-azure-cloud-in-2012/11508

Posted in SQL Server | Tagged | Comments Off on Microsoft to enable Linux on its Windows Azure cloud in 2012 | ZDNet

outlook linked tables

I think that I’ve come to the realization.. that linking email to SQL Server or Jet is incredibly powerful. In SQL 2000, you can receive mail, iterate through it like a collection.. In SQL 2005, it’s really best to use … Continue reading

Posted in SQL Server | Tagged | Comments Off on outlook linked tables