Burgess_Liu的专栏

Using the command Set-location, the error message maybe displayed. You can use double quotes to solve it.

SQL Server client aliases make user connections easier, faster, and more convenient. Each alias saves all the information you need to connect to a SQL Server, such as the server name and the client pr

You can use WMI to monitor server events.This provider manages a WMI namespace for each instance of SQL Server 2008. The name of the namespace is in the formatroot\Microsoft\SqlServer\ServerEvents\i

By default, FILESTREAM is disabled. Before starting to use it on a SQL Server instance, FILESTREAM needs to be enabled on the instance. The FILESTREAMSettings class provides an EnableFILESTREAM method

The WMI Query Language (WQL) is designed to perform queries against the CIM repository to retrieve WMI information. WQL is a subset of ANSI SQL with minor semantic changes to support WMI. Therefore,it

Unlike Windows PowerShell 1.0, for which you need to use .NET classes, such as the System.Management.ManagementEventWatcher class to subscribe and monitor events, Windows PowerShell 2.0 CTP3 provides

To view the list of properties associated with each network protocol for the default instance on the local computer:Get-WmiObject -namespace root\Microsoft\SqlServer\ComputerManagement10 -class Serv

Suppose the file system is corrupted,in which case you need to restore every database, including the master database. To restore the master database, you need to start the SQL Server in single-user mo

今天使用PowerShell时，遇到下面的报错信息：无法将“Invoke-SqlCmd”项识别为 cmdlet、函数、脚本文件或可运行程序的名称。请检查名称的拼写，如果包括路径，请确保路径正确，然后重试。所在位置 行:3 字符: 38+ $list | ForEach-Object {Invoke-SqlCmd     + CategoryInfo          : Objec

借助PowerShell，我们可以轻松地进行批量创建数据库，下面将详细介绍一下：比如，我们想要一次性创建3个数据库，其名称分别是DB1，DB2，DB3，我们可以建一个文本文件，如下图，文件名称是DBs，内容是要创建的数据库名称列表：接下来，我们可以使用如下的cmdlet来实现我们的目标：$list=get-content D:\DBs.txt echo $list $lis

Automating Daily Checks with PowershellBy Warren Campbell, 2011/12/19 At my company, I am required to produce evidence that I have checked every database backup on every server to ensure that

PowerShell是一个面向对象、命令行、

这里会测试一些脚本，用于SQL Server调校，如索引维护、管理

PowerShell与WMI框架完全集成，WMI框架

The ClientNetworkProtocol class represents the objects for client network protocols. To see the list of protocols of ClientNetworkProtocol class:Get-WmiObject -namespace root\Microsoft\SqlServer\Com

The WMI Provider for Configuration Management provides access to WMI objects in the root\Microsoft\SqlServer\ComputerManagement namespace for SQL Server 2005,and the root\Microsoft\SqlServer\ComputerM

Querying this WMI class returns environment variables found under the registry key HKLM\System\CurrentControlSet\Control\Sessionmanager\Environment. To access all the variables and their values by

When you executing PowerShell script, if PowerShell returns the below warning message:File xxx.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see "get-help

Excute the following command to find all the log types available on the local or a remote computer:Get-EventLog –listGet-EventLog -computerName RemoteServerName –list Query all the entries in

How to see all the application errors related to SQL Server and export them to a .csv file?  Just use below command: Get-EventLog -LogName "Application" -computername RemoteServerName | Where-Obje

¤The WMI model has three layers:The lowest layer in the WMI model is managed resource. Windows resources that can be managed using WMI include event logs, services, processes, environment variables,

All the available cmdlets related to processes can be found by executing the following cmdlet:Get-Command *process* -CommandType "cmdlet" Get-ProcessTo get a list of processes running on the l

To find all the cmdlets that are related to Windows services, execute the following command:Get-Command -CommandType cmdlet *service* Get-ServiceTo find all the running services that start wit

In order for WMI to work, the Windows Management Instrumentation service must be running.The service cannot be disabled and it must run under the local system account. If this account is changed, WMI

The most commonly used cmdlets related to event logging are as follows:Get-EventLogClear-EventLogShow-EventLogLimit-EventLogWrite-EventLogNew-EventLogRemove-EventLog clear the events

To get a list of log files available on your local computer:Get-WmiObject -class Win32_NTEventlogFile | Format-Table –wrap To access the log files on a remote computer:Get-WmiObject -computerN

To get a list of services on the local or remote computer:Get-WmiObject -class Win32_ServiceGet-WmiObject –computerName RemoteHostName-class Win32_Service To get the SQL Server service of the

To get a list of processes on your local computer:Get-WmiObject -class Win32_Process To get the values of related properties for the process sqlservr.exe, the SQL Server service:Get-WmiObject

The StdRegProv class contains methods that manipulate system registry keys and values.To check all the methods that are available from the class StdRegProv:$Reg = [WMIClass]"root\default:stdRegPro

该脚本使用Exchange插件发送mail。打开Powershell ISE，复制下面的脚本并添加正确的email地址即可。ClearAdd-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinuefunction sendmail_withAttachment {P