4 Programming Languages You Should Learn Right Now (eClinical Speaking)

I am a strong believer that learning a new language makes you better at the others, but I am not a “learn to code” advocate since a foreign language (I know 3 languages and currently learning my 4th and I have a “to learn” language including Italian and Arabic, if I ever find some freeContinue reading “4 Programming Languages You Should Learn Right Now (eClinical Speaking)”

SQL Basics – Part 2: Create Tables and Variables and more

We’ll dive into CREATE command. We’ll ‘Create’ Tables, Temp Tables, Table Variables and Variables. We are going to ‘Insert’ data into this table (INSERT INTO) and we’ll occasionally ‘DROP’ the tables FAIR USE- “Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment,Continue reading “SQL Basics – Part 2: Create Tables and Variables and more”

SQL Basics – Part 1: Select, From, Where

SQL Basics – Part 1: Visual demonstration of Select, From and Where clauses FAIR USE- “Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwiseContinue reading “SQL Basics – Part 1: Select, From, Where”

Oracle Architecture

A pretty reckless description of what happens when you start Oracle and when you execute a statement. If you’re a developer, it could influence how you code. If you’re a junior DBA, or would be junior DBA, I hope it will help you make sense of some parts of the “Concepts” manual. FAIR USE- “CopyrightContinue reading “Oracle Architecture”

iReview in Clinical Data Management

JReview® is the web-enabled version of Integrated Review™ (iReview). It allows users to view, create, print, and interact with their Integrated Review™ objects locally on an Intranet or securely over the Internet. JReview® can be run in two different modes of operation (authoring and non-authoring) in addition to two modes of communication (clear-text and SSL).Continue reading “iReview in Clinical Data Management”

Tip #4 – Install LinqPad

Tired of querying in antiquated SQL? Well, you don’t have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio! LinqPad comes with 100s of great LINQ samples. Work through the 5-minute induction under the Samples section after installing Low Impact version of LinqPad 4.0. LinqPadContinue reading “Tip #4 – Install LinqPad”