October 2008 - Posts

• SQL Server 2008 Spatial Data - Getting Started

  There are all kinds of cool things you can do with SQL Server 2008 spatial data. A lot of people know that, but not that many have gotten started. Don't put it off, you can get started today using SQL Server 2008 R2 Express. It's simple to get started. Read More... Posted Saturday, October 18, 2008 1:36 AM by John Paul Cook | 4 Comments

• Local Temporary Table Persistence

  Everybody knows local temporary tables have scope only within a connection. Drop the connection and it goes away. The connection is at the server level, not at the database level. People commonly say things like "I'm connected to the database" when they Read More... Posted Thursday, October 9, 2008 12:32 PM by John Paul Cook | 2 Comments

• Running SQL Server 2008 in a Hyper-V Environment

  Download this new Microsoft whitepaper from http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx . SQL Server 2008 does perform very well in a Hyper-V environment when properly configured, which among Read More... Posted Monday, October 6, 2008 8:50 AM by John Paul Cook | 0 Comments