Powershell logparse regexp to csv

Input line: Thu 2017-03-30 00:00:07: user@domain.com (John Doe) checked mail from 127.0.0.1 using IMAP, 0 msgs collected, 21 remaining Powershell script: $rxp = “([a-z0-9!#\$%&’*+/=?^_`{|}~-]+(?:\.[a-z0-9!#\$%&’*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)|(\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b)|(POP|IMAP)|(^[A-Z][a-z]+\s\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2})” gc “.\*.log” | select-string -pattern $rxp -allmatches | foreach { if ($_.Matches.count -ne 4) { return Read More …

SQL Server 2016 SP1 Edition Limit Changes

Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per Read More …