Get Free Tips
MSSQLTips.com

Author: Rick Dobson

Home » Archives for 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

TitleCategoryDate
T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell ScriptImport and Export2025-09-16
SQL Generate Date Examples with Recursive CTE and Stored ProcedureCommon Table Expressions2025-08-29
SQL CTE Examples for Time Series AnalysisCommon Table Expressions2025-08-25
SQL Rand Function to Perform Monte Carlo SimulationTSQL2025-07-22
Rand() and Newid() for SQL Random NumbersTSQL2025-06-11
Automated Backtesting with SQL Server and Microsoft CopilotTSQL2025-05-23
Evaluating the Randomness of SQL Server Random Number FunctionsFunctions System2025-04-24
Digitally Signing a SQL Stored ProcedureStored Procedures2025-03-14
SQL ROUND – Rounding versus TruncatingTSQL2025-02-12
Compare SQL Round to Bankers Rounding for Millions of Decimal ValuesTSQL2024-12-24
SQL Server Column Encryption and Decryption​ with Code ExamplesEncryption2024-12-18
GUID in SQL Server​Database Design2024-11-22
SQL Server Metadata for Stored Procedures, Functions and ViewsDatabase Administration2024-09-27
SQL Metadata in sys.databases, sys.objects, sys.tables and sys.columnsDatabase Administration2024-08-28
SQL ROUND Function vs. Bankers Rounding with T-SQLTSQL2024-07-29
Windows Copilot vs. Google Gemini to Build SQL QueriesArtificial Intelligence2024-06-25
Generating Uniform, Normal, or Lognormal Random Numbers in SQL ServerTSQL2024-05-31
SQL Bulk Insert Command ExamplesImport and Export2024-05-10
Google Gemini AI Tool to Build and Explain T-SQL CodeArtificial Intelligence2024-04-15
Calculate Modes in T-SQL with SQL Server DataTSQL2024-03-20
Assessing if Dataset Values are Lognormal Distributed with PythonPython2024-02-13
SQL Server Data Mining Example to Compare Leveraged Inverse ETFsTSQL2023-12-22
Query SQL Server sys.objects for Database Objects InformationTSQL2023-12-20
BeautifulSoup, Python and T-SQL to Import Unstructured Web ContentPython2023-11-20
Time Series Data Mining Example with T-SQL when Adding New DataTSQL2023-11-09
Scrape Web Page and Store in SQL Server with Python and BeautifulSoupPython2023-10-30
SQL Server Rounding to the Nearest Penny with T-SQLTSQL2023-10-10
SQL WHILE Loop to Process Time Series DataTSQL2023-09-25
SQL Rounding Functions with ROUND, CEILING, FLOOR, Bankers RoundingTSQL2023-09-20
Create AI Models with T-SQL for Stock Purchases and SalesArtificial Intelligence2023-08-31
Perform Statistical Calculations on SQL Server DataTSQL2023-08-10
Compare Alternative Plans for Investing in Financial SecuritiesTSQL2023-07-25
Screen Scraping with Python and BeautifulSoupPython2023-07-14
SQL Server metadata sys.tables, sys.columns, sys.all_columns and moreTSQL2023-06-20
SQL Metadata Queries for sys.databases and sys.tablesTSQL2023-06-06
T-SQL Calculations for Arithmetic Mean, Geometric Mean and MedianTSQL2023-05-24
Custom Chi-Square Test for Homogeneity with SQL Server DataTSQL2023-05-09
Ensemble AI Models in SQL ServerArtificial Intelligence2023-04-25
SQL Server Workbench Database Setup, Object Migration, ModificationsDatabase Configurations2023-04-05
SQL Subquery Use CasesTSQL2023-03-22
Buy-Sell Model for Financial Securities with SQL Server and T-SQL CodeTSQL2023-03-10
Animated Line Plots with Python ExamplesPython2023-02-13
Python Normal Distribution ExamplePython2023-02-01
Use SQL Server to Compare Leveraged versus Unleveraged ETFsTSQL2023-01-19
Process JSON files with SQL ServerTSQL2023-01-12
Calculate MACD indicators using T-SQL Code and Data in SQL ServerTSQL2022-12-15
Correlate Gross Domestic Product (GDP) with Business IndicatorsTSQL2022-12-09
Request and Process Data from a Restful API using Python and JSONAPI2022-11-17
Write and Read JSON Files with PythonPython2022-11-04
SQL Money Data Type vs. SQL Decimal for Monetary Values in SQL ServerData Types2022-10-21
Time Series Data Models in SQL Server and Excel to Visualize DataTSQL2022-10-07
Compare Buy-Sell Models for Securities in SQL ServerTSQL2022-09-23
Framework for Data Science Time Series Model Building in SQL ServerTSQL2022-09-08
Excel Line Charts and Scatter Charts with SQL Server DataMicrosoft Excel Integration2022-08-23
Create Subplots for Line and Candlestick Charts with Python and PlotlyPython2022-08-05
Subplots Visualization for SQL Server Data with Python and MatplotlibPython2022-07-21
Python User Defined Functions for SQL Server ProfessionalsPython2022-07-11
Options for Collecting Securities Prices and Load into SQL ServerTSQL2022-06-27
Relative Strength Index Predictions with SQL CodeTSQL2022-06-17
Calculate Candlestick Chart Values to Buy and Sell Financial SecurityTSQL2022-05-27
Candlestick Charts for Time Series Data in SQL Server and PythonTSQL2022-05-24
Build Heikin Ashi Charts in Excel based on Financial Time Series DataTSQL2022-04-29
T-SQL to Build Models that Specify when to Buy or Sell a StockTSQL2022-04-27
Compare Time Series Datasets with T-SQL CodeTSQL2022-03-30
Create Candlestick and Heikin Ashi Charts for Time Series DataTSQL2022-03-10
SQL Stored Procedure with Parameters and Return ValuesStored Procedures2022-02-24
Migrate Time Series Data to SQL Server from Yahoo Finance Stooq.comTSQL2022-02-24
Learn WHILE and GOTO Loops with T-SQL for Time Series DataTSQL2022-02-17
Artificial Intelligence Models to Buy and Sell Financial SecuritiesTSQL2022-02-02
Time Series Data in SQL Server to Model and Log TrendsTSQL2022-01-21
MACD Indicator with SQL Code to Buy and Sell SecuritiesTSQL2022-01-19
Relative Strength Index using Time Series Data in SQL ServerTSQL2021-12-14
Treemap Charts for SQL ServerPython2021-12-03
Model Decisions for Time Series Values based on Performance ScoresTSQL2021-11-29
Performance Charts for Time Series Data with SQL Server and PythonPython2021-11-10
Pie Charts in Python from SQL Server DataPython2021-10-20
Learn xp_cmdshell in SQL ServerSecurity2021-10-13
Time Series Analysis in SQL Creation and ComparisonTSQL2021-10-07
Stooq Historical Stock Price and Volume Data SQL Server DownloadImport and Export2021-09-02
Plotting in Python Financial Time Series from SQL ServerPython2021-08-30
Create, Populate, and Subset a Pandas Dataframe from a CSV FileOther Database Platforms2021-08-16
Data Engineering a Solution with Python and SQL ServerPython2021-07-27
Exponential Moving Average vs. Simple Moving Average in SQL ServerTSQL2021-07-12
Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSONTSQL2021-06-22
SQL JSON Examples for Formatted Data and Data TransferTSQL2021-06-07
Wilcoxon Signed Rank Test in SQL ServerTSQL2021-05-26
Sign Test with T-SQLTSQL2021-05-11
Python Bar Charts and Line Charts ExamplesPython2021-04-26
Techniques for Collecting Stock Data with PythonPython2021-04-20
Create, Populate, and Transform Geographic Coordinates in SQL ServerTSQL2021-04-06
String to Numeric Geographic Coordinates in SQL Server with T-SQLTSQL2021-03-30
Scripts to Automate Creating and Loading a SQL Server TableTSQL2021-03-03
Geographic Coordinates in SQL ServerTSQL2021-02-22
Decision Tree Regression vs Bagging Regression with T-SQL and ExcelTSQL2021-02-05
Multiple Regression Model Enhanced with BaggingTSQL2021-01-08
T-SQL Decision Tree Regression AlgorithmTSQL2020-12-08
T-SQL Code for Multi-Level Decision TreeTSQL2020-11-23
Decision Tree Algorithm with Gini Index in TSQLTSQL2020-10-27
K Nearest Neighbor TSQL SQL Server ExampleTSQL2020-10-14
Weather Data Warehouse in SQL Server – Create and PopulateTSQL2020-09-16
Weather Data Warehouse in SQL Server – Gather InformationTSQL2020-09-01
Weather Station Tracking with SQL Server and ExcelTSQL2020-08-13
Analyze Historical Weather Data with SQL ServerTSQL2020-08-06
Compare Artificial Intelligence Models Built with T-SQLArtificial Intelligence2020-07-30
Artificial Intelligence Programming with T-SQL for Time Series DataArtificial Intelligence2020-07-09
Analyze Relationship Between Two Time Series in SQL ServerTSQL2020-06-25
Exponential Moving Average Calculation in SQL ServerTSQL2020-06-16
Query Tuning in SQL Server with Set Statistics IOQuery Optimization2020-05-25
Capture Duration Metrics for SQL Server Query TuningPerformance Tuning2020-05-21
Set Statistics Time Examples for Tuning SQL Server QueriesPerformance Tuning2020-04-29
Generate Unique Random Number in SQL ServerFunctions System2020-04-01
Weighted vs Simple Moving Average with SQL Server T-SQL CodeFunctions System2020-03-16
How to Compute Simple Moving Averages with Time Series Data in SQL ServerTSQL2020-03-03
Time Series Data Fact and Dimension Tables for SQL ServerTSQL2020-02-14
Collecting Time Series Data for Stock Market with SQL ServerTSQL2020-02-10
Load Time Series Data with SQL ServerTSQL2020-01-24
Insert and Delete SQL Server Data with ViewsViews2020-01-02
Create, Alter, Drop and Query SQL Server ViewsViews2019-12-12
Track and Monitor SQL Server View UsageViews2019-12-04
Get SQL Server UDF Create, Modified, Last Execution Date and CodeFunctions User Defined UDF2019-11-20
SQL Server User Defined Function ExampleFunctions User Defined UDF2019-11-01
SQL Server User Defined Function OverviewFunctions User Defined UDF2019-10-08
SQL Server Stored Proc Create, Modified, Last Execution Date and CodeStored Procedures2019-10-01
SQL Server Stored Procedure Context Switching and ImpersonationStored Procedures2019-09-20
Save SQL Server Stored Procedure Results to TableStored Procedures2019-09-02
Create, Alter, Drop and Execute SQL Server Stored ProceduresStored Procedures2019-08-12
SQL Server Hierarchyid Example for Bill of MaterialsTSQL2019-07-23
SQL Server and Excel Hierarchyid Example for Organization ChartsTSQL2019-07-04
SQL Server Hierarchyid Data Type Overview and ExamplesTSQL2019-06-21
SQL Temp Tables, Table Variables, Subqueries, Derived Tables and moreTemp Tables2019-06-12
SQL Server Staging Table vs Temp TableTemp Tables2019-05-23
SQL Server Common Table Expression vs Temp TableTemp Tables2019-05-22
SQL Server Table Variable ExampleTemp Tables2019-05-20
SQL Server Derived Table ExampleTemp Tables2019-05-16
SQL Server Uncorrelated and Correlated SubqueryTemp Tables2019-05-15
SQL Server Subquery ExampleTemp Tables2019-05-13
Local vs Global SQL Server Temporary TablesTemp Tables2019-05-09
Types of SQL Server Temporary TablesTemp Tables2019-05-08
One-way and Two-way Tabulation Example in SQL Server – Part 2TSQL2019-02-26
Contingency Table Analysis via Chi Square using T-SQL: Part 1TSQL2019-02-04
Data Science Goodness of Fit to Different Distributions with TSQLTSQL2019-01-14
Assess Goodness of Fit to Normal and Uniform Distributions with TSQLTSQL2019-01-02
Using T-SQL to Assess Goodness of Fit to an Exponential DistributionTSQL2018-12-13
T-SQL for Tukey Honestly Significant Difference Test After an ANOVATSQL2018-11-23
Two-Way Analysis of Variance Test Add-on for SQL Statistics PackageTSQL2018-10-29
One-Way Analysis of Variance Test Add-on for SQL Statistics PackageTSQL2018-10-03
T-Test Add-on for the SQL Statistics PackageTSQL2018-09-25
Data Science for Inferential and Predictive Statistics – Part 2Data Science2018-09-03
An Overview of Data Science for Stock Price Analysis with SQL: Part 1TSQL2018-08-22
How to Compare and Combine Artificial Intelligence Models with T-SQLArtificial Intelligence2018-08-03
Calculate Stock Buy and Sell Recommendations with TSQLTSQL2018-07-20
A T-SQL Model for Contrasting Two Different Sets of MeasurementTSQL2018-07-05
Using Two Samples to Validate MACD with T-SQLTSQL2018-06-27
T-SQL Starter Statistics Package for SQL ServerFunctions System2018-06-07
Using T-SQL to Quantify Trend Direction and StrengthTSQL2018-05-24
Using T-SQL to Detect Golden Crosses and Death CrossesTSQL2018-05-04
Using T-SQL to Refine an Analytical Model for Picking StocksTSQL2018-04-05
Using T-SQL to Detect Stock Price Reversals with the RSITSQL2018-03-19
Analyzing When to Buy and Sell Stocks Using T-SQL in SQL ServerTSQL2018-02-28
Mining Stock Price Time Series with MACD in SQL ServerTSQL2018-02-06
Mining Time Series with Exponential Moving Averages in SQL ServerTSQL2018-01-25
Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL ServerTSQL2017-12-27
Import end of day prices for all NASDAQ stocks into SQL ServerImport and Export2017-12-14
Importing Historical Stock Prices from Yahoo Finance into SQL ServerImport and Export2017-11-14
Scraping HTML Tables with Python to Populate SQL Server TablesSQL Server 20172017-11-06
Web Screen Scraping with Python to Populate SQL Server TablesSQL Server 20172017-10-20
Import Historical Stock Prices into SQL Server using PythonSQL Server 20162017-10-12
Execute Python Scripts with Management Studio to Securely Import Data into SQL ServerSQL Server 20162017-09-25
Installing Python and Running Python Scripts from SQL Server SSMSSQL Server 20162017-09-06
SQL Server Agent Job Schedule ReportingSQL Server Agent2017-08-31
Scripting New SQL Server Agent Jobs from Prior Job ScriptsSQL Server Agent2017-08-23
Tracking and Counting SQL Server Agent Job RunsSQL Server Agent2017-08-11
Queries to inventory your SQL Server Agent JobsSQL Server Agent2017-07-21
Creating Multi-Step and Dynamic SQL Server Agent JobsSQL Server Agent2017-06-26
Getting Started with SQL Server Agent – Part 1SQL Server Agent2017-06-12
List Dependencies for SQL Server Foreign KeysConstraints2017-03-16
Creating High-Low-Open-Close Candlestick Charts with SSRSReporting Services Charts2017-01-12
Pass Historical Data for Stocks from Google Finance to SQL ServerTSQL2016-10-27
SQL Server Data Mining Strategies for Stock Buy and Sell RecommendationsTSQL2016-10-17
Using SQL Server Data Analysis for Stock Trading StrategiesTSQL2016-10-04
Creating an SSRS Matrix Sparkline Report with Data from Oracle 11gReporting Services Development2016-09-15
Faster Way to Transfer Data from SQL Server 2014 to Oracle 11gSQL Server and Oracle Comparison2016-08-26
Transferring Data Between SQL Server 2014 and Oracle 11g DatabasesSQL Server and Oracle Comparison2016-08-18
Creating a SQL Server 2014 Linked Server for an Oracle 11g DatabaseSQL Server and Oracle Comparison2016-07-29
Query for pair-wise relationships between rows for a SQL Server tableTSQL2016-02-23
Converting and Using Text Dates as SQL Server DatesDates2015-05-26
Using a Simple SQL Server Bulk Insert to View and Validate DataImport and Export2015-01-09
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQLFunctions System2014-09-16
Name Parsing for Result Sets with Different Name FormatsFunctions System2014-07-15
Name Parsing with SQL Server Functions and T-SQL ProgrammingFunctions System2014-05-22
Masking Personal Identifiable SQL Server DataEncryption2013-11-13
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012Professional Development Certifications2013-03-13
Study material exam 70-463 Implement Data Warehouse with SQL ServerProfessional Development Certifications2013-02-05
SQL Server 2012 Certification PathProfessional Development Certifications2012-11-26
Using SAS ACCESS and PROC SQL to Save SAS Data in SQL ServerOther Database Platforms2012-10-05
Using SAS ACCESS and PROC SQL to Retrieve SQL Server DataOther Database Platforms2012-07-06
Using Wizards to Export a Dataset from SAS to SQL ServerOther Database Platforms2012-07-02
Work around for calculating age using the SQL Server DateDiff functionDates2012-05-09
Transferring data from SAS to SQL Server and backOther Database Platforms2012-03-30
Dynamically Name Text Files in SSISIntegration Services Development2011-12-02
Do You Want to be a Certified SQL Server Database Development ExpertProfessional Development Certifications2011-07-21
Do You Want to be a Microsoft Certified SQL Server DBA ExpertProfessional Development Certifications2011-01-24

Categories

Recent Articles

  • SQL EXISTS Use Cases and Examples

  • SQL CASE Statement in WHERE Clause Examples

  • Managing Underused Indexes in SQL Server Availability Groups – Part 1

  • Inline Scalar UDFs vs. Inline Code Performance Comparison in Fabric Warehouses – Part 2

  • SQL Partition By Examples for Aggregating Data

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide