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

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
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
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 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	Creating a SQL Server 2014 Linked Server for an Oracle 11g Database
Other Database Platforms	Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g
Other Database Platforms	Transferring Data Between SQL Server 2014 and Oracle 11g Databases
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	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	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	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
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 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	Artificial Intelligence Programming with T-SQL for Time Series Data
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	Candlestick and Heikin Ashi Charts from Yahoo Finance and Stooq.com
TSQL	Collecting Time Series Data for Stock Market with SQL Server
TSQL	Collecting, Storing, and Displaying Geographical Coordinates in SQL Server
TSQL	Compare Artificial Intelligence Models Built with T-SQL
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 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 Compare and Combine Artificial Intelligence Models with T-SQL
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	Revisiting Time Series Model Performance Assessment 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 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	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	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	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 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
TSQL	Weighted vs Simple Moving Average with SQL Server T-SQL Code
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 (31)
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 Tools (1)
Analysis Services	Analysis Services Tutorials (6)
Analysis Services	Cortana (5)
Analysis Services	Performance Point (4)
Business Intelligence	Big Data (25)
Business Intelligence	Data Warehousing (4)
Cloud	Amazon AWS (51)
Cloud	Apache Spark (8)
Cloud	Azure (146)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (13)
Cloud	Azure Data Factory (69)
Cloud	Azure Databricks (25)
Cloud	Azure Integration Services (14)
Cloud	Azure SQL Database (45)
Cloud	Azure SQL Managed Instance (2)
Cloud	Azure Synapse Analytics (38)
Cloud	Cloud Strategy (19)
Data Quality	Data Quality Services (9)
Data Quality	Master Data Services (41)
Database Administration	Amazon AWS RDS (1)
Database Administration	Availability Groups (78)
Database Administration	Backup (78)
Database Administration	Central Management Servers (9)
Database Administration	Clustering (74)
Database Administration	Comparison Data and Objects (14)
Database Administration	Compression (22)
Database Administration	Contained Databases (4)
Database Administration	Containers (12)
Database Administration	Database Administration (196)
Database Administration	Database Configurations (18)
Database Administration	Database Console Commands DBCCs (25)
Database Administration	Database Mail (18)
Database Administration	Database Mirroring (33)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Deprecated Features (5)
Database Administration	DevOps (34)
Database Administration	Disaster Recovery (23)
Database Administration	Error Logs (11)
Database Administration	Express Edition (16)
Database Administration	Extended Events (22)
Database Administration	FILESTREAM (9)
Database Administration	Fragmentation and Index Maintenance (27)
Database Administration	Google Cloud (3)
Database Administration	Hardware (14)
Database Administration	High Availability (3)
Database Administration	Indexing (87)
Database Administration	Install and Uninstall (32)
Database Administration	Licensing (4)
Database Administration	Linked Servers (18)
Database Administration	Locking and Blocking (39)
Database Administration	Log Shipping (18)
Database Administration	Maintenance (34)
Database Administration	Monitoring (116)
Database Administration	Other Database Platforms (86)
Database Administration	Partitioning (17)
Database Administration	Performance Data Warehouse (4)
Database Administration	Performance Tuning (123)
Database Administration	Policy Based Management (29)
Database Administration	PowerShell (130)
Database Administration	Profiler and Trace (20)
Database Administration	Query Store (7)
Database Administration	Recovery Models (4)
Database Administration	Replication (75)
Database Administration	Resource Governor (5)
Database Administration	Restore (42)
Database Administration	SQL Server 2016 (100)
Database Administration	SQL Server 2017 (44)
Database Administration	SQL Server 2019 (20)
Database Administration	SQL Server 2022 (19)
Database Administration	SQL Server Configurations (75)
Database Administration	SQL Server on Linux (76)
Database Administration	StreamInsight (2)
Database Administration	System Databases (31)
Database Administration	Upgrades and Migrations (54)
Database Administration	Virtualization (25)
Database Administration	Windows Internal Database (1)
Database Development	Application Development (39)
Database Development	Azure Functions (7)
Database Development	Change Data Capture (15)
Database Development	Common Runtime Language (13)
Database Development	Common Table Expressions (3)
Database Development	Constraints (21)
Database Development	Data Cleansing for Validation (2)
Database Development	Data Science (3)
Database Development	Data Types (18)
Database Development	Database Design (76)
Database Development	Dates (53)
Database Development	Debugging (4)
Database Development	Dynamic Management Views and Functions (33)
Database Development	Dynamic SQL (7)
Database Development	Entity Framework (13)
Database Development	Error Handling (10)
Database Development	Full Text Search (21)
Database Development	Functions System (71)
Database Development	Functions User Defined UDF (41)
Database Development	Identities (17)
Database Development	Import and Export (77)
Database Development	In Memory OLTP (32)
Database Development	JOIN Tables (21)
Database Development	Language Integrated Query LINQ (7)
Database Development	Microsoft Access Integration (8)
Database Development	Microsoft Excel Integration (40)
Database Development	Microsoft Flow (1)
Database Development	Paging (5)
Database Development	Python (65)
Database Development	Query Optimization (14)
Database Development	Query Plans (20)
Database Development	R Language (11)
Database Development	Scripts (35)
Database Development	Service Broker (11)
Database Development	Spatial Data Storage (9)
Database Development	SQL Injection (5)
Database Development	SQL Server Management Objects SMO (3)
Database Development	Stored Procedures (29)
Database Development	Synonyms (5)
Database Development	Table Valued Parameters (4)
Database Development	Temp Tables (10)
Database Development	Temporal Tables (13)
Database Development	Testing (31)
Database Development	Transactions (9)
Database Development	Triggers (45)
Database Development	TSQL (350)
Database Development	User Defined Type UDT (3)
Database Development	Views (15)
Database Development	XML (14)
Integration Services	Data Transformation Services (5)
Integration Services	Integration Services Administration (10)
Integration Services	Integration Services Analysis Services Tasks (5)
Integration Services	Integration Services Best Practices (12)
Integration Services	Integration Services Configuration Options (22)
Integration Services	Integration Services Connection Managers (5)
Integration Services	Integration Services Control Flow Transformations (14)
Integration Services	Integration Services Data Flow Transformations (19)
Integration Services	Integration Services Development (110)
Integration Services	Integration Services Email (3)
Integration Services	Integration Services Error Handling (8)
Integration Services	Integration Services Excel (14)
Integration Services	Integration Services Execute Package Options (8)
Integration Services	Integration Services Import and Export Wizard (2)
Integration Services	Integration Services NULL Management (4)
Integration Services	Integration Services Oracle (4)
Integration Services	Integration Services Performance (12)
Integration Services	Integration Services Security (7)
Integration Services	Integration Services Upgrade (4)
Power Platform	Power Apps (19)
Power Platform	Power BI (144)
Power Platform	Power BI Charts (50)
Power Platform	Power BI Formatting (15)
Professional Development	Professional Development Books (3)
Professional Development	Professional Development Branding (14)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (16)
Professional Development	Professional Development Career Transition (4)
Professional Development	Professional Development Certifications (49)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Conferences (2)
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 (38)
Professional Development	Professional Development Job Search (17)
Professional Development	Professional Development Management (10)
Professional Development	Professional Development Recruiters (6)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Reporting Services	Reporting Services Administration (19)
Reporting Services	Reporting Services Analysis Services (4)
Reporting Services	Reporting Services Best Practices (6)
Reporting Services	Reporting Services Charts (25)
Reporting Services	Reporting Services Configuration (10)
Reporting Services	Reporting Services Custom Report (2)
Reporting Services	Reporting Services Dashboard (1)
Reporting Services	Reporting Services Data Sources (10)
Reporting Services	Reporting Services Development (38)
Reporting Services	Reporting Services Drill Through (4)
Reporting Services	Reporting Services Dynamic Reports (11)
Reporting Services	Reporting Services Filtering (3)
Reporting Services	Reporting Services Formatting (26)
Reporting Services	Reporting Services Functions (5)
Reporting Services	Reporting Services Images (2)
Reporting Services	Reporting Services Installation (9)
Reporting Services	Reporting Services KPI (5)
Reporting Services	Reporting Services Maps (4)
Reporting Services	Reporting Services Migration (5)
Reporting Services	Reporting Services Monitoring (5)
Reporting Services	Reporting Services Network Load Balancing (4)
Reporting Services	Reporting Services Overview (5)
Reporting Services	Reporting Services Parameters (15)
Reporting Services	Reporting Services Performance (6)
Reporting Services	Reporting Services Report Builder (9)
Reporting Services	Reporting Services Report Models (1)
Reporting Services	Reporting Services Security (8)
Reporting Services	Reporting Services SharePoint (1)
Reporting Services	Reporting Services Subreports (4)
Reporting Services	Reporting Services Tutorials (1)
Security	Auditing and Compliance (45)
Security	Encryption (32)
Security	Security (197)
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)
Tools	Azure Data Studio (17)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (93)
Tools	SQL Server Management Studio (77)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (9)
Tools	Tools (33)