How to determine which version of .net framework is installed?

Reference: Microsoft .net Framework is a software package that is used by many applications, it runs in a software environment as opposed to hardware environment. Free program called .NET Version Detector ( download here ). PowerShell: how to get version of .net framework on a remote computer: To query the local Registry usingContinue reading “How to determine which version of .net framework is installed?”

Free Tools for System and Network or DB Administrators

Free tools for Windows sysadmin   – Find string if files on Windows: using findstr /s /i findstr /s /i /C:”provider=sqloledb” d:\dir\*.* Find and replace string in file (Find and Replace == fnr) : other tool requiring also JAVE: FAR – Test SSL and TLS: _Well-known online tools for network engineers: reading “Free Tools for System and Network or DB Administrators”

How to configure Windows Event forwarding (WEF) ?

Introduction: In summary: Windows Event Forwarding allows for event logs to be sent, either via a push or pull mechanism, to one or more centralized Windows Event Collector (WEC) servers. WEF is agent-free, and relies on native components integrated into the operating system. WEF is supported for both workstation and server builds of Windows. WEFContinue reading “How to configure Windows Event forwarding (WEF) ?”

Recommendations concerning NTFS cluster size

Microsoft’s file systems organize storage devices based on cluster size. Also known as the allocation unit size, cluster size represents the smallest amount of disk space that can be allocated to hold a file. Because ReFS and NTFS don’t reference files at a byte granularity, the cluster size is the smallest unit of size thatContinue reading “Recommendations concerning NTFS cluster size”

SQL Server and Databases resources

Resources: SQL Server performance: SQL Server Video archive: Database tasks: T-SQL reference: SQL performance and troubleshooting: Microsoft companion (MOC): Web sites: Tips and tricks: PowerShell: import-module SQLPS Placement of tempdb in a dedicated disk (Raid 1) ,  same for log files  (RAID 1 or 10) andContinue reading “SQL Server and Databases resources”

What if PSRemoting and Unrestricted Execution are disabled?

Remotely enable PSRemoting and Unrestricted PowerShell Execution using PsExec and PSSession, then run PSRecon Option 1 — WMI: PS C:\> wmic /node:”″ process call create “powershell -noprofile -command Enable-PsRemoting -Force” -Credential Get-Credential Option 2 – PsExec: PS C:\> PsExec.exe \\ -u [admin account name] -p [admin account password] -h -d powershell.exe “Enable-PSRemoting -Force” Next… PSContinue reading “What if PSRemoting and Unrestricted Execution are disabled?”

Converting .cer to .pem etc…

How to create and deploy a client certificate for MAC: Transforming .cer to .pem or vice-versa: using openssl to convert a certificate format to another format: Exporting a private key:    

Migrating SQL 2008 Cluster to a new SAN

Introduction: How to migrate a SQL cluster to a new SAN ? Environment: Server 2008 r2 (failover cluster – aka MSCS) and SQL 2008 sp3 Reference about Failover clustering:   I selected for your this article  – how to move a SQL 2008 cluster to a new SAN:   Notes from theContinue reading “Migrating SQL 2008 Cluster to a new SAN”