Skip to content

Instantly share code, notes, and snippets.

View davecan's full-sized avatar

David Cantrell davecan

View GitHub Profile
@davecan
davecan / gist:b26aaeb79678c2a8b924
Created February 3, 2016 17:37
Markdown cheat sheet

Header 1

Header 2

Header 3 ### (Hashes on right are optional)

Header 4

Header 5

Markdown plus h2 with a custom ID ## {#id-goes-here}

Link back to H2

This is a paragraph, which is text surrounded by whitespace. Paragraphs can be on one

@davecan
davecan / ef6_deployment_scripts.md
Last active February 3, 2016 17:40
How to script migrations and seeding to generate a final SQL script for execution in the deployment environment (test/prod/etc) without running Seed() method

Targeted deployments with Entity Framework Migrations

This is a note collecting the basic processes of deploying EF6 migrations to other servers (such as test & prod) without running the Seed method in Configuration.cs. It is often the case when deploying to test & prod environments that the DBAs will want to review SQL before it is executed in the target environment. In such a case the Seed method is not run, something that is not often clarified in online tutorials that imply the Seed method will always be available. This requires a completely different approach to seeding data.

Strategy

@davecan
davecan / oracle_1Z0-061_notes.md
Created December 24, 2015 04:02 — forked from switchtrue/oracle_1Z0-061_notes.md
Notes for taking the 1Z0-061 Oracle Exam - Oracle Database 12c: SQL Fundamentals

Introduction

I have compiled these notes whilst revising for the Oracle 1Z0-061 Exam - Oracle Database 12c: SQL Fundamentals. They should also be relevant to the 1Z0-051 - Oracle Database 11g: SQL Fundamentals exam. Revision was most conducted using the excellent and highly recommended "OCA Oracle Database 12c SQL Fundamentals I Exam Guide" by Roopesh Ramklass.

I have aimed to include include in these notes common "gotchas" and easy to forget functionality rather than documenting everything required for the exam. This can then be used as a quick refresher before walking into the exam.

The content is broken up into sections with each heading mapping to the relevant [Oracle 1Z0-061 exam topics](https://edu