Blog Detail

Ritesh's Blog for SQL-Server and .NET

http://ritesh-a-shah.blogspot.com/

Ritesh's blog is specially for SQL-Server and Microsoft .NET technology like C#, ASP.NET, AJAX.Net and Silver light

• Added on: Mar 2nd, 2009
• Country: India
• Language: English

• Author: Ritesh Shah
• Listed in: Programming Programming
• Tags: Microsoft asp.net .net c# ms sql server sql-server 2005

Recent Posts

• A beauty of Set Based theory in SQL Server

  Posted on Thursday November 26th, 2009 at 00:21 in t-sql, Microsoft, ms sql server 2008, ritesh shah, set based theory

  I always prefer Set Based theory versus step-by-step procedural programming. Today I am going to show you how efficiently it works. Suppose you have two variable containing one value each. You want to swap it so there are few different ways to do so ...

• Very common interview question about COUNT aggregate function.

  Posted on Tuesday November 24th, 2009 at 01:01 in t-sql, Microsoft, count, null, ms sql server 2008, ritesh shah, count and null

  I have observed that many interviewers asks question to SQL Server Developer about COUNT aggregate function. The question is something likeThere is one table which has three fields.1.)    ID which is integer primary key so it won’t a...

• Interesting observation about VIEW and ORDER BY clause in SQL Server 2008

  Posted on Monday November 23rd, 2009 at 03:36 in t-sql, view, Microsoft, order by, ritesh shah

  View is been always interesting topic for me and for many of the SQL professionals. Use of ORDER BY clause inside the view is really a question of debate since long. I am going to present my observation about view in this article which I have tested ...

• Auditing in SQL Server 2008 white paper.

  Posted on Saturday November 21st, 2009 at 01:25 in t-sql, Microsoft, audit trail, ritesh shah

  A key part of any data security strategy is the ability to track who has accessed, or attempted to access, your data. This provides the ability to detect unauthorized access attempts or, if necessary, to piece together the actions of malicious inside...

• Audit in SQL Server 2008

  Posted on Friday November 20th, 2009 at 02:39 in t-sql, Microsoft, ms sql server 2008, audit trail, ritesh shah

  Audit is really one of the interesting, useful yet difficult to maintain topic in history of SQL Server. I have already written few articles on how to maintain Audit trail in SQL Server. You can refer those articles from the below given links, once y...

• Security TIPS for Harden SQL Server 2008

  Posted on Thursday November 19th, 2009 at 00:59 in t-sql, Microsoft, ritesh shah, hardening sql server

  Hardening SQL Server is really one of the challenging jobs in the field of SQL Server. It is not at all possible to cover it in one article rather one dedicated book should be there. Even, I am trying to give some important tricks as a first steps.Au...

Comments & Reviews

This blog is currently rated a 5.00 out of a possible 5 based on 1 comment.

jayanit

iBow is a leading IT Services company, headquartered in Oslo, Norway with presence across the globe. iBow offer's technology led business solutions across two SBU�s i.e. Application Software Services and Technology Infrastructure Management Services (Technology IMS).
IT SOLUTIONS

Posted: August 17th, 2009 | Report This Comment

Post A Comment/Review

* Your IP is being logged.
* Your e-mail address is used only for verification purposes only and will not be sold, or shown publicly.
* No HTML tags allowed
* DO NOT use the Comments/Reviews to promote your own site.