最新 | 最热门 | 最高评价
---

+0  Grant full permission to Windows folders and files

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2015年01月21日 02:13 | 点击: 2757 | 展开摘要
For a Windows application or service, it is often necessary for either the user or service startup account to have full control to its folders and files. In most cases, this is transparent to the user. It is generally being taken care of by

查看全文: http://www.udpwork.com/item/13775.html
^..^

+0  JiMetrics now gathers SQL Server startup account

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年06月17日 09:26 | 点击: 2932 | 展开摘要
During the last few days, I’ve refactored JiMetrics and added a new function:

Used Pester to create more test cases for PowerShell functions I wrote;

Enhanced the design and code so JiMetrics also gathers SQL Server instance’s

查看全文: http://www.udpwork.com/item/12637.html
---

+0  Collecting Windows BIOS and Host Serial Number

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年02月21日 09:38 | 点击: 2936 | 展开摘要
After imporving JiMetrics yesterday so it tries to determine if the host is a VM or not, I made another improvement today: collecting host server BIOS related information and serial number.

I don’t know about you, in the past when I

查看全文: http://www.udpwork.com/item/11752.html
^..^

+0  Determining if a Windows host is a VM in JiMetrics

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年02月20日 12:34 | 点击: 4341 | 展开摘要
I’ve been using my own SQL Server metrics collection package called JiMetrics for a couple of years. It is easy to set up. All you need are just two things: SQL Server instance and an account that has admin access to both the servers

查看全文: http://www.udpwork.com/item/11748.html
^..^

+0  Install sqlps as a PowerShell module

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2013年02月16日 11:53 | 点击: 4025 | 展开摘要
Most of SQL Server automation scripts using PowerShell use SMO directly. For example, one would do something like:

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SMO”)

$MyServer = new-object (‘Mic

查看全文: http://www.udpwork.com/item/9250.html
---

+0  Cliffs Notes: administrating Active Directory with PowerShell

Tag: PowerShell | Technology | Windows
Haidong Ji 发于 2012年10月25日 12:44 | 点击: 2102 | 展开摘要
1. Install ActiveDirectory modules by running PowerShell as Administrator and executing the commands below:

PS C:\Windows\system32> Import-Module ServerManager
PS C:\Windows\system32> Add-WindowsFeature RSAT-AD-PowerShell
Success Res

查看全文: http://www.udpwork.com/item/8452.html
^..^

+0  PowerShell TDD with PSUnit: some usage examples

Tag: PowerShell | Technology | Windows
Haidong Ji 发于 2012年10月23日 05:02 | 点击: 2134 | 展开摘要
I discussed setting up PSUnit for unit testing PowerShell before. This is a quick followup for my own record and consumption in the future. I will update this post as I find more interesting things to record.
1. Put PowerShell functions in

查看全文: http://www.udpwork.com/item/8441.html
|<<<1>>>| 一共1页, 7条记录