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.
2020 Awards


2019 Awards


2018 Awards


2017 Awards

2016 Awards

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
- Generate Unique Random Number in SQL Server (last update: 4/1/2020)
- 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
- Find SQL Server User Defined Function Create, Modified, Last Execution Date and Code (last update: 11/20/2019)
- 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)
Performance Tuning
- Capture Duration Metrics for SQL Server Query Tuning (last update: 5/21/2020)
- Set Statistics Time Examples for Tuning SQL Server Queries (last update: 4/29/2020)
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)
Query Optimization
- Query Tuning in SQL Server with Set Statistics IO (last update: 5/25/2020)
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)
- Analyze Historical Weather Data with SQL Server (last update: 8/6/2020)
- Analyze Relationship Between Two Time Series in SQL Server (last update: 6/25/2020)
- Analyzing When to Buy and Sell Stocks Using T-SQL in SQL Server (last update: 2/28/2018)
- Artificial Intelligence Programming with T-SQL for Time Series Data (last update: 7/9/2020)
- Assessing with SQL and Data Science Goodness of Fit to Different Distributions (last update: 1/14/2019)
- Collecting Time Series Data for Stock Market with SQL Server (last update: 2/10/2020)
- Compare Artificial Intelligence Models Built with T-SQL (last update: 7/30/2020)
- Contingency Table Analysis via Chi Square using T-SQL: Part 1 (last update: 2/4/2019)
- Exponential Moving Average Calculation in SQL Server (last update: 6/16/2020)
- How to Compare and Combine Artificial Intelligence Models with T-SQL (last update: 8/3/2018)
- How to Compute Simple Moving Averages with Time Series Data in SQL Server (last update: 3/3/2020)
- Implement K Nearest Neighbor Solution with T-SQL (last update: 10/14/2020)
- Load Time Series Data with SQL Server (last update: 1/24/2020)
- 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)
- Multiple Regression Model Enhanced with Bagging (last update: 1/8/2021)
- 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 Code for Decision Tree Regression Algorithm - Part 3 (last update: 12/8/2020)
- T-SQL Code for Multi-Level Decision Tree - Part 2 (last update: 11/23/2020)
- T-SQL Code for the Decision Tree Algorithm - Part 1 (last update: 10/27/2020)
- 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)
- Time Series Data Fact and Dimension Tables for SQL Server (last update: 2/14/2020)
- 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)
- Weather Data Warehouse in SQL Server - Create and Populate (last update: 9/16/2020)
- Weather Data Warehouse in SQL Server - Gather Information (last update: 9/1/2020)
- Weather Station Tracking with SQL Server and Excel (last update: 8/13/2020)
- Weighted vs Simple Moving Average with SQL Server T-SQL Code (last update: 3/16/2020)
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)
Views
- Create, Alter, Drop and Query SQL Server Views (last update: 12/12/2019)
- Insert and Delete SQL Server Data with Views (last update: 1/2/2020)
- Track and Monitor SQL Server View Usage (last update: 12/4/2019)