oskaremil

#!/bin/bash
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -Q "CREATE DATABASE TestDatabase"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -Q "CREATE LOGIN testuser WITH PASSWORD = '***'"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "CREATE USER testuser FOR LOGIN testuser"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "ALTER ROLE db_owner ADD MEMBER testuser"

oskaremil

-- Create a procedure that returns random integers.
IF OBJECT_ID('sp_RandomInt', 'P') IS NOT NULL
    DROP PROCEDURE sp_RandomInt;
GO
CREATE PROCEDURE sp_RandomInt
    @lower INT = 1, 
    @upper INT,
    @randomInt INT = NULL OUTPUT
AS
BEGIN

oskaremil

Install-Module posh-git -Scope CurrentUser
Install-Module PSExcel -Scope CurrentUser
Install-Module SqlServer -Scope CurrentUser -Force

oskaremil

choco install baretail
choco install fiddler -y
choco install yarn -y

oskaremil

[ ] Preferred JavaScript framework: 
[ ] Authenticated routes: 
[ ] Responsive design (minimum device width): 
[ ] Design guidelines: 
[ ] Accessibility features: 
[ ] Minimum supported version of Internet Explorer:
[ ] Search Engine Optimizations: 
[ ] Site Analytics: 

oskaremil

-- List all tables containing column named [columnname]
SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%columnname%'
ORDER BY    TableName
            ,ColumnName;
            
            

oskaremil

#Set $true to remove Windows Mail and Windows Calendar
$removeMail = $null

# Remove 3D from Windows 10
Get-AppxPackage *3d* | Remove-AppxPackage

# Remove Camera from Windows 10
Get-AppxPackage *camera* | Remove-AppxPackage

# Remove Mail and Calendar from Windows 10

oskaremil

/**
 * Turqoise band
 */
#frame{
margin: 200px 20px;
}
#band {

background-image:

oskaremil

/**
 * Turqoise band
 */
#frame{
margin: 200px 20px;
}
#band {

background-image:

oskaremil

/**
 * Fancy button draft
 */

input.fancybutton{
	font-size: 2em;
	height: 3em;
	width: 8em;
	border-radius: 20px;
	border-color: rgba(0,0,0,.2);