|
|
-
|
|
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to a HTML file.
It is only one extra step to send an email attachment.
This example iterates through a list of servers and returns Error messages from the System Event Log g......
|
|
-
|
|
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the SmtpClient Class , which is part of the .Net Framework.
You can call a Function – which makes your scripting ......
|
|
-
|
|
This powershell script assists in applying a similar change on every SQL Server
Instance. Or a subset.
For example, adding a new generic logon account, or collecting regular information.
I’ve written plenty of powershell scripts – that are customised for a partic......
|
|
-
|
|
SQL Server Version with Powershell and documenting SQL Server versions, is a necessary
timesaving methods. For instance, I'm upgrading loads of sql servers at the moment
and the following script, gives me a quick way of getting a summary of versions.
Place all the relevant serve......
|
|
-
|
|
SQL Server Automation is one of the best ways for a DBA to achieve more in less time. If a task is repeatable – then why run it manually?
A word of warning! There are automated jobs out in the SQL Server world that are causing more damage then help. I have seen plenty of Daily Shrink Databas......
|
|
-
|
|
Powershell and SQL Server is a great mix for Disaster Recovery planning. There are many aspects to database server disaster recovery planning – including: backup storage and location,
rebuild documentation, installation media, rebuild scripts, DNS and cnames, escalation process and securit......
|
|
-
|
|
What if you had to create a script stack that installs SQL Server from an image library? And customisations – such as adding the SQL Server Start up account to the Lock Pages in Memory Local Policies?
If this needs to be rolled out quickly across hundreds of servers, or just one, then there ......
|
|
-
|
|
When you attempt to execute a Powershell script you may see something like the following error message:
File C:\general.ps1 cannot be loaded because the execution of scripts is di
sabled on this system. Please see "get-help about_signing" for more details.
At line:1 char:14
+ ./general.ps1 All S......
|
|
-
|
|
Using: platform Powershell 2 CTP & Excel 2003
I was troubleshooting a Powershell problem –- on a script that creates a Excel spreadsheet. All worksheets up to 4 were OK- but soon as I past 5 the following error was displayed.
Exception getting "Item": "Invalid index. (Exception from HRES......
|
|
-
|
|
This script using Powershell, takes a list of SQL Servers , iterates through
the list and returns the results from the procedure: master.dbo.xp_fixeddrives.
Run this script as a standalone script or as part of a more comprehensive health monitoring snapshot
Depending on your security architec......
|
|