Monday, April 26, 2010

SQL #39 Saturday at New York City

This (Saturday April 24,2010) was a great event with a large line up of very interesting speakers. The event was attended by a large number of interested folk, from geeks to ceos. The format was very good and the lunch too (It is getting better with more healthy food, not the junior pop-corn and coke).

The one day event had more than 25 speakers with parallel sessions. The emphasis it appeared was on BI. PowerPivot made a power play with an excellent presentation by Andrew Burst.

At lunch time there was a sponsors session repesented by vendors:

Ignite 8
Expressor and

There was also a min exhibition where I noticed BigBuy, SetFocus and others.

Roger Doherty's illuminating talk described the highlights of SQL Server 2008 R2.

How do I get rid of this coming into my blog?

Recently there has been a spate of attacks on my blog mostly of Chinese(any of origin, person, organization) .

There was a recent comment to one of my posts which reads in the original as follows:

新浪視訊 色妹妹視訊高雄援交 (I have only kept few of the characters from this long list).

This looks like a porno site’s banner when translated using BING. Of course I moderate the comments (heavens forbid if I did not). However, should find an easy way to stop these kinds of messages reaching the bloggers.

Wednesday, April 21, 2010

Microsoft SQL Server 2008 R2 has finally arrived

The final polished product has fianlly arrived. Now I can drop the November-CTP tagged on to the product and makes it more final-like.
Well, this is the product that will make SQL Azure more amenable to the on-site dbas. Let us see how well it works with SSIS and SSRS line of products. I am sure the deficiencies of the CTP has been completly remedied. In my last post I used the CTP to rename a SQL Azure database and did not succeed. Probably the final product would do the trick.

Well if you are a SQL Server junkie you may want to test drive the SQL Server 2008 R2 Hosted Trial here. You can help yourself to a number of other products as well (total of 7 labs).

Tuesday, April 20, 2010

Features galore for SQL Azure

More features makes SQL Azure more appealing. New features have been offered, they are here and now.

Some of the features have been tossed about in the forums, but altogether the new features makes migration of on-site to cloud more and more palatable. Want to learn about these new features and what they mean review the links on this post.

The new features include the following:

MARS (Multiple Active Result Sets)
      This was high on the wishlist but tested feature.
      Brush up your knowledge here and here.

Alter rename for renaming databases
It has not appeared  neither in the GUI on SQL Server 2008 R2 nor in the templates yet.

Deployment flexibility with support for Data-Tier applications.
      Recent addition to Data Access (August CTP). Get a quick refresh here.

Monday, April 12, 2010

VS 2010 is here and now

This is good news for early adopters of this recent upgrade which was a RC till recently. I have tried the Ultimate version which is feature rich and helps ramp up productivity. You may be able to download if available (after the release) here.

I tried a Windows 7 phone application and accessed cloud based database application and everything went as it should. To use some of the applications you really should upgrade your WPF skills. Some of the databased applications could not run without a workaround as the feature had not gotten into the RC version, but I assume it will have been improved in the production release.

Now that the product is in production, I am not sure how long I can play with the RC (free download). I am sure I will not be able to buy the full Ultimate with over $11000 a piece even if it gives me some freebie cloud time. Protection Status