SQL Azure “version 11” arrives on my server
I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release), but I'd forgotten
I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release), but I'd forgotten
Once upon a time (well, now, currently), there were two memory allocators in SQL Server, the single-page allocator and the multi-page allocator. The single-page allocator
I'm not usually one for repeating stuff you can find in BOL. Usually, a waste of your time and mine. But this feature, for SQL
In the previous post, I insinuated that allowing LAG/LEAD to be sensitive to value RANGEs might help with series of data with missing values. It
You've heard my rant before "measure what you think you are measuring". If not, follow the link. Here's an example using the LAG function, new
A (couple of days late) thanks to all the folks that attended my "What's New in Denali" demo fest at Portland SQL Server User Group
So, quickly on the heels of the first window clause and last_value() question, came a followup: OK smartie, why does last_value work fine here? I
I've been working with the new Denali T-SQL windowing functionality and ran into someone who asked about this "problem". It's almost sure to become an
I've been trying out the windowing extensions (the OVER clause extensions and friends) with different kinds of functions (aggregate functions, first_value, last_value() etc), and thought
I'm always leery when I hear people say "statistics show that…" followed by whatever their opinion is. Scientists do it. And your users probably do it
After downloading CTP3, I immediately (well, almost immediately) went to set the options to view Books Online from local storage. You'all do know how to
So I was awake late last night and, lo and behold, there was a web link for Denali CTP3 posted on Twitter. Downloaded and installed
Just to let you know… I'll be speaking at the Portland, OR, SQL Server User Group meeting this month on July 28. The topic will
The next version of Data-Tier Applications is version 2.0. You can get a CTP of it today; where the CTP is located really gives away
I'd been fretting over the lack of a true visualizer for the new circularstring and compoundcurve spatial types in SQL Server Denali. I'd installed SSMS
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
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
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
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
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
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
Now about that "other" feature that could be called fullglobe in Denali that I mentioned. I don't know which feature will retain the moniker or
Once upon a time, I wrote a blog entry about CircularString, CompoundCurve, and CurvePolygon (the new geometric types supported in Denali). And mentioned that they
So what's the area of the earth? Well…depends on who's measurement you want to use. There an interesting SQL Server Denali spatial feature known as
I've been trying out the new Denali "AUTO_GRID" spatial index (that is …USING GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID in the CREATE SPATIAL INDEX DDL) on some of
So here's a cheap demo of FTS property search in Denali. For the motivation for this feature, see the previous blog entry. I'm a minimalist
Years after its inception, I think I've figured out what WinFS was supposed to do. It sometime takes me a while. I got a new
TechEd Europe 2010 ended yesterday. I thought I'd write about it when I got home, but now I'm unsure if that will happen in a
Quick correction to my PowerShell Denali CTP1 post here. Max Trinidad did the obvious get-command call and found some new PowerShell cmdlets related to the new HADR feature. Knew
OK, last one for the evening, its getting late in Berlin. And BTW, we might have some Denali goodness here at TechEd. Search for "futures",
Only because I've been waiting for it since I first saw try-catch back in 2005 beta 2 or something. In dirt-simple code: begin try delete jobs end
Once upon a time, there was to be a SQL Server-based file system for Windows. This file system would not only let you search on
SQL Server Denali CTP1 was released today. I don’t want to be the fiftieth person to post the link to the download; reference Ed's blog
Just having a look at PowerShell support in SQL Server Denali CTP1. In Denali you must install PowerShell V2 or it will be installed as
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.