Rick Dobson

Rick Dobson

Rick Dobson started using SQL Server with version 7. He has been active as a SQL developer who has contributed to the SQL community as an author/trainer as well as a SQL professional who practices his skills in various domains, such as human resources, finance, and healthcare. You can learn more about Rick from his LinkedIn profile.

2019 Awards
MSSQLTips award

MSSQLTips award

2018 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

2017 Awards
MSSQLTips award

MSSQLTips award

2016 Awards
MSSQLTips award

MSSQLTips award

Constraints

List Dependencies for SQL Server Foreign Keys (last update: 3/16/2017)

Data Science

Data Science with SQL Server for Inferential and Predictive Statistics: Part 2 (last update: 9/3/2018)

Dates

Converting and Using Text Dates as SQL Server Dates (last update: 5/26/2015)
Work around for calculating age using the SQL Server DateDiff function (last update: 5/9/2012)

Encryption

Masking Personal Identifiable SQL Server Data (last update: 11/13/2013)

Functions - System

Name Parsing for Result Sets with Different Name Formats (last update: 7/15/2014)
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL (last update: 9/16/2014)
Name Parsing with SQL Server Functions and T-SQL Programming (last update: 5/22/2014)
T-SQL Starter Statistics Package for SQL Server (last update: 6/7/2018)

Functions - User Defined UDF

SQL Server User Defined Function Example (last update: 11/1/2019)
SQL Server User Defined Function Overview (last update: 10/8/2019)

Import and Export

Import end of day prices for all NASDAQ stocks into SQL Server (last update: 12/14/2017)
Importing Historical Stock Prices from Yahoo Finance into SQL Server (last update: 11/14/2017)
Using a Simple SQL Server Bulk Insert to View and Validate Data (last update: 1/9/2015)

Integration Services Development

Dynamically Name Text Files in SQL Server Integration Services (last update: 12/2/2011)

Other Database Platforms

Creating a SQL Server 2014 Linked Server for an Oracle 11g Database (last update: 7/29/2016)
Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g (last update: 8/26/2016)
Transferring Data Between SQL Server 2014 and Oracle 11g Databases (last update: 8/18/2016)
Transferring data from SAS to SQL Server and back (last update: 3/30/2012)
Using SAS ACCESS and PROC SQL to Retrieve SQL Server Data (last update: 7/6/2012)
Using SAS ACCESS and PROC SQL to Save SAS Data in SQL Server (last update: 10/5/2012)
Using Wizards to Export a Dataset from SAS to SQL Server (last update: 7/2/2012)

Professional Development Certifications

Do You Want to be a Certified SQL Server Database Development Expert (last update: 7/21/2011)
Do You Want to be a Microsoft Certified SQL Server DBA Expert (last update: 1/24/2011)
SQL Server 2012 Certification Path (last update: 11/26/2012)
Study material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 (last update: 2/5/2013)
Study material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 - Part 2 (last update: 3/13/2013)

Reporting Services Charts

Creating High-Low-Open-Close Candlestick Charts with SQL Server Reporting Services (last update: 1/12/2017)

Reporting Services Development

Creating an SQL Server Reporting Services Matrix Sparkline Report with Data from Oracle 11g (last update: 9/15/2016)

Security

Get Started with SQL Server xp_cmdshell (last update: 3/8/2019)

SQL Server 2016

Execute Python Scripts with Management Studio to Securely Import Data into SQL Server (last update: 9/25/2017)
Import Historical Stock Prices into SQL Server using Python (last update: 10/12/2017)
Installing Python and Running Python Scripts from SQL Server SSMS (last update: 9/6/2017)

SQL Server 2017

Scraping HTML Tables with Python to Populate SQL Server Tables (last update: 11/6/2017)
Web Screen Scraping with Python to Populate SQL Server Tables (last update: 10/20/2017)

SQL Server Agent

Creating Multi-Step and Dynamic SQL Server Agent Jobs (last update: 6/26/2017)
Getting Started with SQL Server Agent - Part 1 (last update: 6/12/2017)
Queries to inventory your SQL Server Agent Jobs (last update: 7/21/2017)
Scripting New SQL Server Agent Jobs from Prior Job Scripts (last update: 8/23/2017)
SQL Server Agent Job Schedule Reporting (last update: 8/31/2017)
Tracking and Counting SQL Server Agent Job Runs (last update: 8/11/2017)

