Rick Dobson

Rick Dobson is an author and an individual trader. He is also 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 growing his Python skills for more than the past half decade -- especially 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. He believes the proper application of these skills can help traders and investors to make more profitable decisions.

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/.

2023 Awards MSSQLTips award

2022 Awards MSSQLTips award

2021 Awards MSSQLTips award

2020 Awards MSSQLTips award

2019 Awards MSSQLTips award

2018 Awards MSSQLTips award

2017 Awards MSSQLTips award

2016 Awards MSSQLTips award

Category	Tip Title
Artificial Intelligence	Artificial Intelligence Programming with T-SQL for Time Series Data
Artificial Intelligence	Compare Artificial Intelligence Models Built with T-SQL
Artificial Intelligence	Create AI Models with T-SQL to Buy or Sell Financial Securities
Artificial Intelligence	Getting Started with Ensemble AI Models in SQL Server
Artificial Intelligence	Google Gemini - Generative AI Tool for SQL Professionals
Artificial Intelligence	How to Compare and Combine Artificial Intelligence Models with T-SQL
Constraints	List Dependencies for SQL Server Foreign Keys
Data Science	Data Science with SQL Server for Inferential and Predictive Statistics: Part 2
Data Types	Money and Decimal Data Types for Monetary Values with SQL Server
Database Configurations	Setup a Workbench Database, Migrate Objects from Production and Modify the Workbench Database
Dates	Converting and Using Text Dates as SQL Server Dates
Dates	Work around for calculating age using the SQL Server DateDiff function
Encryption	Masking Personal Identifiable SQL Server Data
Functions System	Generate Unique Random Number in SQL Server
Functions System	Name Parsing for Result Sets with Different Name Formats
Functions System	Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL
Functions System	Name Parsing with SQL Server Functions and T-SQL Programming
Functions System	T-SQL Starter Statistics Package for SQL Server
Functions System	Weighted vs Simple Moving Average with SQL Server T-SQL Code
Functions User Defined UDF	Find SQL Server User Defined Function Create, Modified, Last Execution Date and Code
Functions User Defined UDF	SQL Server User Defined Function Example
Functions User Defined UDF	SQL Server User Defined Function Overview
Import and Export	Download and Analyze Stooq Historical Stock Price and Volume Data in SQL Server
Import and Export	Import end of day prices for all NASDAQ stocks into SQL Server
Import and Export	Importing Historical Stock Prices from Yahoo Finance into SQL Server
Import and Export	Using a Simple SQL Server Bulk Insert to View and Validate Data
Integration Services Development	Dynamically Name Text Files in SQL Server Integration Services
Microsoft Excel Integration	Data Visualizations for Excel Multi-Chart Sets with SQL Server Data
Other Database Platforms	Create, Populate, and Subset a Pandas Dataframe from a CSV File
Other Database Platforms	Transferring data from SAS to SQL Server and back
Other Database Platforms	Using SAS ACCESS and PROC SQL to Retrieve SQL Server Data
Other Database Platforms	Using SAS ACCESS and PROC SQL to Save SAS Data in SQL Server
Other Database Platforms	Using Wizards to Export a Dataset from SAS to SQL Server
Performance Tuning	Capture Duration Metrics for SQL Server Query Tuning
Performance Tuning	Set Statistics Time Examples for Tuning SQL Server Queries
Professional Development Certifications	Do You Want to be a Certified SQL Server Database Development Expert
Professional Development Certifications	Do You Want to be a Microsoft Certified SQL Server DBA Expert
Professional Development Certifications	SQL Server 2012 Certification Path
Professional Development Certifications	Study material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012
Professional Development Certifications	Study material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 - Part 2
Python	An Introduction to Assessing Normal Distribution with Python
Python	Assessing if Dataset Values are Lognormal Distributed with Python
Python	Build Pie Charts with Python for Displaying Counts from SQL Server Data
Python	Create Performance Charts in Python for Time Series Data within SQL Server
Python	Creating Animated Line Plots with Python
Python	Data Engineering a Solution with Python and SQL Server
Python	Displaying Subplots for SQL Server Data with Python and Matplotlib
Python	Displaying Subplots for SQL Server Data with Python and Plotly
Python	How to use Python and BeautifulSoup to Screen Scrape a Web Page and Store in SQL Server
Python	Import Unstructured Web Content to SQL Server with BeautifulSoup, Python and T-SQL
Python	Introducing Python User Defined Functions to SQL Server Professionals
Python	Introduction to Python Bar Charts and Line Charts
Python	Introduction to Treemap Charts for SQL Server Professionals
Python	Plotting in Python for Financial Time Series Data for Exponential Moving Averages
Python	Reading and Writing JSON Files with Python
Python	Remote Data Access with JSON and Python Rest API
Python	Screen Scraping with Python and BeautifulSoup Code Examples
Python	Techniques for Collecting Stock Data with Python
Query Optimization	Query Tuning in SQL Server with Set Statistics IO
Reporting Services Charts	Creating High-Low-Open-Close Candlestick Charts with SQL Server Reporting Services
Reporting Services Development	Creating an SQL Server Reporting Services Matrix Sparkline Report with Data from Oracle 11g
Security	Get Started with SQL Server xp_cmdshell
SQL Server 2016	Execute Python Scripts with Management Studio to Securely Import Data into SQL Server
SQL Server 2016	Import Historical Stock Prices into SQL Server using Python
SQL Server 2016	Installing Python and Running Python Scripts from SQL Server SSMS
SQL Server 2017	Scraping HTML Tables with Python to Populate SQL Server Tables
SQL Server 2017	Web Screen Scraping with Python to Populate SQL Server Tables
SQL Server Agent	Creating Multi-Step and Dynamic SQL Server Agent Jobs
SQL Server Agent	Getting Started with SQL Server Agent - Part 1
SQL Server Agent	Queries to inventory your SQL Server Agent Jobs
SQL Server Agent	Scripting New SQL Server Agent Jobs from Prior Job Scripts
SQL Server Agent	SQL Server Agent Job Schedule Reporting
SQL Server Agent	Tracking and Counting SQL Server Agent Job Runs
SQL Server and Oracle Comparison	Creating a SQL Server 2014 Linked Server for an Oracle 11g Database
SQL Server and Oracle Comparison	Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g
SQL Server and Oracle Comparison	Transferring Data Between SQL Server 2014 and Oracle 11g Databases
Stored Procedures	Create, Alter, Drop and Execute SQL Server Stored Procedures
Stored Procedures	Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code
Stored Procedures	Save SQL Server Stored Procedure Results to Table
Stored Procedures	SQL Server Stored Procedure Context Switching and Impersonation Example
Stored Procedures	SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value
Temp Tables	Differences Between SQL Server Temp Tables, Table Variables, Subqueries, Derived Tables, CTEs and Physical Tables
Temp Tables	Local vs Global SQL Server Temporary Tables
Temp Tables	SQL Server Common Table Expression vs Temp Table
Temp Tables	SQL Server Derived Table Example
Temp Tables	SQL Server Staging Table vs Temp Table
Temp Tables	SQL Server Subquery Example
Temp Tables	SQL Server Table Variable Example
Temp Tables	SQL Server Uncorrelated and Correlated Subquery
Temp Tables	Types of SQL Server Temporary Tables
TSQL	A Framework for Comparing Time Series Data from Yahoo Finance and Stooq.com
TSQL	A One-Way Analysis of Variance Test Add-on for the SQL Statistics Package
TSQL	A SQL Server Data Mining Example to Compare Leveraged Inverse ETFs
TSQL	A T-SQL Model for Contrasting Two Different Sets of Measurement
TSQL	A Two-Way Analysis of Variance Test Add-on for the SQL Statistics Package
TSQL	Adding a Buy-Sell Model to a Buy-and-Hold Model with T-SQL
TSQL	An Overview of Data Science for Stock Price Analysis with SQL: Part 1
TSQL	Analyze Historical Weather Data with SQL Server
TSQL	Analyze Relationship Between Two Time Series in SQL Server
TSQL	Analyzing When to Buy and Sell Stocks Using T-SQL in SQL Server
TSQL	Assessing Time Series Model Performance with T-SQL
TSQL	Assessing with SQL and Data Science Goodness of Fit to Different Distributions
TSQL	Building a SQL Computational Framework for MACD Indicators
TSQL	Calculate Modes in T-SQL with SQL Server Data
TSQL	Candlestick and Heikin Ashi Charts from Yahoo Finance and Stooq.com
TSQL	Chi-Square Test for Homogeneity in SQL Server
TSQL	Collecting Time Series Data for Stock Market with SQL Server
TSQL	Collecting, Storing, and Displaying Geographical Coordinates in SQL Server
TSQL	Comparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression
TSQL	Compute and Display Candlestick Charts in SQL Server and Python
TSQL	Compute and Display Heikin Ashi Charts in SQL Server and Excel
TSQL	Compute Statistics using T-SQL for Arithmetic Mean, Geometric Mean and Median
TSQL	Compute the Relative Strength Index for Time Series within SQL Server
TSQL	Contingency Table Analysis via Chi Square using T-SQL: Part 1
TSQL	Correlating Stock Index Performance to Economic Indicators with SQL and Excel
TSQL	Create and Compare SQL Time Series Models
TSQL	Create, Populate, and Transform Geographic Coordinates in SQL Server Tables
TSQL	Differences Between Exponential Moving Average and Simple Moving Average in SQL Server
TSQL	Exponential Moving Average Calculation in SQL Server
TSQL	How to Build a Data Science Time Series Model with SQL Server
TSQL	How to Comparatively Assess Buy-Sell Models with SQL Server
TSQL	How to Compute Simple Moving Averages with Time Series Data in SQL Server
TSQL	Implement K Nearest Neighbor Solution with T-SQL
TSQL	Load Time Series Data with SQL Server
TSQL	Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON
TSQL	Migrating Time Series Data to SQL Server from Yahoo Finance and Stooq.com
TSQL	Mining Stock Price Time Series with MACD in SQL Server
TSQL	Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server
TSQL	Mining Time Series with Exponential Moving Averages in SQL Server
TSQL	Model and Log Trend Reversals for Time Series Data in SQL Server
TSQL	Multiple Regression Model Enhanced with Bagging
TSQL	One-way and Two-way Tabulation Example in SQL Server - Part 2
TSQL	Opening JSON Data with T-SQL
TSQL	Overview of How to Collect Securities Prices for SQL Server
TSQL	Pass Historical Data for Stocks from Google Finance to SQL Server
TSQL	Performance Score Models for Decisions about Time Series with SQL and Excel
TSQL	Performing a Sign Test with T-SQL
TSQL	Performing a Wilcoxon Signed Rank Test in SQL Server
TSQL	Query for pair-wise relationships between rows for a SQL Server table
TSQL	Query SQL Server system data about tables and columns
TSQL	Revisiting Time Series Model Performance Assessment with T-SQL
TSQL	Rounding Numbers to the Nearest Integer with T-SQL
TSQL	Rounding to the Nearest Penny in SQL Server with T-SQL
TSQL	Scripts to Automate Creating and Loading a SQL Server Table
TSQL	SQL Server and Excel Hierarchyid Example for Organization Charts
TSQL	SQL Server Code Samples for Sys.objects and Related Functions
TSQL	SQL Server Data Mining for Leveraged Versus Unleveraged ETFs as a Long-Term Investment
TSQL	SQL Server Data Mining Strategies for Stock Buy and Sell Recommendations
TSQL	SQL Server Function Examples with JSON Files
TSQL	SQL Server Hierarchyid Data Type Overview and Examples
TSQL	SQL Server Hierarchyid Example for Bill of Materials
TSQL	SQL Server T-SQL Code for the Tukey Honestly Significant Difference Test After an ANOVA
TSQL	SQL WHILE Loop for Processing Time Series Data
TSQL	Starter Metadata T-SQL Query Examples for Databases and Tables
TSQL	String to Numeric Geographic Coordinates in SQL Server with T-SQL
TSQL	T-SQL Code for Decision Tree Regression Algorithm - Part 3
TSQL	T-SQL Code for Multi-Level Decision Tree - Part 2
TSQL	T-SQL Code for the Decision Tree Algorithm - Part 1
TSQL	T-SQL to Calculate Buy and Sell Stock Recommendations via Three Technical Indicators
TSQL	T-Test Add-on for the SQL Statistics Package
TSQL	Three Use Case Examples for SQL Subqueries
TSQL	Time Series Data Fact and Dimension Tables for SQL Server
TSQL	Time Series Data Mining Example with T-SQL when Adding New Data
TSQL	Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
TSQL	Use MACD to Predict When to Buy and Sell Securities with T-SQL
TSQL	Use T-SQL to Perform Statistical Calculations on SQL Server Data
TSQL	Using Candlestick Chart Values for a Decision Making Model in SQL Server
TSQL	Using SQL Server Data Analysis for Stock Trading Strategies
TSQL	Using SQL to Assess Goodness of Fit to Normal and Uniform Distributions
TSQL	Using T-SQL and the RSI to Predict When to Buy and Sell Financial Securities
TSQL	Using T-SQL for Investing and Trading Financial Securities
TSQL	Using T-SQL to Assess Goodness of Fit to an Exponential Distribution
TSQL	Using T-SQL to Detect Golden Crosses and Death Crosses
TSQL	Using T-SQL to Detect Stock Price Reversals with the RSI
TSQL	Using T-SQL to Quantify Trend Direction and Strength
TSQL	Using T-SQL to Refine an Analytical Model for Picking Stocks
TSQL	Using Two Samples to Validate MACD with T-SQL
TSQL	Visually Tracking Buy-Sell Time Series Models with SQL Server and Excel
TSQL	Weather Data Warehouse in SQL Server - Create and Populate
TSQL	Weather Data Warehouse in SQL Server - Gather Information
TSQL	Weather Station Tracking with SQL Server and Excel
Views	Create, Alter, Drop and Query SQL Server Views
Views	Insert and Delete SQL Server Data with Views
Views	Track and Monitor SQL Server View Usage

