Rest Azured

Working on Azure November CTP version is quite exciting. Azure provides various way to store and presist data if needed. One way is using Azure Storage (Blobs, Tables and Queues). The other way is using SQL Azure. Which is a relational database.

To lay your hands on SQL Azure you would need an invitation code which would be be available after you register in http://sql.azure.com. The invitation code was provided to me after a week since i registered. Once received you would need to enter the invitation code on http://sql.azure.com to create database and tables. The limitation of SQL Azure as of now is that the database can of maximum 10 GB size. Note the service is free till Jan 2010, hence forth it will be charged based on the consumption. For SQL Azure only support SQL Authentication.

Enter a long URL to make tiny:

Excel Addin to extract MDX Query

One the question raised by my end users is, how they can view the MDX query out the Pivot table in excel they created connecting to an OLAP database. Excel has the excellent facilty to connect to a OLAP database and generate Pivot table using multi-dimensional cube. The pivot table can be defined by dragging and dropping the measures and dimension values with ease.

Found this super cool addin which eases out this pain of exacting the MDX query out of the Pivot table.

http://www.codeplex.com/OlapPivotTableExtend

The addin is easy to install and use.

Recompiling Database objects programatically

To recompile stored procedure

sp_recompile [@object=] objectname


To compile view use

sp_refreshview @viewname

Kerberos Delegation Site

Here is a good blog site where you can start with trouble shooting delegation issues

http://blogs.technet.com/askds/archive/tags/Kerberos/default.aspx

Querying Database object definition

How to query for T-SQL definition for objects in SQL Server 2008

You can query for object definition using sys.sql_modules catalog view in SQL 2008

Example :

SELECT OBJECT_NAME(object_id), definition FROM SYS.SQL_Modules where Definition like ''


Example :
DECLARE @SearchString NVARCHAR(MAX)
SET @SearchString = 'xyz'

SELECT @SearchString, [name] , OBJECT_DEFINITION(OBJECT_ID([name]))
FROM sys.all_objects
WHERE OBJECT_DEFINITION(object_id([name])) LIKE '%' + @SearchString + '%'