Pauls Blog

https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

xp_cmdshell allows you to run shell commands from T-SQL Instructions on enabling xp_cmdshell are found at  https://msdn.microsoft.com/en-us/library/ms190693.aspx -- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1; GO -- To update the currently configured value for advanced options. RECONFIGURE; GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1; GO -- To update the currently configured value for this feature. RECONFIGURE; GO

http://www.w3schools.com/sql/func_convert.asp

      public static XmlDocument ConvertToXmlDocument(XDocument input)       {          var xmlDocumentObj = new XmlDocument();          using (var xmlReader = input.CreateReader())          {             xmlDocumentObj.Load(xmlReader);             return xmlDocumentObj;          }       }

https://technet.microsoft.com/en-us/magazine/hh289310.aspx

It's something like this Write - Host "$($blah.Name) $($ blah .Desc) "

nable Remote Desktop and add this domain user to Remove Desktop Users group.   http://technet.microsoft.com/en-us/library/cc794832(WS.10).aspx Enable "Allow log on locally" and add this domain users.  http://technet.microsoft.com/en-us/library/cc785165(WS.10).aspx Delegating administration http://technet.microsoft.com/en-us/library/cc778807(WS.10).aspx

A list of Exchange Cmdlets https://technet.microsoft.com/en-us/library/jj200780(v=exchg.160).aspx Deleting messages from Exchange Online https://support.office.com/en-us/article/Search-for-and-delete-email-messages-in-your-Office-365-organization-3526fd06-b45f-445b-aed4-5ebd37b3762a#step2 The Exchange Web Services API - When youi need message access and the msonline cmdlets don't get you there. https://msdn.microsoft.com/en-us/library/office/dd877012(v=exchg.150).aspx

Try everything https://www.voidtools.com/

powercfg.exe / hibernate  off https://support.microsoft.com/en-au/kb/920730

Recently I needed to encrypt my MSSQL databases. I found the following guides helpful Although this guide mentions the older Server 2008, it explains things well https://technet.microsoft.com/en-us/library/cc278098(v=sql.100).aspx#_Toc189384676 A more recent article https://msdn.microsoft.com/en-AU/library/bb934049.aspx

It's managed via powershell. The powershell module needs to be imported from the powershell command line Microsoft Virtual Machine Converter 3.0 http://www.microsoft.com/en-us/download/details.aspx?id=42497 ie:  Import-Module ‘C:\Program Files\Microsoft Virtual Machine Converter\MvmcCmdlet.psd1’

https://answers.squarespace.com/questions/69925/how-do-i-change-the-banner-height-for-bryant-template.html

Orginally obtained from http://www.sqlservercentral.com/Forums/Topic410557-116-1.aspx /******************************************************************************* Name: GetJobSchedule (For SQL Server7.0&2000) Author: M.Pearson Creation Date: 5 Jun 2002 Version: 1.0 Program Overview: This queries the sysjobs, sysjobschedules and sysjobhistory table to produce a resultset showing the jobs on a server plus their schedules (if applicable) and the maximun duration of the job. The UNION join is to cater for jobs that have been scheduled but not yet run, as this information is stored in the 'active_start...' fields of the sysjobschedules table, whereas if the job has already run the schedule information is stored in the 'next_run...' fields of the sysjobschedules table. Modification History: ------------------------------------------------------------------------------- Version Date Name Modification -----------------

In   Windows 7   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion \SoftwareProtectionPlatform\Activation In the right pane of the registry editor, you will find REG_DWORD value ‘ Manual ’. Right-click on it and select Modify. In the Value Data window which appears, change the DWORD value to  1 . The default is 0 which means auto-activation is enabled. Changing the value to 1 will disable auto-activation. Close the Registry Editor and restart your system. In   Windows Vista   The relevant key is: HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\SL\Activation

https://www.microsoft.com/en-us/download/details.aspx?id=38780

Here's a list of Product Codes. This is the first number of the Product ID. 55274 : XP Pro generic OEM or Volume License (VL is a special case of OEM) 55276 : XP Pro (upgrade)  55276 : XP Home (?) '   55277 : XP Home generic OEM  55285 : XP Pro '   55661 : XP Pro (retail)  76475 : XP Home (upgrade) (?) 76477 : XP Home Royalty OEM 76487 : XP Media Center Edition 2005  76487 : XP Pro Royalty OEM 76487 : XP Pro volume license (with '640' channel ID)  76500 : XP MCE 2005 (XP Pro with AD/GPO disabled)  76588 : XP Pro x64 OEM  The second number is Channel ID 000 : Other (includes some retail, upgrade and evaluation versions)  007 : Retail 009 : Not for resale - bundle  011 : XP Home Upgrade OEM : OEM (This does not specify royalty or normal OEM)  270 : Volume License  296 : MSDN  308/347 : Microsoft Action Pack subscription  335 : Retail  640 through 648, 652 : Volume License (usually generated via 270 CID in setupp.ini)  699 : Volume Windows XP Tablet Edition  071 : Pos