I found this with one of my Script Component. See the image;



If I click on it, the entire window goes off. Im trying to find a solution for this because this has blocked editing the type of the output. If anyone has seen this before and has found a solution, please let me know.

The 7th SQL Server User Group meeting was held at Microsoft Sri Lanka, on last Wednesday. Gogula started the first session, delivered valuable info about new policy management in SQL Server 2008. Next was our special segment, demonstrating one of red-gate products. Dinesh Asanka did the session, exploring the value of SQLCompare. I did the last one, I talked about Data Mining with SQL Server 2005. It was an introductory session for Data Mining, talked about data mining algorithms and algorithms introduced by Microsoft for SQL Server.

We gave out few great prizes, including SQLCompare licensed copy that is worth more than US$ 500, 1GB USB pen drives, mugs and t-shirts. Prizes were sponsored by red-gate and Microsoft Sri Lanka. 

Presentations related to these sessions will be published at www.sqlserveruniverse.com by end of week.

One of my friends had sent me this link, nice cartoon about SQL injection :)

http://xkcd.com/327/

The second note of Index Related DMVs and DMFs series has been published at www.sql-server-performance.com. This article shows the usage of sys.dm_db_index_usage_stats dynamic management view. Read the article and see.

We have added two new articles at www.sqlserveruniverse.com, one is written by Gogula and other from me. Here are the links;

Populating Dimension Tables with the SCD Task by Gogula G. Aryalingam
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler. As simple as a few clicks and minutes. This article talks about how a slowly changing dimension table can be populated using the Slowly Changing Dimension transformation task, which comes with Integration Services.

Reporting Services Data Regions: Table Data Region by Dinesh Priyankara
Organizing data with a combination of different data visualizations is a rather complicated yet important task in report authoring. SQL Server Reporting Services 2005 includes more than three data regions that allow us to organize data easily. This article talks about one of the data regions; Table Data Region.

Read them and see how worth they are; and dont forget to rate and comment.

The sys.dm_exec_requests is the replacement (or new implementation) of sys.sysprocesses system table. These two allow us to see the queries currently run under the instance of SQL Server. I noticed that the these two objects give different status for same execution; sys.sysprocesses give "runnable" while sys.dm_exec_requests give "running". You can simply test this one by running a batch and monitor via these two objects. I googled and tried to find a explanation for this but nothing found.

Any comment on this?

www.ssmstoolspack.com offers set of add-ins for SSMS that gives some great features. Since this is still in beta, not all functions are properly worked. One thing I really like is the feature that allows us to add regions in the code just like Visual Studio.

Since the region is added as a comment, saved scripts can be open with any SSMS and can execute without any problem. If the tool pack is not installed, it will be just a commented line without collapse/expand facility.

Download the toolspack and see. Since it is still in beta, better not to install in production environment.