Skip to content

Instantly share code, notes, and snippets.

View dougwaldron's full-sized avatar

Doug Waldron dougwaldron

5 followers · 1 following
View GitHub Profile
@dougwaldron
dougwaldron / Oracle-to-SQL-Server-notes.md
Created May 19, 2020 13:55
Oracle to SQL Server code migration notes

Oracle to SQL Server code migration notes

Things to look for when rewriting Oracle SQL statements for use in SQL Server:

  • Parameterize all the things!
  • Fix unnamed subqueries (or consider converting to a join)
  • If a filter should be case-sensitive but isn't, add a COLLATE clause
  • Always specify column names in INSERT statements
  • Move ORDER BY clauses out of subqueries
  • Get rid of REPLACE(expression, "'", "''") (and parameterize the expression)
@dougwaldron
dougwaldron / find_references.bat
Created May 18, 2020 21:21
Find text within files in a folder
@ECHO OFF
REM Batch script for searching for text strings within files in a folder
REM Set the name of the file containing the object names you want
REM to search for. This file should contain one object name per line.
REM ("Object" here could mean tables, views, procedures, etc.)
SET LIST_OF_OBJECT_NAMES=./all_object_names.txt
@dougwaldron
dougwaldron / 1-Application-quality.md
Created May 18, 2020 20:09
Application quality

Application Quality Goals

Overall application quality goes beyond implementing features and includes:

  • Accessibility
  • Usability
  • Performance
  • Security
  • Reliability
  • Maintainability
@dougwaldron
dougwaldron / .gitignore
Created January 3, 2019 18:29
Global .gitignore file
# Global ignore file
# Windows image file caches
Thumbs.db
ehthumbs.db
# Folder config file
Desktop.ini
# Recycle Bin used on file shares
@dougwaldron
dougwaldron / ApexSQLRefactor_FormattingSettings.xml
Created July 26, 2017 14:44
<?xml version="1.0"?>
<PublicOptions>
<ActiveProfile>Default</ActiveProfile>
<LanguagesOptionsPublic>
<Name>Java</Name>
<Prefix>String sql = "</Prefix>
<Suffix>";</Suffix>
<EscapeCharsForQuotes>\</EscapeCharsForQuotes>
<LengthLimit>40</LengthLimit>
<LineSeparator>\n"
@dougwaldron
dougwaldron / dabblet.css
Created June 25, 2012 15:57 — forked from chriscoyier/dabblet.css
Untitled
body {
font-family: sans-serif;
}
ul {
list-style: none
}
li {
background: slategrey;
@dougwaldron
dougwaldron / gist:2499331
Created April 26, 2012 12:48
Great text shadow example
h1 { /* From http://westcoastlogic.com/slides/debug-mobile/#/4 */
text-shadow:
0 1px 0 #CCC,
0 2px 0 #C9C9C9,
0 3px 0 #BBB,
0 4px 0 #B9B9B9,
0 5px 0 #AAA,
0 6px 1px rgba(0, 0, 0, .1),
0 0 5px rgba(0, 0, 0, .1),
0 1px 3px rgba(0, 0, 0, .3),
@dougwaldron
dougwaldron / dabblet.css
Created January 4, 2012 18:33 — forked from kizu/dabblet.css
Centered heading with fading rules
/* Centered heading with rules */
h1 {
position: relative;
overflow: hidden;
white-space: nowrap;
text-align: center;
text-overflow: ellipsis;
font: 1.6em/1.1 Georgia;
padding: .2em 0;
@dougwaldron
dougwaldron / gist:1151942
Created August 17, 2011 16:28
More Chrome Inspector CSS
/* Additional styles for Chrome Inspector; should be used with
http://darcyclarke.me/design/skin-your-chrome-inspector/
and
http://dpaste.com/hold/595890/
*/
#elements-content li.hovered:not(.selected) .selection {
/* hover color */
background: rgba(255, 255, 255, .2) !important;
}
#elements-content .selection.selected {