N a g a s a i

Keyboard Shortcuts (Microsoft Windows) 1. CTRL+C (Copy) 2. CTRL+X (Cut) 3. CTRL+V (Paste) 4. CTRL+Z (Undo) 5. DELETE (Delete) ...

In SQL Server, you can review the transaction order and lock acquisition by analysing the queries and transactions that are being executed a...

Here is the function to convert string to title case, which can handle spaces and underscores. Below function will remove underscores from t...

In SQL Server, you can implement retry logic for transactions using T-SQL and error handling. Here's an example of how you can create a ...

To find where a specific view is used in a SQL Server database, you can query the system catalog views. Here's a query to achieve this: ...

We can use the SecurityElement.Escape method to replace the invalid XML characters in a string with their valid XML equivalent. The followi...

The "Microsoft.ACE.OLEDB.12.0" provider is a database connection manager that allows access to various databases, including Micros...

Are you tired of juggling between Incognito tabs or re-entering credentials and MFA codes every time you manage different client's Offic...

To implement impersonation in SQL Server, you can follow these steps: 1. Create a Login : First, create a SQL Server login for the use...

Recently we need to look for a procedure where we are using in SQL Jobs. There is no easy way to find unless you script all jobs and find in...

There are few types where you can get comma separated values form SQL SERVER using SQL 1. XML PATH method: SELECT STUFF(( SELEC...

To move an Offline Outlook Data File (OST) data, you can follow these steps: Close Outlook and make sure it is not running in the ...

Visual Studio 2019 & 2022 Format Document , While you're holding down Ctrl button, first press K then D Format Selection...

We had issues deleting bin and obj folders when we check in code or share code with in teams. Here is simple batch file that we can use to...

Here is how we can bulk close JIRAs Step 1: Search all the issues/stories you wan to close (Using JQL or predefined filter of your own),...

Visual Studio 2019 has a new feature with visibility into how an external library or dependency resource is handling the data you are giving...

Ctrl+Alt+Down Arrow. This key command can magically rotate your monitor screens to 180 degrees. It would be very interesting to see someone ...

Recently I had a situation with Visual Studio 2010 where menu items where duplicated like 3-4 times. Looks like some configuration file was ...

Here is how we can IP address, you need to use below namespace library using System.Net.Sockets; IPHostEntry ipHostInfo1 = Dns.GetHostEnt...

Windows 10 includes a feature called "Hosted Network" that allows you to turn your computer into a wireless hotspot. Whether you...