matejskubic

select 
    'ALTER TABLE [' + TABLE_NAME + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']'
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

matejskubic

REM source: https://answers.microsoft.com/en-us/windows/forum/windows_10-networking/how-to-set-an-ethernet-connection-as-metered-to/ecdaca08-d413-4a6a-9e33-b4afb337fc18?auth=1
REM The key is [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\DefaultMediaCost]
REM There are entries under it for 3G, 4G, Default, Ethernet and Wifi. The normal settings for 3G and 4G are 2. For Ethernet and Wifi (and Default) it is 1. 2 means metered, 1 means not metered. So to make Ethernet Metered, the value needs to be changed from 1 to 2. 

rem run from install directory
 cd /d C:\Program Files\Windows Resource Kits\Tools\

rem change owner to Administrators
 rem should report: Done:        1, Modified        1, Failed        0, Syntax errors        0
 subinacl /subkeyreg "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\DefaultMediaCost" /setowner=administrators

matejskubic

select b.spid, b.hostname, b.program_name, a.net_transport, a.auth_scheme
from sys.dm_exec_connections a
inner join sys.sysprocesses b
  on a.session_id = b.spid

matejskubic

declare @x table(xf date, xt date, name varchar(50))
declare @y table(yf date, yt date, name varchar(50))
declare @z table(zf date, zt date, name varchar(50))

insert @x values ('2000-01-01', '2000-01-05', 'X1')
insert @x values ('2000-01-06', '2000-01-20', 'X2')
insert @y values ('2000-01-01', '2000-01-10', 'Y1')
insert @y values ('2000-01-11', '2000-01-20', 'Y2')
insert @z values ('2000-01-01', '2000-01-15', 'Z1')
insert @z values ('2000-01-16', '2000-01-20', 'Z2')

matejskubic

[CmdletBinding(DefaultParameterSetName="UseContextVariables")]
Param(
    # folder to upload
    [parameter(Position=0, ParameterSetName="UseArgs", Mandatory=$true)]
    [string]$dropLocation = (Get-Variable $dropLocation -ValueOnly -ErrorAction SilentlyContinue)
    ,
    # upload location - sugned Azure blob url with upload permission
    [uri]$blobFileUri="http://$_StorageAccount.blob.core.windows.net/$_Company/Appl.zip?sr=b&sv=2015-02-21&si=deploy$Company&sig=$_Signature"
    ,
    # build version - added to Metadata.AxModelVersion

matejskubic

Rundll32 dsquery.dll OpenQueryWindow

matejskubic

Import-Module ActiveDirectory
Get-ADPrincipalGroupMembership (Read-Host "Username")|select SamAccountName| sort SamAccountName | ConvertTo-Csv -NoTypeInformation > "$($env:TEMP)\user-groups.csv"
start "$($env:TEMP)\user-groups.csv"

matejskubic

runas /user:domain\user /netonly %1

matejskubic

$mailMessage = New-Object System.Net.Mail.MailMessage

$mailMessage.From = New-Object System.Net.Mail.MailAddress("name@from.dom")
$mailMessage.To.Add("name@to.dom")
$mailMessage.Subject = "FYI: How to save mail messages to .eml files"
$mailMessage.Body = "This can be accomplished by changing the smtp delivery method to a pickup directory..."

$smtpClient = New-Object System.Net.Mail.SmtpClient
$smtpClient.DeliveryMethod = [System.Net.Mail.SmtpDeliveryMethod]::SpecifiedPickupDirectory;

matejskubic

<!-- \Program Files\Microsoft Team Foundation Server 12.0\Application Tier\Web Services\_areas\Agile\Views\Backlogs\IterationBoard.aspx -->
<!-- add at the end of <asp:Content ContentPlaceHolderID="RightHubContent" runat="server"> -->
	<script defer="defer" type="application/javascript">
		function popraviOzadje()
		{
			try
			{
				var taskboardData = JSON.parse(document.getElementById('taskboard').children[0].innerHTML);
				var parentIds = taskboardData.parentIds;
				var stateCol = 0;