Stefan Teixeira stefanteixeira
stefanteixeira
/ protractor-saucelabs.js
Created
December 17, 2015 02:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exports.config = { | |
| framework: 'jasmine2', | |
| specs: ['spec/**/*.js'], | |
| sauceUser: 'seu-usuario', | |
| sauceKey: 'sua-access-key', | |
| multiCapabilities: [{ | |
| 'name': 'UI Tests', | |
| 'browserName': 'chrome', | |
| 'version': '46.0', |
stefanteixeira
/ packer-ebs-snapshot-id
Created
October 2, 2015 19:48
Get EBS Snapshot ID from a Packer build
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| packer build -machine-readable packer.json | tee build.log | |
| grep 'Tagging snapshot' build.log | cut -d, -f5 | cut -d: -f3 | grep -o '[^$(printf '\t')].*' |
stefanteixeira
/ UnzipFile.ps1
Last active
May 30, 2017 06:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $file = "C:\Path\To\Your\File.zip" | |
| $destination = "C:\DestinationPath" | |
| Add-Type -assembly "system.io.compression.filesystem" | |
| [io.compression.zipfile]::ExtractToDirectory($file, $destination) |
stefanteixeira
/ ZipFolder.ps1
Last active
January 20, 2021 04:23
PowerShell script to compress a directory to a .zip file
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $source = "C:\Path\To\Directory" | |
| $destination = "C:\Path\To\Zip\file.zip" | |
| If(Test-path $destination) {Remove-item $destination} | |
| Add-Type -assembly "system.io.compression.filesystem" | |
| [io.compression.zipfile]::CreateFromDirectory($Source, $destination) |
stefanteixeira
/ SetAccessRuleOnDirectory.ps1
Last active
September 19, 2022 02:07
PowerShell script to add permissions for the MSSQLSERVER user to a directory
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| New-Item -ItemType Directory -Force -Path C:\Path\To\Directory | |
| $path = "C:\Path\To\Directory" | |
| $Acl = (Get-Item $path).GetAccessControl('Access') | |
| $Ar = New-Object System.Security.AccessControl.FileSystemAccessRule("NT SERVICE\MSSQLSERVER", "FullControl", "ContainerInherit,ObjectInherit", "None", "Allow") | |
| $Acl.SetAccessRule($Ar) | |
| Set-Acl $path $Acl |
stefanteixeira
/ ConfigWinFirewall.ps1
Created
August 25, 2015 20:03
PowerShell sample script to configure a Windows firewall rule
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| New-NetFirewallRule -DisplayName "MSSQL" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow |
stefanteixeira
/ EnableTCPSQLServer.ps1
Created
August 25, 2015 20:02
PowerShell script to enable TCP in SQL Server
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Import-Module "sqlps" | |
| $smo = 'Microsoft.SqlServer.Management.Smo.' | |
| $wmi = new-object ($smo + 'Wmi.ManagedComputer'). | |
| # List the object properties, including the instance names. | |
| $Wmi | |
| # Enable the TCP protocol on the default instance. | |
| $uri = "ManagedComputer[@Name='" + (get-item env:\computername).Value + "']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']" | |
| $Tcp = $wmi.GetSmoObject($uri) |
stefanteixeira
/ setupMixedMode.sql
Last active
September 1, 2015 16:58
Script to enable mixed mode authentication in SQL Server
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| To run the script from the DB machine, use: sqlcmd -S localhost -i C:\Path\To\File\setupMixedMode.sql | |
| */ | |
| USE [master] | |
| EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2 | |
| GO |
stefanteixeira
/ configIPAll.vbs
Created
August 25, 2015 19:59
WMI script to configure IPAll properties for SQL Server TCP Configuration
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| set wmiComputer = GetObject( _ | |
| "winmgmts:" _ | |
| & "\\.\root\Microsoft\SqlServer\ComputerManagement12") | |
| set tcpProperties = wmiComputer.ExecQuery( _ | |
| "select * from ServerNetworkProtocolProperty " _ | |
| & "where InstanceName='MSSQLSERVER' and " _ | |
| & "ProtocolName='Tcp' and IPAddressName='IPAll'") | |
| for each tcpProperty in tcpProperties | |
| dim setValueResult, requestedValue |
stefanteixeira
/ configIP1.vbs
Created
August 25, 2015 19:58
WMI script to configure IP1 properties for SQL Server TCP Configuration
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| set wmiComputer = GetObject( _ | |
| "winmgmts:" _ | |
| & "\\.\root\Microsoft\SqlServer\ComputerManagement12") | |
| set tcpProperties = wmiComputer.ExecQuery( _ | |
| "select * from ServerNetworkProtocolProperty " _ | |
| & "where InstanceName='MSSQLSERVER' and " _ | |
| & "ProtocolName='Tcp' and IPAddressName='IP1'") | |
| for each tcpProperty in tcpProperties | |
| dim setValueResult, requestedValue |
NewerOlder