Rick Dobson

• List Dependencies for SQL Server Foreign Keys (last update: 3/16/2017)
  

• Data Science with SQL Server for Inferential and Predictive Statistics: Part 2 (last update: 9/3/2018)
  

• 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)
  

• Masking Personal Identifiable SQL Server Data (last update: 11/13/2013)
  

• 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)
  

• 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)
  

• Download and Analyze Stooq Historical Stock Price and Volume Data in SQL Server (last update: 9/2/2021)
  
• 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)
  

• Dynamically Name Text Files in SQL Server Integration Services (last update: 12/2/2011)
  

• Create, Populate, and Subset a Pandas Dataframe from a CSV File (last update: 8/16/2021)
  
• 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)
  

• 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)
  

• 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)
  

• Data Engineering a Solution with Python and SQL Server (last update: 7/27/2021)
  
• Introduction to Python Bar Charts and Line Charts (last update: 4/26/2021)
  
• Plotting in Python for Financial Time Series Data for Exponential Moving Averages (last update: 8/30/2021)
  
• Techniques for Collecting Stock Data with Python (last update: 4/20/2021)
  

• Query Tuning in SQL Server with Set Statistics IO (last update: 5/25/2020)
  

• Creating High-Low-Open-Close Candlestick Charts with SQL Server Reporting Services (last update: 1/12/2017)
  

• Creating an SQL Server Reporting Services Matrix Sparkline Report with Data from Oracle 11g (last update: 9/15/2016)
  

• Get Started with SQL Server xp_cmdshell (last update: 3/8/2019)
  

• 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)
  

• 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)
  

• 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)
  

• 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)
  

• 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)
  

• 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)
  
• Collecting, Storing, and Displaying Geographical Coordinates in SQL Server (last update: 2/22/2021)
  
• Compare Artificial Intelligence Models Built with T-SQL (last update: 7/30/2020)
  
• Comparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression (last update: 2/5/2021)
  
• Contingency Table Analysis via Chi Square using T-SQL: Part 1 (last update: 2/4/2019)
  
• Create, Populate, and Transform Geographic Coordinates in SQL Server Tables (last update: 4/6/2021)
  
• Differences Between Exponential Moving Average and Simple Moving Average in SQL Server (last update: 7/12/2021)
  
• 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)
  
• Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON (last update: 6/22/2021)
  
• 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)
  
• Opening JSON Data with T-SQL (last update: 6/7/2021)
  
• Pass Historical Data for Stocks from Google Finance to SQL Server (last update: 10/27/2016)
  
• Performing a Sign Test with T-SQL (last update: 5/11/2021)
  
• Performing a Wilcoxon Signed Rank Test in SQL Server (last update: 5/26/2021)
  
• Query for pair-wise relationships between rows for a SQL Server table (last update: 2/23/2016)
  
• Scripts to Automate Creating and Loading a SQL Server Table (last update: 3/3/2021)
  
• 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)
  
• String to Numeric Geographic Coordinates in SQL Server with T-SQL (last update: 3/30/2021)
  
• 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)
  

• 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)