Welcome to Sign in | Join | Help

iulie 2011 - Posts

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'd use a SQLCLR aggregate. After all, they're just Read More...
Starting with SQL Server 11 the the SEND verb has a new syntax and accepts multiple dialogs handles to send on: SEND ON CONVERSATION [(]conversation_handle [,.. @conversation_handle_n][)] [ MESSAGE TYPE message_type_name ] [ ( message_body_BLOCKED EXPRESSION Read More...
Two of the security features that folks have asked me about, especially since around 2002, is row-level and label security. Row-level security was present in one of the early betas (beta 1, IIRC) of SQL Server 2005, but it was pulled almost right after Read More...
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 too. I worked with a product called SAS once, on statistics for response time. Got some Read More...
Prior to SQL Server 11 when you add a new non-NULLable column with default values to an existing table a size-of data operation occurs: every row in the table is updated to add the default value of the new column. For small tables this is insignificant, Read More...
After talking with folks about the SQLskills DBA Immersion training, one thing that always comes up is the fact that database developers feel left out. Well, you're left out no more! SQLskills is going to be doing a week-long SQL Server Developer Read More...
In my previous article How to use columnstore indexes in SQL Server we’ve seen how to create a columnstore index on a table and how certain queries can significantly reduce the IO needed and thus increase in performance by leveraging this new feature. Read More...
Column oriented storage is the data storage of choice for data warehouse and business analysis applications. Column oriented storage allows for a high data compression rate and as such it can increase processing speed primarily by reducing the IO needs. Read More...
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 do that, Help and Community off the start menu, Manage Help Settings. But downloading BOL gets Read More...
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 it. Brought it up and looked for a few new items (features) announced at SQLPASS last year and TechEd US 2011 this year Read More...
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 be "What's New in SQL Server Denali". There's a lot of new features (and more coming soon), so I'll Read More...
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 the game. It's located at SQL Azure Labs, listed under SQL Azure "Import/Export". The writeup on this page Read More...
So DAC 1.1 has been out for a while (since March 2, 2011) now. The big change is that the DAC "upgrade" process is now an in-place upgrade rather than a side-by-side upgrade. As far as I can see, you couldn't do a side-by-side upgrade in Read More...
About a week or so ago, I read a request for information about a SQL Server database management feature known as Data-Tier Applications, abbreviated as DAC (apparently someone realized that the DTA abbreviation was already "taken" in SQL Server Read More...