随笔分类 - [z.4] Morningstar
摘要:NutsAndBolts_V1.1.zip
阅读全文
该文被密码保护。
摘要:pstool下载地址:http://www.xfocus.net/tools/200508/PsTools.zippstool是一组本地与远程信息管理程序pstool用法1)psexecpsexec是一个远程执行工具,你可以像使用telnet一样使用它。它的使用格式为:psexec \\\\远程机器ip [-u username [-p password]] [-c [-f]] [-i][-d] program[arguments]它的参数有:-u后面跟用户名 -p后面是跟密码的,如果建立ipc连接后这两个参数则不需要。(如果没有-p参数,则输入命令后会要求你输入密码)-c <[路径]文
阅读全文
摘要:============================================================================================================================================================================================================================================================================================================
阅读全文
该文被密码保护。
摘要:Hi guysI am concerned on how the tech leaders have approached this topic. I expect from our leaders to tell us more than “it’s hard” – I know that much. The attitude of a leader is to say either “don’t do this, it’s a stupid idea” or else join in to make it happen.We will push this forward and have
阅读全文
摘要:clsfunction get-diskratio(){ param([Parameter(Position=0, Mandatory=$true)] $DiskString ) if ( $DiskString -eq ""){ Write-Output $null ; } else { Write-Host $DiskString.substring($DiskString.IndexOf("|")+1,$DiskString.length-$DiskString.IndexOf("|")-2) Write-Output $Dis
阅读全文
摘要:USE [NutsAndBolts]GO/****** Object: StoredProcedure [dbo].[alert_AlterFailedJobInfo] Script Date: 2012/9/7 9:36:10 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Alex Tian-- Create date: 2012-09-01-- Description: auto alte...
阅读全文
摘要:http://www.sqlservercentral.com/Forums/Topic611107-146-1.aspx
阅读全文
摘要:-- Set the database where the stored procedure is locatedUSE SecurityDataGO-- Drop older version if it existsIF OBJECTPROPERTY(OBJECT_ID(N'dbo.fn_SplitStringToTable'), N'IsTableFunction') = 1 DROP FUNCTION dbo.fn_SplitStringToTableGO-- Procedure: dbo.fn_SplitStringToTable-- Purpose:
阅读全文
摘要:Database Standard Operations List1. DB Development standardl Database is only a storage , do not depend too much on database l Build a standard workflow for who ,when , how regarding different object levels l Make a standard permission control for who should have which rightl Training and let all kn
阅读全文
摘要:DECLARE cConnections CURSOR READ_ONLY FAST_FORWARD FOR SELECT spid FROM master..sysprocesses p INNER JOIN master..syslogins l ON p.sid = l.sid WHERE l.loginname LIKE 'MSDOMAIN1\%' AND l.loginname NOT IN ('MSDOMAIN1\xzhang3', 'MSDOMAIN1\ouli', 'MSDOMAIN1\atian1') AND p
阅读全文