Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Rick Dobson

Rick Dobson

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.

2016 Awards

Constraints

List Dependencies for SQL Server Foreign Keys (3/16/2017)

Dates

Converting and Using Text Dates as SQL Server Dates (5/26/2015)
Work around for calculating age using the SQL Server DateDiff function (5/9/2012)

Encryption

Masking Personal Identifiable SQL Server Data (11/13/2013)

Functions - System

Name Parsing for Result Sets with Different Name Formats (7/15/2014)
Name Parsing for up to Two Different Persons from One Name String with SQL Server T-SQL (9/16/2014)
Name Parsing with SQL Server Functions and T-SQL Programming (5/22/2014)

Import and Export

Using a Simple SQL Server Bulk Insert to View and Validate Data (1/9/2015)

Integration Services Development

Dynamically Name Text Files in SQL Server Integration Services (12/2/2011)

Other Database Platforms

Creating a SQL Server 2014 Linked Server for an Oracle 11g Database (7/29/2016)
Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g (8/26/2016)
Transferring Data Between SQL Server 2014 and Oracle 11g Databases (8/18/2016)
Transferring data from SAS to SQL Server and back (3/30/2012)
Using SAS ACCESS and PROC SQL to Retrieve SQL Server Data (7/6/2012)
Using SAS ACCESS and PROC SQL to Save SAS Data in SQL Server (10/5/2012)
Using Wizards to Export a Dataset from SAS to SQL Server (7/2/2012)

Professional Development Certifications

Do You Want to be a Certified SQL Server Database Development Expert (7/21/2011)
Do You Want to be a Microsoft Certified SQL Server DBA Expert (1/24/2011)
Exam material for Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) (2/5/2013)
SQL Server 2012 Certification Path (11/26/2012)
Study Materials for Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463) (3/13/2013)

Reporting Services Charts

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

Reporting Services Development

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

SQL Server 2016

Execute Python Scripts with Management Studio to Securely Import Data into SQL Server (9/25/2017)
Import Historical Stock Prices into SQL Server using Python (10/12/2017)
Installing Python and Running Python Scripts from SQL Server SSMS (9/6/2017)

SQL Server 2017

Web Screen Scraping with Python to Populate SQL Server Tables (10/20/2017)

SQL Server Agent

Creating Multi-Step and Dynamic SQL Server Agent Jobs (6/26/2017)
Getting Started with SQL Server Agent - Part 1 (6/12/2017)
Queries to inventory your SQL Server Agent Jobs (7/21/2017)
Scripting New SQL Server Agent Jobs from Prior Job Scripts (8/23/2017)
SQL Server Agent Job Schedule Reporting (8/31/2017)
Tracking and Counting SQL Server Agent Job Runs (8/11/2017)

T-SQL

Pass Historical Data for Stocks from Google Finance to SQL Server (10/27/2016)
Query for pair-wise relationships between rows for a SQL Server table (2/23/2016)
SQL Server Data Mining Strategies for Stock Buy and Sell Recommendations (10/17/2016)
Using SQL Server Data Analysis for Stock Trading Strategies (10/4/2016)

More SQL Server Solutions