Skip to content

Instantly share code, notes, and snippets.

View sfrechette's full-sized avatar

Stéphane Fréchette sfrechette

View GitHub Profile
@sfrechette
sfrechette / TemporalTableDemo.sql
Last active October 8, 2016 04:52
T-SQL Temporal Tables Demo Script
use Sandbox
go
-- Create Employee table...
create table dbo.Employee
(
EmployeeID int not null primary key clustered,
EmployeeName nvarchar(100) not null,
JobTitle nvarchar(50) not null,
Department nvarchar(50) not null,
@sfrechette
sfrechette / CraftCans.sql
Created May 16, 2017 13:04
SQL Script to create the CraftCans relational database
--Create CraftCans database
CREATE DATABASE CraftCans;
GO
USE CraftCans;
GO
/****** Object: Table [dbo].[Beer] ******/
SET ANSI_NULLS ON
GO

Keybase proof

I hereby claim:

  • I am sfrechette on github.
  • I am sfrechette (https://keybase.io/sfrechette) on keybase.
  • I have a public key ASCEwiXaUg4jEk0e6JLdul5TjV56rFXVf1G3B7z43iqqsQo

To claim this, I am signing this object:

@sfrechette
sfrechette / PauseAzureSQLDataWarehouses.ps1
Last active November 27, 2018 14:39
Pause Azure SQL DataWarehouses
workflow PauseAzureSQLDataWarehouses
{
$connectionName = "AzureRunAsConnection"
try
{
# Get the connection "AzureRunAsConnection "
$servicePrincipalConnection=Get-AutomationConnection -Name $connectionName
"Logging in to Azure..."
Add-AzureRmAccount `

Keybase proof

I hereby claim:

  • I am sfrechette on github.
  • I am sfrechette (https://keybase.io/sfrechette) on keybase.
  • I have a public key ASB-MuIUfjVLwAck6dWFHdyh8pjV2mSHzUesq-0z0vydrgo

To claim this, I am signing this object: