Database Mail configuration settings can be retrieved using sysmail_help_configure_sp stored procedure. Like other database mail object, this stored procedure also resides in msdb database. Running the stored procedure on my machine gives the following results.

sysmail_help_configure_sp

You can easily get information on how much space a table is using by executing sp_spaceused stored procedure. Executing the following query on AdventureWorks database shows me how much space Person.Contact table is using. Information presented is detailed which includes the number of rows, reserved space, index size, space used by data and any unused [...]

This famous picture of the main crew at Microsoft Corporation in 1978 is perhaps one of the most famous photos of Microsoft employees of that time. The picture is mostly seen with the slogan “Would you have invested?” This photo also made it to Museum Of Hoaxes website which lists facts about people in [...]

Today I am starting a series of posts in which I will post some interesting tit-bits about Microsoft. Mostly past stuff. I will prefix these posts with “Microsoft Museum” and tag them the same for easy search ability. The idea is to have light hearted and interesting posts about Microsoft. The ones that you read [...]

Participants of this contest will create a game in Silverlight and the winner will get $5000 as the first prize. The contest is open to residents of US and you must be 16 years or older to enter. You can find the official rules here.  You  are allowed to submit 3 entries which will be [...]

Microsoft is offering free website hosting and domain of your choice when you sign up for Office Live Small Business. Included in the package are hosting, your own domain if it is available, and online applications like Contact Manager, Document Manager, Project Manager and Workspaces. And this is all for free for first year. [...]

There are times when we want to return empty strings for column(s) which have NULL values. T-SQL makes this easy with ISNULL function. Two parameters for this function are:

The column in question
Replacement value

 
Here is an example query for Customers table in Northwind database. This query will select Region column [...]

SQL Server provides with a stored procedure which can be used to get a list of all OLEDB providers on a machine.
Stored procedure:
xp_enum_oledb_providers
Executing this stored procedure which is in master database with the following statement
EXEC master..xp_enum_oledb_providers

 
gives a list of all available OLEDB providers on my machine.

In this article we will look at how to write a Windows Forms Client to access Microsoft Live Search API. Via this API you can use the power of a giant search engine within your application. While developing our application we will see that the overall design of the API is simple and easy [...]

Microsoft has released January 2009 CTP of Oslo SDK and Tools.
You can download the CTP here.
The SDK includes Intellipad tool and "M" code samples to get you started. This release also support Visual Studio 2008. You can find more details about January 2009 CTP at SellsBrothers.com.
Here are few links to get you started [...]

Update On Windows 7 Beta Download Dates. Thanks Jeff
“Final days: We’re just about at the limit for Beta downloads, so act now if you want to try Windows 7.” It is my understanding that it is possible that the download link is capped before the 10th, depending on what [...]

This code will retrieve a list of currently running process on a machine and write their names to console.

// Get A List of process using
// System.Diagnostics.Process class
List<Process> processes = Process.GetProcesses().ToList();

// Write them out to Console
processes.ForEach(x => Console.WriteLine(x.ProcessName));