Home / Archive: February 2009

| RSS

Programmatically Take Screenshot Using C#

To do this you will need to add references to System.Drawing and System.Windows.Forms. Make sure that you have following using statements:
using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Windows.Forms;

 
In your method add this code. It will take a screenshot of your primary screen and save it to a file.
Bitmap bitmap = new Bitmap(Screen.PrimaryScreen.Bounds.Width,
[...]

[ More ] February 26th, 2009 | 4 Comments | Posted in Code Snippets |

Mystery Of Scott And Tiger In Oracle

I found this very interesting.
When you install Oracle, a user by the name of Scott is always created for you. This users’ password is Tiger. The user is actually named after Bruce Scott who was one of the first employees at Oracle and Tiger was his cat’s name.
Original Source.

[ More ] February 25th, 2009 | No Comments | Posted in News |

SQL Server – Get Database Mail Configuration Settings

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

 

[ More ] February 23rd, 2009 | No Comments | Posted in Programming |

SQL Server 2008 – Get Space Used By a Table

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

[ More ] February 23rd, 2009 | No Comments | Posted in Programming |

Microsoft Museum: Microsoft 1978 Picture At Museum Of Hoaxes

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

[ More ] February 18th, 2009 | 2 Comments | Posted in Microsoft Museum |

Microsoft Museum: Windows 2000 & Windows NT 4 Source Code Leaks

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

[ More ] February 17th, 2009 | No Comments | Posted in Microsoft Museum |

Create Silverlight Game And Win $5000

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

[ More ] February 17th, 2009 | No Comments | Posted in News |

Get A Free Website Including Your Own Domain With Office Live

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

[ More ] February 11th, 2009 | 3 Comments | Posted in News |

T-SQL Return Empty String Instead Of Null

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

[ More ] February 11th, 2009 | No Comments | Posted in Code Snippets |

Get A List Of All OLEDB Providers In SQL Server

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.

[ More ] February 11th, 2009 | No Comments | Posted in Code Snippets |

Writing Windows Forms Client for Live Search

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

[ More ] February 4th, 2009 | 10 Comments | Posted in Programming |

Download Oslo Tools And SDK January 2009 CTP

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

[ More ] February 3rd, 2009 | No Comments | Posted in Programming |
  • Page 1 of 2
  • 1
  • 2
  • >