$path = “C:\IISLogs\” $infile = “alllogs.txt” $outfile = “parsed.txt” $batch = 1000 [regex]$match_regex = ‘StringToFindInLogs’ [regex]$replace_regex = ‘BINGO’ $header_line = (Select-String -Path […]
Latest Articles
Read the latest release articles and learn without limits.
Security Links
Helpful Microsoft Security Links Top Trends in cyber security 10 Immutable laws of security NIST Controls 800-53
Code review guidelines
General Design / Execution With a recent pull, does your code build and compile? Does your code meet the minimum requirements for […]
ITL Build a team before you build the technology
When it comes to high performing teams, the team has to come first. The Team is the foundation to the success that […]
ITL Change Management
Want to control chaos in any IT environment? Want to stop asking why are things breaking? Put in Change Management. It’s staggering […]
SQL Conversion Between Datetime and Unix Timestamp
Purpose: To convert a datetime value in T-SQL to Unix Timestamp and vice versa. Note: Unix datetime is the number of seconds since […]
SQL Users with matching passwords
use MASTER go SELECT [name],[type_desc],create_date,modify_date,password_hash FROM sys.sql_logins WHERE PWDCOMPARE(lower([name]),password_hash)=1 –Note: Have experienced where case matters or PWDCOMPARE(upper([name]),password_hash)=1 or PWDCompare([name],password_hash)=1 order by [Name]
SQL Login Trigger
Purpose: Enables auditing of logins on a server. Steps: Download the attached script Run the script Create Login Trigger
SQL DBTools Module
Purpose: briefly describes the incredibly useful DBATools module and how to load it. Background The DBATools PowerShell module is a suite of functions […]
SQL Script DB Objects
Purpose: Generates create object scripts from a specified database Steps: Download the attached script Update the $SourceServer, $db, $path, $IncludeTypes, $ExcludeSchemas, and $IncludeSchemas […]