Welcome to Sign in | Join | Help

ianuarie 2011 - Posts

One of the interesting spatial features in SQL Server Denali is the inclusion of spatial aggregates, namely CollectionAggregate, ConvexHullAggregate, EnvelopeAggregate, and UnionAggregate. Here's an example of unioning two squares together to make Read More...
When I originally wrote the SQL Server Denali full-text search on properties cheap demo , I used property sets with properties (GUIDs) that I got from the SQL Server BOL example (although the example itself didn't work). One of the things I noticed Read More...
I was telling students this week about the story of the semicolon and SQL Server. And, when going over some Denali demos, it came up again. SQL Server does not mandate semicolons as end-of-statement indicators as some databases do (as well as the ANSI Read More...
I'll be speaking at the New York City SQL Server user group next Thursday (Jan 27) on "What's New in the SQL Server Denali Database Engine". I'll go through almost all of the new features with demos on each one, including contained Read More...
I'm getting my plane tickets and plans together for DevWeek 2011 in London, coming up in March. I'll be doing a preconference workshop on " Writing SQL Server database applications and stored procedures for best performance ". In addition, Read More...
The SEND Transact-SQL verb does not allow to send a NULL message body, attempting to do so will result in error: Msg 8433, Level 16, State 1, Line 11 The message body may not be NULL. A zero-length UNICODE or binary string is allowed. But there are ways Read More...
I've recently completed an update to the SQL Server 2005 Security Best Practices whitepaper. It's available on the security and compliance website under whitepapers or the direct link is here . Unsurprisingly, its called "SQL Server 2008 Read More...
I'll be making my first trip to sunny Stockholm, Sweden in March, to do a two-day seminar on 10-11 March, as part of Addskills' Expertseminarium series . I'll be demonstrating coding for performance from T-SQL stored procedures to client APIs Read More...
At SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and sessions on it alluded to many more of the upcoming Denali features than appear on the CTP1. Read More...
The nearest neighbor query is one of the most common queries against spatial data. How many people haven't gone to a mapping app, typed in their current location and asked for the 10 nearest [your favorite thing goes here]? The obvious way to phrase Read More...