SharePoint Saturday Houston 2011

SharePoint Saturday Houston 2011 event is going to happen on May 7.

"SharePoint Saturday is an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint!"

For more information please visit SharePoint Saturday Houston website.

Please register for SharePoint Saturday Houston Event.

NULL

Earlier, I posted blog on T-SQL ISNULL() function. I realized that it is not good idea to post something before sharing knowledge on NULL.

NULL is considered as unknown and result of any expression that include null is also unknown. It is good idea to test null to avoid unknown result. SQL provide IS operator to test null value.

WHERE Expression IS NULL

Linked Server

I was looking for a linked server in SQL management studio. I can see bunch of linked server but not sure which one I needed.

I found out that following query not only list the linked server name, but also server name, database name information.

Here is the query.

SELECT * from sys.servers
WHERE is_linked = 1

Happy SQLing!!

ISNULL

ISNULL ( check_expression , replacement_value )

Today, I am writing my thoughts on T-SQL specific function isnull(). Current database system allows null values. Null itself does not show any meaning but when end users need data reports/application require data then it becomes problem.

ISNULL function convert null values into meaningful data value. Isnull function checks expression and if it founds null then replace it with second argument (replacement value expression) otherwise return first argument.

We still have coalesce() and nullif() functions to control null values in more flexible way.

Debugging ASP.NET Page

You can debug asp.net application either on page level or application level.

• Enable debugging for a page by adding a Debug= "true" attribute to the <%@ Page %> directive.
• Enable debugging for entire application by adding <compilation debug = "true"> in configuration/system.web/ withing web.config file.

Page.IsPostBack

The Page class includes a property called the IsPostBack property, which you can use to detect weather the page has already been posted back to server.

[Blog Review] If broken it is, fix it you should

Tess Ferrandez is an ASP.NET Escalation Engineer at Microsoft. She has been writing blog on http://blogs.msdn.com/tess/ for five years. Her areas of interest are debugging and related tools.

I find her blog interesting and learned most of the advanced debugging skills.

Tess gave very funny name to her blog, If broken it is, fix it you should. She describe it in following words.

Using the powers of the debugger to solve the problems of the world - and a bag of chips