Find SQL fast in SQL Server Management Studio

• Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
• Quickly navigate to objects wherever they happen to be on a server
• Search across multiple object types and multiple databases
• Find all references to an object
• Search with booleans and wildcards

SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases more...

 

Implementing Active Directory Change Notifications in .NET

There are three ways of figuring out things that have changed in Active Directory (or ADAM)  more...
How to poll for changes to the Active Directory by using Visual C#  more...

 

Enabling Create System Image in Windows 7, 8 and 8.1

When trying to make image of disk in Windows, it says:
Windows backup: This feature has been disabled by your system administrator. Contact your administrator for access.

more...

Setup IIS 7 AppPool Identities as SQL Server Logons

C# application can access SQL Database and fetch the data when it runs in IIS Express but cannot connect to SQL Database when runs in IIS. To solve the problem, IIS APPPOOL\AppPoolName must be created and have control over the desired database. To do this:

• In SQL Server Management Studio, look for the Security folder (the security folder at the same level as the Databases, Server Objects, etc. folders...not the security folder within each individual database)
• Right click logins and select "New Login"
• In the Login name field, type IIS APPPOOL\AppPoolName - do not click search
• Fill whatever other values you like (i.e., authentication type, default database, etc.)
• Click OK

'AppPoolName' can be fine by:

• Select the desire website in IIS
• Click on Basic Bindings
• Application Pool Name will be the values of the 'Application Pool' 

Random Number Generator to Generate Different Numbers

C# Random method is initialized using the clock. That's why it generates same value every time it calls. Here is the solution to generates different numbers:


private static readonly Random random = new Random();
private static readonly object syncLock = new object();

public static int RandomNumber(int min, int max)
{
    // synchronize
    lock (syncLock)
    {
        return random.Next(min, max);
    }
}