This post shows you how to find Data Providers installed on a machine. Data providers in .NET Framework provide the plumbing necessary to connect to databases. There are different data providers available which can connect to SQL Server, Oracle or other databases through OleDb. You can find the data providers installed on your machine by [...]

This snippet will show you how to get the currently logged in user on windows. System.Security.Principal.WindowsIdentity identity = System.Security.Principal.WindowsIdentity.GetCurrent(); Console.WriteLine(identity.Name);

Windows Registry Size can be retrieved using WMI objects. This code snippet shows you how to get current size and maximum size for Windows registry. ManagementObjectSearcher mgmtObjects = new ManagementObjectSearcher("Select * from Win32_Registry"); foreach (var item in mgmtObjects.Get()) { Console.WriteLine(string.Format("Current Size: {0}MB", item["CurrentSize"])); Console.WriteLine(string.Format("Maximum Size: {0}MB", item["MaximumSize"])); }   The output.

In .Net Framework reversing array elements can be done by using Reverse method on Array type. This code snippet shows you how this method can be used to reverse an array. // Declare an array with 10 elements int[] numbers = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; [...]

To convert a Hexadecimal to a number we can use an overload of Convert.ToInt32 method. Using the overload I can convert for example hex string “BB” to a number. int number = Convert.ToInt32("BB", 16); And the number variable gets assigned value of 187.

To get free disk space for all physical drives on a machine we can use xp_fixeddrives extended stored procedure. An interesting this about this procedure is that it is not documented in books online. EXEC xp_fixeddrives Here is output on my machine.

You’ve got to love sys views in SQL Server. While learning about performance tuning on SQL Server 2008 I wanted to get a list of all Indexes on my database and the answer was as simple as it can be. Here i a statement which can be used to get a list of all indexes [...]

This is where reflection comes in handy. The following code snippet shows you how to get the name of executing assembly. string assemblyName; assemblyName = System.Reflection.Assembly.GetExecutingAssembly().FullName; Console.WriteLine(assemblyName);   Output for the above code returns the fully qualified name as shown below   To just get the Assembly name we can use this snippet. string assemblyName; [...]

This snippet shows you how to get information about all CD / DVD drives on your machine using WMI and C#. To run the code you need to add reference to System.Management. ManagementObjectSearcher mgmtObjects = new ManagementObjectSearcher("Select * from Win32_CDROMDrive"); foreach (var item in mgmtObjects.Get()) { Console.WriteLine("Drive Letter – \t" + item["Drive"]); Console.WriteLine("Name – \t" [...]

This query returns the last row from Sales.Customer table in Adventure Works database. I am using LINQPad to write and execute my query. (from c in Customers select c) .OrderByDescending(x=> x.CustomerID).First()   Here is the result as displayed in LINQPad  

SQL Server by default follows Windows password policy requirements for SQL Server Login accounts. This forces you to follow the same policy for SQL Server logins as you would for windows logins and this is a good thing. But sometimes you want to bypass that validation maybe to get a test login in place. You [...]

If you are creating a SQL Server login using a script then it is advisable to check if the login you are creating already exists. If you do not do this then SQL Server will throw an error. For example if I execute this statement when a login with name test_user already exists, I will [...]