Rick Dobson

Rick Dobson is a Microsoft Certified Technical Specialist and well accomplished SQL Server and Access author.

 

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.

2021 Awards   

2020 Awards      

2019 Awards      

2018 Awards      

2017 Awards   

2016 Awards   

CategoryTitle
ConstraintsList Dependencies for SQL Server Foreign Keys
Data ScienceData Science with SQL Server for Inferential and Predictive Statistics: Part 2
DatesConverting and Using Text Dates as SQL Server Dates
DatesWork around for calculating age using the SQL Server DateDiff function
EncryptionMasking Personal Identifiable SQL Server Data
Functions SystemGenerate Unique Random Number in SQL Server
Functions SystemName Parsing for Result Sets with Different Name Formats
Functions SystemName Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL
Functions SystemName Parsing with SQL Server Functions and T-SQL Programming
Functions SystemT-SQL Starter Statistics Package for SQL Server
Functions User Defined UDFFind SQL Server User Defined Function Create, Modified, Last Execution Date and Code
Functions User Defined UDFSQL Server User Defined Function Example
Functions User Defined UDFSQL Server User Defined Function Overview
Import and ExportDownload and Analyze Stooq Historical Stock Price and Volume Data in SQL Server
Import and ExportImport end of day prices for all NASDAQ stocks into SQL Server
Import and ExportImporting Historical Stock Prices from Yahoo Finance into SQL Server
Import and ExportUsing a Simple SQL Server Bulk Insert to View and Validate Data
Integration Services DevelopmentDynamically Name Text Files in SQL Server Integration Services
Other Database PlatformsCreate, Populate, and Subset a Pandas Dataframe from a CSV File
Other Database PlatformsCreating a SQL Server 2014 Linked Server for an Oracle 11g Database
Other Database PlatformsFaster Way to Transfer Data from SQL Server 2014 to Oracle 11g
Other Database PlatformsTransferring Data Between SQL Server 2014 and Oracle 11g Databases
Other Database PlatformsTransferring data from SAS to SQL Server and back
Other Database PlatformsUsing SAS ACCESS and PROC SQL to Retrieve SQL Server Data
Other Database PlatformsUsing SAS ACCESS and PROC SQL to Save SAS Data in SQL Server
Other Database PlatformsUsing Wizards to Export a Dataset from SAS to SQL Server
Performance TuningCapture Duration Metrics for SQL Server Query Tuning
Performance TuningSet Statistics Time Examples for Tuning SQL Server Queries
Professional Development CertificationsDo You Want to be a Certified SQL Server Database Development Expert
Professional Development CertificationsDo You Want to be a Microsoft Certified SQL Server DBA Expert
Professional Development CertificationsSQL Server 2012 Certification Path
Professional Development CertificationsStudy material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012
Professional Development CertificationsStudy material for exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 - Part 2
PythonBuild Pie Charts with Python for Displaying Counts from SQL Server Data
PythonCreate Performance Charts in Python for Time Series Data within SQL Server
PythonData Engineering a Solution with Python and SQL Server
PythonIntroduction to Python Bar Charts and Line Charts
PythonIntroduction to Treemap Charts for SQL Server Professionals
PythonPlotting in Python for Financial Time Series Data for Exponential Moving Averages
PythonTechniques for Collecting Stock Data with Python
Query OptimizationQuery Tuning in SQL Server with Set Statistics IO
Reporting Services ChartsCreating High-Low-Open-Close Candlestick Charts with SQL Server Reporting Services
Reporting Services DevelopmentCreating an SQL Server Reporting Services Matrix Sparkline Report with Data from Oracle 11g
SecurityGet Started with SQL Server xp_cmdshell
SQL Server 2016Execute Python Scripts with Management Studio to Securely Import Data into SQL Server
SQL Server 2016Import Historical Stock Prices into SQL Server using Python
SQL Server 2016Installing Python and Running Python Scripts from SQL Server SSMS
SQL Server 2017Scraping HTML Tables with Python to Populate SQL Server Tables
SQL Server 2017Web Screen Scraping with Python to Populate SQL Server Tables
SQL Server AgentCreating Multi-Step and Dynamic SQL Server Agent Jobs
SQL Server AgentGetting Started with SQL Server Agent - Part 1
SQL Server AgentQueries to inventory your SQL Server Agent Jobs
SQL Server AgentScripting New SQL Server Agent Jobs from Prior Job Scripts
SQL Server AgentSQL Server Agent Job Schedule Reporting
SQL Server AgentTracking and Counting SQL Server Agent Job Runs
Stored ProceduresCreate, Alter, Drop and Execute SQL Server Stored Procedures
Stored ProceduresFind SQL Server Stored Procedure Create, Modified, Last Execution Date and Code
Stored ProceduresSave SQL Server Stored Procedure Results to Table
Stored ProceduresSQL Server Stored Procedure Context Switching and Impersonation Example
Stored ProceduresSQL Server Stored Procedure Input Parameter, Output Parameter and Return Value
Temp TablesDifferences Between SQL Server Temp Tables, Table Variables, Subqueries, Derived Tables, CTEs and Physical Tables
Temp TablesLocal vs Global SQL Server Temporary Tables
Temp TablesSQL Server Common Table Expression vs Temp Table
Temp TablesSQL Server Derived Table Example
Temp TablesSQL Server Staging Table vs Temp Table
Temp TablesSQL Server Subquery Example
Temp TablesSQL Server Table Variable Example
Temp TablesSQL Server Uncorrelated and Correlated Subquery
Temp TablesTypes of SQL Server Temporary Tables
TSQLA Framework for Comparing Time Series Data from Yahoo Finance and Stooq.com
TSQLA One-Way Analysis of Variance Test Add-on for the SQL Statistics Package
TSQLA T-SQL Model for Contrasting Two Different Sets of Measurement
TSQLA Two-Way Analysis of Variance Test Add-on for the SQL Statistics Package
TSQLAn Overview of Data Science for Stock Price Analysis with SQL: Part 1
TSQLAnalyze Historical Weather Data with SQL Server
TSQLAnalyze Relationship Between Two Time Series in SQL Server
TSQLAnalyzing When to Buy and Sell Stocks Using T-SQL in SQL Server
TSQLArtificial Intelligence Programming with T-SQL for Time Series Data
TSQLAssessing Time Series Model Performance with T-SQL
TSQLAssessing with SQL and Data Science Goodness of Fit to Different Distributions
TSQLCandlestick and Heikin Ashi Charts from Yahoo Finance and Stooq.com
TSQLCollecting Time Series Data for Stock Market with SQL Server
TSQLCollecting, Storing, and Displaying Geographical Coordinates in SQL Server
TSQLCompare Artificial Intelligence Models Built with T-SQL
TSQLComparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression
TSQLCompute and Display Candlestick Charts in SQL Server and Python
TSQLCompute and Display Heikin Ashi Charts in SQL Server and Excel
TSQLCompute the Relative Strength Index for Time Series within SQL Server
TSQLContingency Table Analysis via Chi Square using T-SQL: Part 1
TSQLCreate and Compare SQL Time Series Models
TSQLCreate, Populate, and Transform Geographic Coordinates in SQL Server Tables
TSQLDifferences Between Exponential Moving Average and Simple Moving Average in SQL Server
TSQLExponential Moving Average Calculation in SQL Server
TSQLHow to Compare and Combine Artificial Intelligence Models with T-SQL
TSQLHow to Compute Simple Moving Averages with Time Series Data in SQL Server
TSQLImplement K Nearest Neighbor Solution with T-SQL
TSQLLoad Time Series Data with SQL Server
TSQLMigrate Key-Value Pairs from Python Dictionary to SQL Server via JSON
TSQLMigrating Time Series Data to SQL Server from Yahoo Finance and Stooq.com
TSQLMining Stock Price Time Series with MACD in SQL Server
TSQLMining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server
TSQLMining Time Series with Exponential Moving Averages in SQL Server
TSQLModel and Log Trend Reversals for Time Series Data in SQL Server
TSQLMultiple Regression Model Enhanced with Bagging
TSQLOne-way and Two-way Tabulation Example in SQL Server - Part 2
TSQLOpening JSON Data with T-SQL
TSQLPass Historical Data for Stocks from Google Finance to SQL Server
TSQLPerformance Score Models for Decisions about Time Series with SQL and Excel
TSQLPerforming a Sign Test with T-SQL
TSQLPerforming a Wilcoxon Signed Rank Test in SQL Server
TSQLQuery for pair-wise relationships between rows for a SQL Server table
TSQLRevisiting Time Series Model Performance Assessment with T-SQL
TSQLScripts to Automate Creating and Loading a SQL Server Table
TSQLSQL Server and Excel Hierarchyid Example for Organization Charts
TSQLSQL Server Data Mining Strategies for Stock Buy and Sell Recommendations
TSQLSQL Server Hierarchyid Data Type Overview and Examples
TSQLSQL Server Hierarchyid Example for Bill of Materials
TSQLSQL Server T-SQL Code for the Tukey Honestly Significant Difference Test After an ANOVA
TSQLString to Numeric Geographic Coordinates in SQL Server with T-SQL
TSQLT-SQL Code for Decision Tree Regression Algorithm - Part 3
TSQLT-SQL Code for Multi-Level Decision Tree - Part 2
TSQLT-SQL Code for the Decision Tree Algorithm - Part 1
TSQLT-SQL to Calculate Buy and Sell Stock Recommendations via Three Technical Indicators
TSQLT-Test Add-on for the SQL Statistics Package
TSQLTime Series Data Fact and Dimension Tables for SQL Server
TSQLUse Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
TSQLUse MACD to Predict When to Buy and Sell Securities with T-SQL
TSQLUsing SQL Server Data Analysis for Stock Trading Strategies
TSQLUsing SQL to Assess Goodness of Fit to Normal and Uniform Distributions
TSQLUsing T-SQL to Assess Goodness of Fit to an Exponential Distribution
TSQLUsing T-SQL to Detect Golden Crosses and Death Crosses
TSQLUsing T-SQL to Detect Stock Price Reversals with the RSI
TSQLUsing T-SQL to Quantify Trend Direction and Strength
TSQLUsing T-SQL to Refine an Analytical Model for Picking Stocks
TSQLUsing Two Samples to Validate MACD with T-SQL
TSQLWeather Data Warehouse in SQL Server - Create and Populate
TSQLWeather Data Warehouse in SQL Server - Gather Information
TSQLWeather Station Tracking with SQL Server and Excel
TSQLWeighted vs Simple Moving Average with SQL Server T-SQL Code
ViewsCreate, Alter, Drop and Query SQL Server Views
ViewsInsert and Delete SQL Server Data with Views
ViewsTrack and Monitor SQL Server View Usage
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (33)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (73)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (188)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (67)
Database AdministrationPartitioning (14)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (127)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (40)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (3)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (14)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (20)
Database DevelopmentFunctions System (65)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (74)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (36)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (295)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (10)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (106)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (12)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (28)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (10)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (74)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (31)