No Records Found

CategoryGroup	Category (articles)
Analysis Services	Analysis Services Administration (33)
Analysis Services	Analysis Services Development (95)
Analysis Services	Analysis Services Dimensions (16)
Analysis Services	Analysis Services Measure Groups (7)
Analysis Services	Analysis Services Performance (14)
Analysis Services	Analysis Services Security (7)
Analysis Services	Analysis Services Tutorials (6)
Business Intelligence	Artificial Intelligence (23)
Business Intelligence	Big Data (25)
Business Intelligence	Data Science (3)
Business Intelligence	Data Warehousing (7)
Business Intelligence	Import and Export (81)
Business Intelligence	R Language (11)
Business Intelligence	Snowflake (29)
Cloud	Amazon AWS (38)
Cloud	Amazon AWS RDS (21)
Cloud	Azure (149)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Functions (7)
Cloud	Azure SQL Database (51)
Cloud	Azure SQL Managed Instance (5)
Cloud	Cloud Strategy (25)
Cloud	Google Cloud (10)
Cloud Analytics	Apache Spark (13)
Cloud Analytics	Azure Data Factory (73)
Cloud Analytics	Azure Databricks (39)
Cloud Analytics	Azure Integration Services (14)
Cloud Analytics	Azure Synapse Analytics (42)
Cloud Analytics	Microsoft Fabric (18)
Data Quality	Data Cleansing for Validation (4)
Data Quality	Data Quality Services (10)
Data Quality	Master Data Services (41)
Database Administration	Central Management Servers (10)
Database Administration	Comparison Data and Objects (14)
Database Administration	Database Administration (208)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Scripts (35)
Database Administration	System Databases (31)
Database Configuration	Compression (22)
Database Configuration	Database Configurations (19)
Database Configuration	Database Mail (18)
Database Configuration	FILESTREAM (9)
Database Configuration	Full Text Search (21)
Database Configuration	In Memory OLTP (32)
Database Configuration	Linked Servers (18)
Database Configuration	Policy Based Management (29)
Database Configuration	Recovery Models (4)
Database Configuration	Resource Governor (5)
Database Configuration	SQL Server Configurations (75)
Database Design	Constraints (20)
Database Design	Data Types (22)
Database Design	Database Design (92)
Database Design	Identities (17)
Database Design	JOIN Tables (23)
Database Design	Synonyms (5)
Database Design	Table Valued Parameters (4)
Database Design	Temp Tables (15)
Database Design	Temporal Tables (13)
Database Design	User Defined Type UDT (3)
Database Design	Views (17)
Database Development	Application Development (46)
Database Development	Common Runtime Language (13)
Database Development	Debugging (4)
Database Development	DevOps (36)
Database Development	Entity Framework (13)
Database Development	Language Integrated Query LINQ (7)
Database Development	Paging (5)
Database Development	Referential Integrity (5)
Database Development	Service Broker (11)
Database Development	Testing (32)
Database Development	XML (14)
Database Maintenance	Database Console Commands DBCCs (25)
Database Maintenance	Fragmentation and Index Maintenance (28)
Database Maintenance	Maintenance (34)
Disaster Recovery / High Availability	Availability Groups (80)
Disaster Recovery / High Availability	Backup (81)
Disaster Recovery / High Availability	Clustering (77)
Disaster Recovery / High Availability	Database Mirroring (33)
Disaster Recovery / High Availability	Disaster Recovery (23)
Disaster Recovery / High Availability	High Availability (3)
Disaster Recovery / High Availability	Log Shipping (18)
Disaster Recovery / High Availability	Replication (78)
Disaster Recovery / High Availability	Restore (42)
Functions	Dates (56)
Functions	Functions System (99)
Functions	Functions User Defined UDF (41)
Infrastructure	Contained Databases (4)
Infrastructure	Containers (12)
Infrastructure	Hardware (14)
Infrastructure	Spatial Data Storage (9)
Infrastructure	Virtualization (25)
Integration Services Admin	Integration Services Administration (10)
Integration Services Admin	Integration Services Best Practices (12)
Integration Services Admin	Integration Services Configuration Options (22)
Integration Services Admin	Integration Services Performance (12)
Integration Services Admin	Integration Services Security (7)
Integration Services Admin	Integration Services Upgrade (4)
Integration Services Development	Data Transformation Services (6)
Integration Services Development	Integration Services Analysis Services Tasks (5)
Integration Services Development	Integration Services Connection Managers (5)
Integration Services Development	Integration Services Control Flow Transformations (14)
Integration Services Development	Integration Services Data Flow Transformations (19)
Integration Services Development	Integration Services Development (116)
Integration Services Development	Integration Services Error Handling (8)
Integration Services Development	Integration Services Excel (14)
Integration Services Development	Integration Services Execute Package Options (8)
Integration Services Development	Integration Services Oracle (4)
Microsoft Office	Microsoft Access Integration (8)
Microsoft Office	Microsoft Excel Integration (45)
Microsoft Office	Microsoft Flow (1)
Other RDBMS	Other Database Platforms (16)
Other RDBMS	PostgreSQL (11)
Other RDBMS	SQL Server and Oracle Comparison (29)
Other RDBMS	SQL Server on Linux (78)
Other RDBMS	SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance	Dynamic Management Views and Functions (34)
Performance	Error Logs (11)
Performance	Extended Events (22)
Performance	Indexing (94)
Performance	Locking and Blocking (43)
Performance	Monitoring (110)
Performance	Partitioning (17)
Performance	Performance Data Warehouse (4)
Performance	Performance Tuning (124)
Performance	Profiler and Trace (20)
Performance	Query Optimization (15)
Performance	Query Plans (20)
Performance	Query Store (7)
Power Platform	Power Apps (20)
Power Platform	Power BI (172)
Power Platform	Power BI Charts (57)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (20)
Professional Development	Professional Development Certifications (62)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Interview Questions BI (18)
Professional Development	Professional Development Interview Questions DBA (23)
Professional Development	Professional Development Interview Questions Developer (9)
Professional Development	Professional Development Interviewing (39)
Professional Development	Professional Development Job Search (24)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Python	Python (89)
Reporting Services Admin	Reporting Services Administration (21)
Reporting Services Admin	Reporting Services Best Practices (6)
Reporting Services Admin	Reporting Services Configuration (10)
Reporting Services Admin	Reporting Services Installation (10)
Reporting Services Admin	Reporting Services Migration (5)
Reporting Services Admin	Reporting Services Monitoring (5)
Reporting Services Admin	Reporting Services Network Load Balancing (4)
Reporting Services Admin	Reporting Services Performance (6)
Reporting Services Admin	Reporting Services Security (8)
Reporting Services Development	Reporting Services Analysis Services (4)
Reporting Services Development	Reporting Services Charts (25)
Reporting Services Development	Reporting Services Data Sources (10)
Reporting Services Development	Reporting Services Development (67)
Reporting Services Development	Reporting Services Dynamic Reports (11)
Reporting Services Development	Reporting Services Formatting (26)
Reporting Services Development	Reporting Services KPI (5)
Reporting Services Development	Reporting Services Overview (5)
Reporting Services Development	Reporting Services Parameters (15)
Reporting Services Development	Reporting Services Report Builder (9)
Security	Auditing and Compliance (47)
Security	Encryption (35)
Security	Security (199)
Security	SQL Injection (5)
Security	Surface Area Configuration Manager (4)
SharePoint	SharePoint (131)
SharePoint	SharePoint Administration (46)
SharePoint	SharePoint Configuration (27)
SharePoint	Sharepoint Design (46)
SharePoint	SharePoint Document Management (20)
SQL Coding	Change Data Capture (16)
SQL Coding	Common Table Expressions (4)
SQL Coding	Dynamic SQL (7)
SQL Coding	Error Handling (11)
SQL Coding	Stored Procedures (30)
SQL Coding	Transactions (9)
SQL Coding	Triggers (44)
SQL Coding	TSQL (342)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (95)
Tools	SQL Server Management Objects SMO (3)
Tools	SQL Server Management Studio (78)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (35)
Versions	Deprecated Features (6)
Versions	Express Edition (16)
Versions	Install and Uninstall (33)
Versions	Licensing (4)
Versions	SQL Server 2016 (96)
Versions	SQL Server 2017 (44)
Versions	SQL Server 2019 (20)
Versions	SQL Server 2022 (21)
Versions	Upgrades and Migrations (55)