Rick Dobson

Rick Dobson is a SQL Server professional with decades of T-SQL experience that includes authoring books, running a national seminar practice, working for businesses on finance and healthcare development projects, and serving as a regular contributor to MSSQLTips.com. He has been a practicing Python developer for more than the past half decade – with a special emphasis for data visualization and ETL tasks with JSON and CSV files. His most recent professional passions include financial time series data and analyses, AI models, and statistics. If you are interested in growing your skills in any of these areas especially as they relate to financial securities, consider visiting his blog at https://securitytradinganalytics.blogspot.com/2023/12/.
  • MSSQLTips Awards: Leadership (200+ tips) - 2025 | Author of the Year Contender - 2017-2024
Title Category Date
SQL CTE Examples for Time Series Analysis Common Table Expressions2026-06-04
SQL Rand Function to Perform Monte Carlo Simulation TSQL2026-05-13
T‑SQL BULK INSERT vs OPENROWSET Import and Export2026-05-06
Find Duplicate Rows in SQL Server with a CTE Common Table Expressions2026-04-21
Recursive EMA Logic in SQL Server Using Wide-Format Time Series Data TSQL2025-11-21
Calculate Exponential Moving Average in SQL Server TSQL2025-11-06
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets Import and Export2025-10-09
SQL Generate Date Examples with Recursive CTE and Stored Procedure Common Table Expressions2025-08-29
Rand() and Newid() for SQL Random Numbers TSQL2025-06-11
Automated Backtesting with SQL Server and Microsoft Copilot TSQL2025-05-23
Evaluating the Randomness of SQL Server Random Number Functions Functions System2025-04-24
Digitally Signing a SQL Stored Procedure Stored Procedures2025-03-14
SQL ROUND – Rounding versus Truncating TSQL2025-02-12
Compare SQL Round to Bankers Rounding for Millions of Decimal Values TSQL2024-12-24
SQL Server Column Encryption and Decryption​ with Code Examples Encryption2024-12-18
GUID in SQL Server​ Database Design2024-11-22
SQL Server Metadata for Stored Procedures, Functions and Views Database Administration2024-09-27
SQL Metadata in sys.databases, sys.objects, sys.tables and sys.columns Database Administration2024-08-28
SQL ROUND Function vs. Bankers Rounding with T-SQL TSQL2024-07-29
Windows Copilot vs. Google Gemini to Build SQL Queries Artificial Intelligence2024-06-25
Generating Uniform, Normal, or Lognormal Random Numbers in SQL Server TSQL2024-05-31
SQL Bulk Insert Command Examples Import and Export2024-05-10
Google Gemini AI Tool to Build and Explain T-SQL Code Artificial Intelligence2024-04-15
Calculate Modes in T-SQL with SQL Server Data TSQL2024-03-20
Assessing if Dataset Values are Lognormal Distributed with Python Python2024-02-13
SQL Server Data Mining Example to Compare Leveraged Inverse ETFs TSQL2023-12-22
Query SQL Server sys.objects for Database Objects Information TSQL2023-12-20
BeautifulSoup, Python and T-SQL to Import Unstructured Web Content Python2023-11-20
Time Series Data Mining Example with T-SQL when Adding New Data TSQL2023-11-09
Scrape Web Page and Store in SQL Server with Python and BeautifulSoup Python2023-10-30
SQL Server Rounding to the Nearest Penny with T-SQL TSQL2023-10-10
SQL WHILE Loop to Process Time Series Data TSQL2023-09-25
SQL Rounding Functions with ROUND, CEILING, FLOOR, Bankers Rounding TSQL2023-09-20
Create AI Models with T-SQL for Stock Purchases and Sales Artificial Intelligence2023-08-31
Perform Statistical Calculations on SQL Server Data TSQL2023-08-10
Compare Alternative Plans for Investing in Financial Securities TSQL2023-07-25
Screen Scraping with Python and BeautifulSoup Python2023-07-14
SQL Server metadata sys.tables, sys.columns, sys.all_columns and more TSQL2023-06-20
SQL Metadata Queries for sys.databases and sys.tables TSQL2023-06-06
T-SQL Calculations for Arithmetic Mean, Geometric Mean and Median TSQL2023-05-24
Custom Chi-Square Test for Homogeneity with SQL Server Data TSQL2023-05-09
Ensemble AI Models in SQL Server Artificial Intelligence2023-04-25
SQL Server Workbench Database Setup, Object Migration, Modifications Database Configurations2023-04-05
SQL Subquery Use Cases TSQL2023-03-22
Buy-Sell Model for Financial Securities with SQL Server and T-SQL Code TSQL2023-03-10
Animated Line Plots with Python Examples Python2023-02-13
Python Normal Distribution Example Python2023-02-01
Use SQL Server to Compare Leveraged versus Unleveraged ETFs TSQL2023-01-19
Process JSON files with SQL Server TSQL2023-01-12
Calculate MACD indicators using T-SQL Code and Data in SQL Server TSQL2022-12-15
Correlate Gross Domestic Product (GDP) with Business Indicators TSQL2022-12-09
Request and Process Data from a Restful API using Python and JSON API2022-11-17
Write and Read JSON Files with Python Python2022-11-04
SQL Money Data Type vs. SQL Decimal for Monetary Values in SQL Server Data Types2022-10-21
Time Series Data Models in SQL Server and Excel to Visualize Data TSQL2022-10-07
Compare Buy-Sell Models for Securities in SQL Server TSQL2022-09-23
Framework for Data Science Time Series Model Building in SQL Server TSQL2022-09-08
Excel Line Charts and Scatter Charts with SQL Server Data Microsoft Excel Integration2022-08-23
Create Subplots for Line and Candlestick Charts with Python and Plotly Python2022-08-05
Subplots Visualization for SQL Server Data with Python and Matplotlib Python2022-07-21
Python User Defined Functions for SQL Server Professionals Python2022-07-11
Options for Collecting Securities Prices and Load into SQL Server TSQL2022-06-27
Relative Strength Index Predictions with SQL Code TSQL2022-06-17
Calculate Candlestick Chart Values to Buy and Sell Financial Security TSQL2022-05-27
Candlestick Charts for Time Series Data in SQL Server and Python TSQL2022-05-24
Build Heikin Ashi Charts in Excel based on Financial Time Series Data TSQL2022-04-29
T-SQL to Build Models that Specify when to Buy or Sell a Stock TSQL2022-04-27
Compare Time Series Datasets with T-SQL Code TSQL2022-03-30
Create Candlestick and Heikin Ashi Charts for Time Series Data TSQL2022-03-10
SQL Stored Procedure with Parameters and Return Values Stored Procedures2022-02-24
Migrate Time Series Data to SQL Server from Yahoo Finance Stooq.com TSQL2022-02-24
Learn WHILE and GOTO Loops with T-SQL for Time Series Data TSQL2022-02-17
Artificial Intelligence Models to Buy and Sell Financial Securities TSQL2022-02-02
Time Series Data in SQL Server to Model and Log Trends TSQL2022-01-21
MACD Indicator with SQL Code to Buy and Sell Securities TSQL2022-01-19
Relative Strength Index using Time Series Data in SQL Server TSQL2021-12-14
Treemap Charts for SQL Server Python2021-12-03
Model Decisions for Time Series Values based on Performance Scores TSQL2021-11-29
Performance Charts for Time Series Data with SQL Server and Python Python2021-11-10
Pie Charts in Python from SQL Server Data Python2021-10-20
Learn xp_cmdshell in SQL Server Security2021-10-13
Time Series Analysis in SQL Creation and Comparison TSQL2021-10-07
Stooq Historical Stock Price and Volume Data SQL Server Download Import and Export2021-09-02
Plotting in Python Financial Time Series from SQL Server Python2021-08-30
Create, Populate, and Subset a Pandas Dataframe from a CSV File Other Database Platforms2021-08-16
Data Engineering a Solution with Python and SQL Server Python2021-07-27
Exponential Moving Average vs. Simple Moving Average in SQL Server TSQL2021-07-12
Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON TSQL2021-06-22
SQL JSON Examples for Formatted Data and Data Transfer TSQL2021-06-07
Wilcoxon Signed Rank Test in SQL Server TSQL2021-05-26
Sign Test with T-SQL TSQL2021-05-11
Python Bar Charts and Line Charts Examples Python2021-04-26
Techniques for Collecting Stock Data with Python Python2021-04-20
Create, Populate, and Transform Geographic Coordinates in SQL Server TSQL2021-04-06
String to Numeric Geographic Coordinates in SQL Server with T-SQL TSQL2021-03-30
Scripts to Automate Creating and Loading a SQL Server Table TSQL2021-03-03
Geographic Coordinates in SQL Server TSQL2021-02-22
Decision Tree Regression vs Bagging Regression with T-SQL and Excel TSQL2021-02-05
Multiple Regression Model Enhanced with Bagging TSQL2021-01-08
T-SQL Decision Tree Regression Algorithm TSQL2020-12-08
T-SQL Code for Multi-Level Decision Tree TSQL2020-11-23
Decision Tree Algorithm with Gini Index in TSQL TSQL2020-10-27
K Nearest Neighbor TSQL SQL Server Example TSQL2020-10-14
Weather Data Warehouse in SQL Server – Create and Populate TSQL2020-09-16
Weather Data Warehouse in SQL Server – Gather Information TSQL2020-09-01
Weather Station Tracking with SQL Server and Excel TSQL2020-08-13
Analyze Historical Weather Data with SQL Server TSQL2020-08-06
Compare Artificial Intelligence Models Built with T-SQL Artificial Intelligence2020-07-30
Artificial Intelligence Programming with T-SQL for Time Series Data Artificial Intelligence2020-07-09
Analyze Relationship Between Two Time Series in SQL Server TSQL2020-06-25
Exponential Moving Average Calculation in SQL Server TSQL2020-06-16
Query Tuning in SQL Server with Set Statistics IO Query Optimization2020-05-25
Capture Duration Metrics for SQL Server Query Tuning Performance Tuning2020-05-21
Set Statistics Time Examples for Tuning SQL Server Queries Performance Tuning2020-04-29
Generate Unique Random Number in SQL Server Functions System2020-04-01
Weighted vs Simple Moving Average with SQL Server T-SQL Code Functions System2020-03-16
How to Compute Simple Moving Averages with Time Series Data in SQL Server TSQL2020-03-03
Time Series Data Fact and Dimension Tables for SQL Server TSQL2020-02-14
Collecting Time Series Data for Stock Market with SQL Server TSQL2020-02-10
Load Time Series Data with SQL Server TSQL2020-01-24
Insert and Delete SQL Server Data with Views Views2020-01-02
Create, Alter, Drop and Query SQL Server Views Views2019-12-12
Track and Monitor SQL Server View Usage Views2019-12-04
Get SQL Server UDF Create, Modified, Last Execution Date and Code Functions User Defined UDF2019-11-20
SQL Server User Defined Function Example Functions User Defined UDF2019-11-01
SQL Server User Defined Function Overview Functions User Defined UDF2019-10-08
SQL Server Stored Proc Create, Modified, Last Execution Date and Code Stored Procedures2019-10-01
SQL Server Stored Procedure Context Switching and Impersonation Stored Procedures2019-09-20
Save SQL Server Stored Procedure Results to Table Stored Procedures2019-09-02
Create, Alter, Drop and Execute SQL Server Stored Procedures Stored Procedures2019-08-12
SQL Server Hierarchyid Example for Bill of Materials TSQL2019-07-23
SQL Server and Excel Hierarchyid Example for Organization Charts TSQL2019-07-04
SQL Server Hierarchyid Data Type Overview and Examples TSQL2019-06-21
SQL Temp Tables, Table Variables, Subqueries, Derived Tables and more Temp Tables2019-06-12
SQL Server Staging Table vs Temp Table Temp Tables2019-05-23
SQL Server Common Table Expression vs Temp Table Temp Tables2019-05-22
SQL Server Table Variable Example Temp Tables2019-05-20
SQL Server Derived Table Example Temp Tables2019-05-16
SQL Server Uncorrelated and Correlated Subquery Temp Tables2019-05-15
SQL Server Subquery Example Temp Tables2019-05-13
Local vs Global SQL Server Temporary Tables Temp Tables2019-05-09
Types of SQL Server Temporary Tables Temp Tables2019-05-08
One-way and Two-way Tabulation Example in SQL Server – Part 2 TSQL2019-02-26
Contingency Table Analysis via Chi Square using T-SQL: Part 1 TSQL2019-02-04
Data Science Goodness of Fit to Different Distributions with TSQL TSQL2019-01-14
Assess Goodness of Fit to Normal and Uniform Distributions with TSQL TSQL2019-01-02
Using T-SQL to Assess Goodness of Fit to an Exponential Distribution TSQL2018-12-13
T-SQL for Tukey Honestly Significant Difference Test After an ANOVA TSQL2018-11-23
Two-Way Analysis of Variance Test Add-on for SQL Statistics Package TSQL2018-10-29
One-Way Analysis of Variance Test Add-on for SQL Statistics Package TSQL2018-10-03
T-Test Add-on for the SQL Statistics Package TSQL2018-09-25
Data Science for Inferential and Predictive Statistics – Part 2 Data Science2018-09-03
An Overview of Data Science for Stock Price Analysis with SQL: Part 1 TSQL2018-08-22
How to Compare and Combine Artificial Intelligence Models with T-SQL Artificial Intelligence2018-08-03
Calculate Stock Buy and Sell Recommendations with TSQL TSQL2018-07-20
A T-SQL Model for Contrasting Two Different Sets of Measurement TSQL2018-07-05
Using Two Samples to Validate MACD with T-SQL TSQL2018-06-27
T-SQL Starter Statistics Package for SQL Server Functions System2018-06-07
Using T-SQL to Quantify Trend Direction and Strength TSQL2018-05-24
Using T-SQL to Detect Golden Crosses and Death Crosses TSQL2018-05-04
Using T-SQL to Refine an Analytical Model for Picking Stocks TSQL2018-04-05
Using T-SQL to Detect Stock Price Reversals with the RSI TSQL2018-03-19
Analyzing When to Buy and Sell Stocks Using T-SQL in SQL Server TSQL2018-02-28
Mining Stock Price Time Series with MACD in SQL Server TSQL2018-02-06
Mining Time Series with Exponential Moving Averages in SQL Server TSQL2018-01-25
Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server TSQL2017-12-27
Import end of day prices for all NASDAQ stocks into SQL Server Import and Export2017-12-14
Importing Historical Stock Prices from Yahoo Finance into SQL Server Import and Export2017-11-14
Scraping HTML Tables with Python to Populate SQL Server Tables SQL Server 20172017-11-06
Web Screen Scraping with Python to Populate SQL Server Tables SQL Server 20172017-10-20
Import Historical Stock Prices into SQL Server using Python SQL Server 20162017-10-12
Execute Python Scripts with Management Studio to Securely Import Data into SQL Server SQL Server 20162017-09-25
Installing Python and Running Python Scripts from SQL Server SSMS SQL Server 20162017-09-06
SQL Server Agent Job Schedule Reporting SQL Server Agent2017-08-31
Scripting New SQL Server Agent Jobs from Prior Job Scripts SQL Server Agent2017-08-23
Tracking and Counting SQL Server Agent Job Runs SQL Server Agent2017-08-11
Queries to inventory your SQL Server Agent Jobs SQL Server Agent2017-07-21
Creating Multi-Step and Dynamic SQL Server Agent Jobs SQL Server Agent2017-06-26
Getting Started with SQL Server Agent – Part 1 SQL Server Agent2017-06-12
List Dependencies for SQL Server Foreign Keys Constraints2017-03-16
Creating High-Low-Open-Close Candlestick Charts with SSRS Reporting Services Charts2017-01-12
Pass Historical Data for Stocks from Google Finance to SQL Server TSQL2016-10-27
SQL Server Data Mining Strategies for Stock Buy and Sell Recommendations TSQL2016-10-17
Using SQL Server Data Analysis for Stock Trading Strategies TSQL2016-10-04
Creating an SSRS Matrix Sparkline Report with Data from Oracle 11g Reporting Services Development2016-09-15
Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g SQL Server and Oracle Comparison2016-08-26
Transferring Data Between SQL Server 2014 and Oracle 11g Databases SQL Server and Oracle Comparison2016-08-18
Creating a SQL Server 2014 Linked Server for an Oracle 11g Database SQL Server and Oracle Comparison2016-07-29
Query for pair-wise relationships between rows for a SQL Server table TSQL2016-02-23
Converting and Using Text Dates as SQL Server Dates Dates2015-05-26
Using a Simple SQL Server Bulk Insert to View and Validate Data Import and Export2015-01-09
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL Functions System2014-09-16
Name Parsing for Result Sets with Different Name Formats Functions System2014-07-15
Name Parsing with SQL Server Functions and T-SQL Programming Functions System2014-05-22
Masking Personal Identifiable SQL Server Data Encryption2013-11-13
SQL Server 2012 Certification Path Certifications2012-11-26
Using SAS ACCESS and PROC SQL to Save SAS Data in SQL Server Other Database Platforms2012-10-05
Using SAS ACCESS and PROC SQL to Retrieve SQL Server Data Other Database Platforms2012-07-06
Using Wizards to Export a Dataset from SAS to SQL Server Other Database Platforms2012-07-02
Work around for calculating age using the SQL Server DateDiff function Dates2012-05-09
Transferring data from SAS to SQL Server and back Other Database Platforms2012-03-30
Dynamically Name Text Files in SSIS Integration Services Development2011-12-02
Do You Want to be a Certified SQL Server Database Development Expert Certifications2011-07-21
Do You Want to be a Microsoft Certified SQL Server DBA Expert Certifications2011-01-24