Stored Procedures

Create, Alter, Drop and Execute SQL Server Stored Procedures (last update: 8/12/2019)
Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code (last update: 10/1/2019)
Save SQL Server Stored Procedure Results to Table (last update: 9/2/2019)
SQL Server Stored Procedure Context Switching and Impersonation Example (last update: 9/20/2019)
SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value (last update: 8/21/2019)

T-SQL

A One-Way Analysis of Variance Test Add-on for the SQL Statistics Package (last update: 10/3/2018)
A T-SQL Model for Contrasting Two Different Sets of Measurement (last update: 7/5/2018)
A Two-Way Analysis of Variance Test Add-on for the SQL Statistics Package (last update: 10/29/2018)
An Overview of Data Science for Stock Price Analysis with SQL: Part 1 (last update: 8/22/2018)
Analyzing When to Buy and Sell Stocks Using T-SQL in SQL Server (last update: 2/28/2018)
Assessing with SQL and Data Science Goodness of Fit to Different Distributions (last update: 1/14/2019)
Contingency Table Analysis via Chi Square using T-SQL: Part 1 (last update: 2/4/2019)
How to Compare and Combine Artificial Intelligence Models with T-SQL (last update: 8/3/2018)
Mining Stock Price Time Series with MACD in SQL Server (last update: 2/6/2018)
Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server (last update: 12/27/2017)
Mining Time Series with Exponential Moving Averages in SQL Server (last update: 1/25/2018)
One-way and Two-way Tabulation Example in SQL Server - Part 2 (last update: 2/26/2019)
Pass Historical Data for Stocks from Google Finance to SQL Server (last update: 10/27/2016)
Query for pair-wise relationships between rows for a SQL Server table (last update: 2/23/2016)
SQL Server and Excel Hierarchyid Example for Organization Charts (last update: 7/4/2019)
SQL Server Data Mining Strategies for Stock Buy and Sell Recommendations (last update: 10/17/2016)
SQL Server Hierarchyid Data Type Overview and Examples (last update: 6/21/2019)
SQL Server Hierarchyid Example for Bill of Materials (last update: 7/23/2019)
SQL Server T-SQL Code for the Tukey Honestly Significant Difference Test After an ANOVA (last update: 11/23/2018)
T-SQL to Calculate Buy and Sell Stock Recommendations via Three Technical Indicators (last update: 7/20/2018)
T-Test Add-on for the SQL Statistics Package (last update: 9/25/2018)
Using SQL Server Data Analysis for Stock Trading Strategies (last update: 10/4/2016)
Using SQL to Assess Goodness of Fit to Normal and Uniform Distributions (last update: 1/2/2019)
Using T-SQL to Assess Goodness of Fit to an Exponential Distribution (last update: 12/13/2018)
Using T-SQL to Detect Golden Crosses and Death Crosses (last update: 5/4/2018)
Using T-SQL to Detect Stock Price Reversals with the RSI (last update: 3/19/2018)
Using T-SQL to Quantify Trend Direction and Strength (last update: 5/24/2018)
Using T-SQL to Refine an Analytical Model for Picking Stocks (last update: 4/5/2018)
Using Two Samples to Validate MACD with T-SQL (last update: 6/27/2018)

Temp Tables

Differences Between SQL Server Temp Tables, Table Variables, Subqueries, Derived Tables, CTEs and Physical Tables (last update: 6/12/2019)
Local vs Global SQL Server Temporary Tables (last update: 5/9/2019)
SQL Server Common Table Expression vs Temp Table (last update: 5/22/2019)
SQL Server Derived Table Example (last update: 5/16/2019)
SQL Server Staging Table vs Temp Table (last update: 5/23/2019)
SQL Server Subquery Example (last update: 5/13/2019)
SQL Server Table Variable Example (last update: 5/20/2019)
SQL Server Uncorrelated and Correlated Subquery (last update: 5/15/2019)
Types of SQL Server Temporary Tables (last update: 5/8/2019)

More SQL Server Solutions

download

get free sql tips