Select from SQL*server error log with context.
Blog Archives
Filtering data from SQL*Server Errorlogs
Tagged with: Context, Error Log, ErrorLog, ErrorLogPath, Powershell, Select-String, SMO, SQL Server
Posted in Fun-Stuff, PowerShell, SQL Server
Posted in Fun-Stuff, PowerShell, SQL Server
T-SQL Tuesday #39: Getting Installed Instances, querying logs
This week’s T-SQL Tuesday is being hosted by Wayne Sheffield, and the topic is to blog about anything PowerShell related to SQL Server.
Today I am going to write about a few things:
-Getting a list of installed instances on a particular box.
-Reading the SQL*Server error logs using SMO.
-Querying the Windows event logs for errors.
Tagged with: ErrorLog, EventLog, Get-Item, Get-ItemProperty, Powershell, Registry, SQLServer, T-SQL Tuesday
Posted in PowerShell, SQL Server
Posted in PowerShell, SQL Server
SqlChow 