Entity Framework – Show generated SQL

How to view the SQL Generated by Entity Framework Entity Framework follows the following three steps. Translate C# code into SQL statements Execute SQL on a target database Return values back to C# objects. Now the question is how the generated SQL statements look like and how we can view the SQL executed on the…



Steve Jobs’ Amazing Commencement Speech

If you have Apple’s word-processing application, Pages, on your Mac, then you can find an Easter egg that honors Steve Jobs: the text of his 2005 commencement speech at Stanford University. OS X Daily found it, and once you know how to get to it, it’s extremely easy to find. Simply press “Shift + Command + G” in Finder…




Get .NET Framework Version of an assembly (dll/exe) using PowerShell

i just had to find the required framework version for a compiled .NET assembly (just to make sure, that the selected Application Pool in IIS was set to the righte Framework Version). ——– $fileBrowser = New-Object System.Windows.Forms.OpenFileDialog -Property @{ Filter = ‘Assemblies (*.dll & *.exe)|*.dll’ MultiSelect = $true} [void]$fileBrowser.ShowDialog() $files = $fileBrowser.FileNames   foreach($file in $files)…



Debugging Group Policy Processing

Group Policy Debug Log Settings The below article has got information about enabling different debug loggings which are required for troubleshooting various Windows issues. UserEnv Debug Logging Userenv logging is useful when troubleshooting group Policy application related issues or User profile related issues….




Truncate Logfile in SQL Server

Using the code Step 1. Copy/type the below given SQL. Step 2. Change @DBName to < Database Name>, @DBName_log to <Log File Name> Step 3. Execute the SQL. ALTER DATABASE @DBName SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(@DBName_log, 1) ALTER DATABASE @DBName SET RECOVERY FULL WITH NO_WAIT GO In SQL Server data is stored using…




How to configure Windows Time Synchronization (w32tm.exe) on a Windows Server 2008 R2 PDC

This article explains how to configure your Windows Server 2008 R2 Active Directory Primary Domain Controller to syncronise time with an external time source. Note: In an active directory, all member computers will sync time with the PDC, so you only need to setup an external time source on the PDC. Open an elevated command…




How do I find orphaned computer objects in Active Directory using PowerShell?

How can I find all computer accounts in my Active Directory domain that have been inactive for x days using PowerShell? This would give you all computer accounts that have no activity for the last 365 Days. Search-ADAccount -AccountInactive -ComputersOnly -TimeSpan 365.00:00:00 This would sort it for you by lastlogondate. Search-ADAccount -AccountInactive -ComputersOnly -TimeSpan 365.00:00:00…




Disabling Java Automatic Updates on a Terminal Server 32-bit and 64-bit Registry Redirection (Wow6432Node)

On a recently setup Windows Server 2008 R2 terminal server, Java was installed, and by default the JRE will enable automatic updates for all users. No daily users have administrative privileges, but all users are prompted to install updates. No users can actually install the available updates, nor can they disable the update check via…




Media added to DLNA shared library does not show up in Samsung Allshare Play

I’m streaming a lot of my media directly to my Samsung TV (Allshare). lately I added music to my Music Library in Microsoft Windows 8. The Library is shared using DLNA Protocol. For some reason, the newly added media did not show up am my Samsung TV. I started playing around with the configuration of…




Update a VMware ESX 4.1 Host

To scan for updates esxupdate -m https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/esx/vmw/vmw-ESXi-4.1.0-metadata.zip scan Stage updates esxupdate -m https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/esx/vmw/vmw-ESXi-4.1.0-metadata.zip stage Enter Maintenance Mode vim-cmd /hostsvc/maintenance_mode_enter Apply updates esxupdate -m https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/esx/vmw/vmw-ESXi-4.1.0-metadata.zip update Exit Maintenance Mode vim-cmd /hostsvc/maintenance_mode_exit Finally Reboot reboot