Adieu, OLE DB
The writing has been on the wall for some time, but a few days ago Microsoft made it official. OLE DB will no longer be
The writing has been on the wall for some time, but a few days ago Microsoft made it official. OLE DB will no longer be
I’ve always been interested in SQLCLR, and wondered about the potential for producing libraries of useful functions for a variety of specialist purposes. With the
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
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.