Setting Up A Delayed Sending Rule For Email In Microsoft Outlook

  Author: Ed Katibah, Microsoft SQLCAT Reviewer: Abdallah Fateen, Microsoft Introduction A few weeks ago, a couple of us were in the hallway discussing email and the topic of recalling sent email came up.  After some discussion, a colleague, Chris Kurt suggested another approach – implementing a delay in outgoing email, a.k.a. a delayed sending…

15

Updated Spatial Features in the SQL Azure Q4 2011 Service Release

The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL Server 2012. SQL Server 2012 spatial features are being released in SQL Azure in increments, beginning with Q2 2011 Service Release. With the introduction of the Q4 2011 Service Release for SQL Azure, a new TechNet Wiki post, Updated…

1

Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September 2011 Service Release

In Microsoft SQL Server 2012 (previously known as SQL Server Code-Name “Denali”), all constructions and relations are now done with 48 bits of precision, compared to 27 bits used in SQL Server 2008 and SQL Server 2008 R2. This can result in differences that range from how individual coordinates (vertices) in spatial objects appear (rounding)…

1

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3

We have just released a new white paper, New Spatial Features in SQL Server Code-Named “Denali”.  This white paper covers the spatial improvements added to both CTP1 and CTP3 and becomes the definitive spatial guide to this release of SQL Server. You can download the new server from this location: Microsoft SQL Server code-named ‘Denali’…

3

Spatial Support Coming to the SQL Server Entity Framework

Some of you may not have heard that spatial support is coming in the next version of the SQL Server Entity Framework. Here is the first paragraph from a post on this subject: “One of the highly-anticipated features coming in the next version of Entity Framework is Spatial support. The team has been hard at…

0

Spatial Aggregates in SQL Server Denali

  SQL Server Code-named “Denali” is currently available as a Community Technology Preview (CTP).  Denali introduces 4 new aggregates to the the suite of spatial operators in SQL Server: Union Aggregate Envelope Aggregate Collection Aggregate Convex Hull Aggregate All aggregates are implemented as static methods which work for either the Geography or the Geometry data…

6

Spatial Support for Persisted Computed Columns In Denali CTP1

A few weeks ago, in the whitepaper, New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1, new spatial support for persisted computed columns was presented.  This post will elaborate on this new feature, describing how it is different from prior support in SQL Server 2008. In SQL Server 2008 you could create…

0

Database Compatibility Levels: Getting Existing Spatial Databases Ready For Denali

With the availability of the new SQL Server code-named “Denali” CTP1 release, some of you will be moving existing SQL Server 2008 databases into the new server.  In order to enable the new spatial features in Denali, you will need to update the database compatibility level for existing SQL Server 2008 databases.  For Denali, the…

0

New Functions Added To The SQL Server Spatial Tools CodePlex Project

Two new functions have been added to the SQL Server Spatial Tools CodePlex Project: FilterArtifactsGeography FilterArtifactsGeometry These new functions, as the names imply, are designed to remove unwanted components from spatial objects.  For instance, consider the output from the Reduce() method on a Geography object which results in a GeometryCollection consisting of a MultiPolygon and…

1

FME Webinar: Practical Techniques for Loading Data into SQL Server

One of the most often asked questions about SQL Server Spatial is “How do I load data into the spatial types?”. Safe Software has long provided solutions for this dilemma with their excellent ETL tool, Feature Manipulation Engine (FME).  On December 14th, Safe will be presenting an FME Webinar entitled “Practical Techniques for Loading Data…

0