Summary of few articles from SQLHub.com

I am not blogging in this wordpress blog since long time but very active in SQLHub.com. Even I am not updating this blog now, I am still getting comment from readers in my old articles here so I thought to share one small summary of those articles which are not available in this blog but I wrote in SQLHub.com.

I had written few articles about Index in SQL Server and have received very good feedback from the user. It has covered up Basics about clustered and nonclustered Index, Included column Index, and filtered column index ,  rebuild and reorganize index and few information about statistics of Index. You can read those articles from here.

Sp_RefreshSQLModule to refresh metadata of your object.

There is new feature in SQL Server Denali which is “With Result Sets”, you can read about it from here.

Merge statement is really very helpful when you want to use Insert/Update/Delete combo based on some conditions. Read more.

CUBE and ROLLUP are very powerful tool when you want make total and grand total of your result sets based on some condition, read more.

To fix orphan user, there is one small TSQL script, this is useful especially when you move your database from one SQL Server to another. Read more.

DAC: DAC could become a real life savior for SQL Server DBA in some extreme critical situation when you are not able to connect to your SQL Server instance by any other way or you found you instance totally unresponsive, you can use DAC connection. Read more.

Sometime it happens that you are not able to upload file which is greater than 4MB to your SQL Server database from asp.net, you need to set value of httpRuntime. Read more.

Some interesting stuffs about HttpEndPoint in SQL Server.

Link server is really important when you wish to import/export data directly from your SQL Server to/from any database/format which supports OLEDB. Read more

Pivot is really very useful feature in SQL Server and I have written few different examples of the same, have a look

I have written some interesting basics about ISOLATION in SQL Server in part. Here is the list of the same.

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels.html

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels_15.html

http://www.sqlhub.com/2009/03/different-types-of-isolation-levels_5757.html

COMPUTE clause for subtotal. Read more.

I have written series of Encryption and Decryption articles in 7 parts. All part listed with complete practical example at here. If you want to go to each individual article, look at below given links.

Encryption – Decryption in SQL Server 2008 Part 1

Service Master Key (Encryption – Decryption in SQL Server 2008 Part 2)

Database Master Key (Encryption – Decryption in SQL Server 2008 Part 3)

Certificate (Encryption – Decryption in SQL Server 2008 Part 4)
Asymmetric Key (Encryption – Decryption in SQL Server 2008 Part 5)

Symmetric Key (Encryption – Decryption in SQL Server 2008 Part 6)

If you want to know FULL Text Search, must read following three articles.

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005.html

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005_16.html

http://www.sqlhub.com/2009/03/full-text-search-in-sql-server-2005_3854.html

Good example of BCP, Bulk copy, XP_CmdShell given here.

Grouping Sets could be brother of CUBE and ROLLUP command.  Read more

Audit is really one of the interesting, useful yet difficult to maintain topic in history of SQL Server, read list of articles on the same from here.

You can do Auditing with OUTPUT clause too. Read it

List of some articles on XML with SQL Server.

XML Path Root

Read Typed XML in SQL Server

Load relational XML data

Read XML node on same level

Return comma separated value with “For XML Path”

update UnTyped XML data column

Reference: Ritesh Shah


http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
 http://www.SQLHub.com

Ask me any SQL Server related question at my “ASK Profile

Article on Audit facility in SQL Server 2008 in Experts-Exchange

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server.

In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace which is not the most intuitive tools. However in the latest editions, we are now given quite a lot of power for auditing with some purpose built tools. The SQL 2008 Audit is meant to be replacing SQL Trace, it is faster, more granular and easier to interact with from SQL Server Management Studio, and with code. In this article, I am using a T-SQL code approach.

Since this is one of the big topics in SQL Server 2008 (and bound to become more popular), it is not possible to cover it completely here. However, I will try to give you one detailed but simple example as an introduction to SQL Audit.

Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com

Started contributing in ASP.NET also

My regular blog reader knows that I used to help community by my blog www.SQLHub.com and by Experts-Exchange.com. Due to high response from the community and few suggestions from my friends I started participating in www.Asp.Net forum also. Actually my account in Asp.net forum is few year old but I have started contributing since last three days only. You know that I am working with Microsoft technology and how is it possible that I don’t contribute anything in Microsoft’s own website? J



Since my prime area of working is SQL Server, I would love to write blog my website and give solution to the people in Experts-Exchange.com; I will share my knowledge of .NET framework and SQL Server both in Asp.Net for a change now onwards.
So from now, I will be contributing to community from three ways.
Happy Helping!!!!
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com