Search anything in your Database schema right from SSMS

Find dependency of any object, text fragment in stored procedure directly from SSMS.

Posted Under: Information, Object Search, SQL Server 2005, SQL Server 2008
This post was written by namwar on March 29, 2010 Comments (0)

How to Install SQL Server 2005 Client Tools?

How to Install SQL Server 2005 Client Tools? Follow these steps to install SQL Server Client Tools

Posted Under: Blogroll, How-To, Installation, SQL Server 2005
This post was written by namwar on August 31, 2009 Comments (1)

How to Query Active Directory (AD) from SQL Server

Here is the quickest way to query Active Directory directly from TSQL.

Posted Under: Blogroll, How-To, Object Search, Query, SQL Server 2005, SQL Server 2008, TSQL
This post was written by namwar on August 30, 2009 Comments (2)

What is not Data Mining? - A Myth Buster

Following is a list which describes different data processing techniques and why they can not be reffered as Data Mining?

Posted Under: Analysis Services, Business Intelligence, SQL Server 2005
This post was written by namwar on June 20, 2009 Comments (1)

SQL Server Client Tools Setup Fails due to MSXML 6

Here is the solution to fix the failed installation of SQL Server Client Tools because of MSXML 6 corrupt installation

Posted Under: How-To, Information, Installation, SQL Server 2005, Tips
This post was written by namwar on April 13, 2009 Comments (0)

How to create Custom Database Role and Manage its permissions

Step by step procedure to create custom database role and how to manage permissions

Posted Under: How-To, Query, SQL Server 2005, SQL Server 2008, TSQL, Tuning
This post was written by namwar on April 5, 2009 Comments (0)

How to use more than 4GB RAM on SQL Server?

This article describes the procedure to make sure your SQL Server is able to use more than 4GB of RAM, if installed

Posted Under: How-To, Information, SQL Server 2005, SQL Server 2008, Tuning
This post was written by namwar on January 15, 2009 Comments (1)

TSQL Function to convert decimal to Hex, Octal or any other base

This TSQL function provides you the ability to convert a given integer into any target base. I have just updated the function with more meaningful names and added some comments to clear the logic.

Posted Under: How-To, SQL Server 2005, SQL Server 2008, TSQL, Utility Functions
This post was written by namwar on January 12, 2009 Comments (0)

How to find relationship between tables

here is the script which lists the name of the parent table, child table, Referred table, foreing key table and name of the foreign key constraint.

Posted Under: How-To, Object Search, Query, SQL Server 2005, SQL Server 2008
This post was written by namwar on January 3, 2009 Comments (2)

Two quickest ways to find file information of a given database

Here are the two quickest ways to find file information about the given database

Posted Under: How-To, Query, SQL Server 2005, SQL Server 2008, System stored procedures, TSQL
This post was written by namwar on January 2, 2009 Comments (1)
« Older Entries