Large user-defined types and aggregates in SQL Server 2008
One last SQLCLR feature I'd forgotton about but was quite highly publicized. This is extension of SQLCLR UDT and UDAgg maximum size from 8000 bytes
One last SQLCLR feature I'd forgotton about but was quite highly publicized. This is extension of SQLCLR UDT and UDAgg maximum size from 8000 bytes
Another cool SQLCLR feature in SQL Server 2008 is the ability to define a table-valued function with an ORDER clause. If you have intimate knowledge that
One thing that I didn't find in the BOL What's New page is some of the new SQLCLR functionality in SQL Server 2008. The first
With any new product or CTP, I’ve always gotten fast results by starting with the readme.txt file that comes with the product/CTP. Although its now
SQL Server 2008 adds the concept of priority for conversations. It's setup using special DDL statements, priority cannot be specified on the CREATE DIALOG CONVERSATION
SQL Server 2008 adds support for the 'let' clause in FLWOR expressions. The for and let clauses have a similar purpose, to bind content (tuples)
The upcoming SQL Server 2008 provider for Powershell was a big hit and sparked quite a bit of discussion when I talked about and demonstrated it
I’m up early this morning for a repeat of my T-SQL in SQL Server 2008 talk. Things really went well for the last two days,
Today is day 1 of TechEd/ITForum in Barcelona. I have a bit less hectic of a workload at this one, a total of 4 sessions,
Actually yesterday, but today was the first time I'd had a chance to write about it. Having done quite a bit with what's now being
Whew! I had a full week at TechEd Barcelona, just getting around to finishing up writing about it. It was great to get out and
Today, I’m finishing up my (many) talks at TechEd/Developers’ Barcelona with a breakout on best practices for transactions and isolation and leading an interactive discussion
Tomorrow (Wednesday) I’m changing to multiple best practices session in a single day. In the morning, I’ll be speaking about T-SQL query plans and “why
Today is day of SQLCLR (that is, use of .NET CLR code in SQL Server) for me at TechEd/Developers in Barcelona. I’m doing two talks
I like free, standard, sample databases. One that I’ve been looking at for quite a while is the Mondial database currently available at Institute for
Ever since the hierarchyid data type was introduced in SQL Server 2008 CTP4, there’s been a fair amount of discussion about renaming some of the
There’s been some rumors going ’round about the immenent release of SQL Server 2008 CTP5. OK, maybe I’ve been asking around too. The main reason
This week I’m at TechEd/Developers Barcelona. I arrived Saturday and I’m always delighted, being a Portland Oregon resident, to see the sun, even in winter.
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.