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 [...]

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 [...]

I have a confession to make. When I saw var keyword for the first time I did not like it at all. My first opinion was that var was so variant like. Call me a control freak but I like to clearly see what I am declaring. And var was something I thought made the [...]

Earlier I wrote a post showing how to write a LINQ query which gets transformed into a T-SQL query with a "Where In" clause. I had a comment on the post by Steve saying that the approach only works with strings. In this post I will show you a similar query which works with Integers.
Let’s [...]

I had a look at LINQPad few months ago when I wrote about how you can use this tool to view generated LINQ To SQL Queries. There is not doubt that LINQPad comes in as a very handy tool when writing LINQ queries. But writing queries in LINQPad has not been that easy. Until Now!
LINQPad [...]

A question was posted on c-sharpcorner forums asking how you would remove duplicate lines from a text file. It got me thinking about how this problem could be addressed using LINQ. Before I get into the solution, here is the problem statement.
The problem
I am trying to remove duplicate lines from a text file. To [...]

CCC stands for Cloud Computing Consultant. There, I have said it. This is my contribution to acronyms-land. I have also cleverly designed it to minimize RSI which I am sure will be appreciated. You only have to use one key to type the acronym. If you ever come across the term Cloud Computing Consultant [...]

Sometime ago I wrote a post showing how to do dynamic sort with LINQ. That approach worked well with LINQ To Objects. Today I spotted a question on the forums where Levi asked a question about doing dynamic sorts with LINQ To SQL. My earlier approach will work once all the data is retrieved on [...]

For those interested in pursuing certification(s) on .NET Framework 3.5, Microsoft has released a set of exams for various .Net 3.5 technologies. I often get asked about these exams and how to study for them. In this post I will try to answer the first part. This post lists all currently available .Net 3.5 exams [...]

As a programmer I love my enums. I find code written using enums to be more readable than without them. However, there has been and there still is a disconnect between lookup tables in a database and enums in code. One has to restore to some creative trickery to get them working in harmony. Recently [...]