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

Reference: http://support.microsoft.com/kb/318785 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: https://gallery.technet.microsoft.com/scriptcenter/Detect-NET-Framework-120ec923 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) : http://findandreplace.io/download other tool requiring also JAVE: FAR https://sourceforge.net/projects/findandreplace/ – Test SSL and TLS: https://www.qualys.com/sslchecker _Well-known online tools for network engineers: https://dnschecker.org https://www.whois.net/ https://mxtoolbox.com/ https://whatismyipaddress.com/ http://ping-test.org/ https://www.portcheckers.com/Continue 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: http://wp.me/p15Zft-8h SQL Server Video archive: https://technet.microsoft.com/en-us/dn912438 Database tasks: https://technet.microsoft.com/en-us/library/ms165730(v=sql.105).aspx T-SQL reference: https://technet.microsoft.com/en-us/library/ms189826(v=sql.90).aspx SQL performance and troubleshooting: http://sqlnexus.codeplex.com/ Microsoft companion (MOC): http://www.microsoft.com/en-us/learning/companion-moc.aspx Web sites: http://guimberteau.net http://sqlpro.developpez.com http://sqlmag.com 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:”10.10.10.10″ process call create “powershell -noprofile -command Enable-PsRemoting -Force” -Credential Get-Credential Option 2 – PsExec: PS C:\> PsExec.exe \\10.10.10.10 -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: http://blogs.technet.com/b/configmgrteam/archive/2013/04/05/how-to-create-and-deploy-a-client-cert-for-mac-independently-from-configmgr.aspx Transforming .cer to .pem or vice-versa: https://www.sslshopper.com/ssl-converter.html using openssl to convert a certificate format to another format: https://support.ssl.com/Knowledgebase/Article/View/19/0/der-vs-crt-vs-cer-vs-pem-certificates-and-how-to-convert-them Exporting a private key: https://technet.microsoft.com/en-us/library/cc754329.aspx    

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: http://technet.microsoft.com/en-us/library/cc753362(v=ws.10).aspx http://technet.microsoft.com/en-us/library/ff182338(v=ws.10).aspx   I selected for your this article  – how to move a SQL 2008 cluster to a new SAN: https://gallery.technet.microsoft.com/SAN-Migration-step-for-SQL-d66dea19   Notes from theContinue reading “Migrating SQL 2008 Cluster to a new SAN”