Phil Factor

Long-time software developer and Database programmer.

Categories
N/A
Content Types
N/A
More Information
Location|Languages
Publications

Published Content

71
Spoofing Data Convincingly: Doing the Shuffle and Zip
red-gate.comArticle
Spoofing Data Convincingly: Doing the Shuffle and Zip
August, 13 2018
Spoofing Data Convincingly: Credit Cards
red-gate.comArticle
Spoofing Data Convincingly: Credit Cards
August, 8 2018
The Crimes of Chicago: Working with Data in MongoDB
red-gate.comArticle
The Crimes of Chicago: Working with Data in MongoDB
August, 3 2018
Practical PowerShell Processes with SQL Change Automation
red-gate.comArticle
Practical PowerShell Processes with SQL Change Automation
August, 3 2018
Spoofing Data Convincingly: Masking Continuous Variables.
red-gate.comArticle
Spoofing Data Convincingly: Masking Continuous Variables.
July, 18 2018
Spoofing Data Convincingly: Altering Table Data
red-gate.comArticle
Spoofing Data Convincingly: Altering Table Data
July, 17 2018
SQL Prompt code analysis: avoiding the old-style TOP clause
red-gate.comArticle
SQL Prompt code analysis: avoiding the old-style TOP clause
July, 12 2018
Spoofing Data Convincingly for Database Development. An Introduction
red-gate.comArticle
Spoofing Data Convincingly for Database Development. An Introduction
July, 12 2018
Deploying Multiple Databases from Source Control using SQL Change Automation
red-gate.comArticle
Deploying Multiple Databases from Source Control using SQL Change Automation
July, 4 2018
SQL Change Automation with PowerShell Scripts: getting up-and-running
red-gate.comArticle
SQL Change Automation with PowerShell Scripts: getting up-and-running
June, 29 2018
SQL Code Analysis from a PowerShell Deployment Script
red-gate.comArticle
SQL Code Analysis from a PowerShell Deployment Script
June, 22 2018
Finding code smells using SQL Prompt: Asterisk in SELECT list
red-gate.comArticle
Finding code smells using SQL Prompt: Asterisk in SELECT list
June, 8 2018
SQL Server Closure Tables
red-gate.comArticle
SQL Server Closure Tables
April, 10 2018
SQL Code Smells
red-gate.comArticle
SQL Code Smells
April, 8 2018
Using Stored Procedures in SQL Server that return several results.
red-gate.comArticle
Using Stored Procedures in SQL Server that return several results.
March, 7 2018
Scripting the Description of Database Tables Using Extended Properties
red-gate.comArticle
Scripting the Description of Database Tables Using Extended Properties
March, 3 2018
An Easier Way of Pivoting Data in SQL Server
red-gate.comArticle
An Easier Way of Pivoting Data in SQL Server
January, 16 2018
Pivot Rotation and Matrix Transpose in SQL Server: A New Method?
red-gate.comArticle
Pivot Rotation and Matrix Transpose in SQL Server: A New Method?
December, 12 2017
The Power of Three and the Wooden Computer
red-gate.comArticle
The Power of Three and the Wooden Computer
November, 15 2017
Importing JSON Data from Web Services and Applications into SQL Server
red-gate.comArticle
Importing JSON Data from Web Services and Applications into SQL Server
October, 27 2017
Consuming hierarchical JSON documents in SQL Server using OpenJSON
red-gate.comArticle
Consuming hierarchical JSON documents in SQL Server using OpenJSON
September, 12 2017
When is the Data Deleted?
red-gate.comArticle
When is the Data Deleted?
August, 24 2017
Statistics in SQL: Student's t-test
red-gate.comArticle
Statistics in SQL: Student's t-test
August, 3 2017
Pseudonymization and the Inference Attack
red-gate.comArticle
Pseudonymization and the Inference Attack
August, 1 2017
Statistics in SQL: The Mann–Whitney U test
red-gate.comArticle
Statistics in SQL: The Mann–Whitney U test
June, 30 2017
Statistics in SQL: The Mann–Whitney U test
simple-talk.comArticle
Statistics in SQL: The Mann–Whitney U test
June, 30 2017
Is It Time To Stop Using IsNumeric()?
red-gate.comArticle
Is It Time To Stop Using IsNumeric()?
June, 23 2017
How to Automatically Create and Refresh Development and Test Databases using SQL Clone and SQL Toolbelt
red-gate.comArticle
How to Automatically Create and Refresh Development and Test Databases using SQL Clone and SQL Toolbelt
June, 7 2017
Statistics in SQL: The Kruskal–Wallis Test
red-gate.comArticle
Statistics in SQL: The Kruskal–Wallis Test
June, 1 2017
SQL Server User-Defined Functions
red-gate.comArticle
SQL Server User-Defined Functions
May, 23 2017
The Need for Database DevTest
simple-talk.comArticle
The Need for Database DevTest
May, 9 2017
Visual Checks on How Data is Distributed in SQL Server
simple-talk.comArticle
Visual Checks on How Data is Distributed in SQL Server
May, 5 2017
Statistics in SQL: Simple Linear Regressions
simple-talk.comArticle
Statistics in SQL: Simple Linear Regressions
April, 13 2017
Statistics in SQL: Kendall’s Tau Rank Correlation
simple-talk.comArticle
Statistics in SQL: Kendall’s Tau Rank Correlation
April, 10 2017
Statistics in SQL: Pearson's Correlation
simple-talk.comArticle
Statistics in SQL: Pearson's Correlation
April, 6 2017
Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot
simple-talk.comArticle
Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot
March, 27 2017
Doing Fuzzy Searches in SQL Server
simple-talk.comArticle
Doing Fuzzy Searches in SQL Server
February, 23 2017
String Comparisons in SQL: The Metaphone Algorithm
simple-talk.comArticle
String Comparisons in SQL: The Metaphone Algorithm
February, 14 2017
Metaprogramming
simple-talk.comArticle
Metaprogramming
February, 2 2017
Kadane's solution to the Maximum Subarray problem
simple-talk.comArticle
Kadane's solution to the Maximum Subarray problem
January, 25 2017
Lists With, or Without, Ranges in both T-SQL and PowerShell
simple-talk.comArticle
Lists With, or Without, Ranges in both T-SQL and PowerShell
December, 1 2016
Using SQLite with PowerShell and SQL Server
simple-talk.comArticle
Using SQLite with PowerShell and SQL Server
November, 3 2016
Reading, Writing, and Creating SQL Server Extended Properties
simple-talk.comArticle
Reading, Writing, and Creating SQL Server Extended Properties
October, 21 2016
Representing Hierarchical Data for Mere Mortals
simple-talk.comArticle
Representing Hierarchical Data for Mere Mortals
October, 6 2016
PSYaml: PowerShell does YAML
simple-talk.comArticle
PSYaml: PowerShell does YAML
September, 23 2016
On Being Economical with the Truth
simple-talk.comArticle
On Being Economical with the Truth
September, 21 2016
The SQL of Textonyms
simple-talk.comArticle
The SQL of Textonyms
August, 31 2016
Creating PowerShell Stacks and Expression Evaluaters
simple-talk.comArticle
Creating PowerShell Stacks and Expression Evaluaters
August, 2 2016
Creating PowerShell Stacks and Expression Evaluators
simple-talk.comArticle
Creating PowerShell Stacks and Expression Evaluators
August, 2 2016
Automatically Creating UML Database Diagrams for SQL Server
simple-talk.comArticle
Automatically Creating UML Database Diagrams for SQL Server
May, 27 2016
Authorship Stats
2Sites71Projects126,083Words
About
Phil Factor is a writer who has produced content for simple-talk.com and red-gate.com
Key Phrases
Sql Server, Phil Factor, Source Control, Code Smells, Extended Properties, Code Analysis, Database Objects, Sql Code, Database Developers, Primary Key
© ClearVoice, Inc.