Phil Factor

Long-time software developer and Database programmer.

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

Published Content

87
red-gate.com
Article
Producing Data and Schemas in JSON array-of-array format.
December, 5 2018
red-gate.com
Article
Transferring Data with JSON in SQL Server
November, 25 2018
red-gate.com
Article
How to validate JSON Data before you import it into a database.
November, 16 2018
red-gate.com
Article
Getting Excel Data as JSON: Rainfall and Sheep-Counting
November, 14 2018
red-gate.com
Article
Setting up a simple Rest interface with SQL Server
November, 8 2018
red-gate.com
Article
Monitoring Changes in Permissions, Users, Roles and Logins
October, 18 2018
red-gate.com
Article
SQL Prompt as a Layout Tool: A Survival Guide
October, 12 2018
red-gate.com
Article
Checking for Database Drift using Extended Events and SQL Monitor
October, 5 2018
red-gate.com
Article
Spotting Unauthorized Configuration Settings in SQL Server
September, 30 2018
red-gate.com
Article
Extended Events Workbench
September, 27 2018
red-gate.com
Article
Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt
September, 17 2018
red-gate.com
Article
How to Detect SQL Injection Attacks using Extended Events and SQL Monitor
September, 10 2018
red-gate.com
Article
Pseudonymizing a Database with Realistic Data for Development Work
August, 31 2018
red-gate.com
Article
SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)
August, 24 2018
red-gate.com
Article
Documenting your Database with SQL Change Automation
August, 16 2018
red-gate.com
Article
Spoofing Data Convincingly: Doing the Shuffle and Zip
August, 13 2018
red-gate.com
Article
SQL Prompt Code Analysis: INSERT INTO a permanent table with ORDER BY (PE020)
August, 13 2018
red-gate.com
Article
Spoofing Data Convincingly: Credit Cards
August, 8 2018
red-gate.com
Article
The Crimes of Chicago: Working with Data in MongoDB
August, 3 2018
red-gate.com
Article
Practical PowerShell Processes with SQL Change Automation
August, 3 2018
red-gate.com
Article
Spoofing Data Convincingly: Masking Continuous Variables.
July, 18 2018
red-gate.com
Article
Spoofing Data Convincingly: Altering Table Data
July, 17 2018
red-gate.com
Article
SQL Prompt code analysis: avoiding the old-style TOP clause
July, 12 2018
red-gate.com
Article
Spoofing Data Convincingly for Database Development. An Introduction
July, 12 2018
red-gate.com
Article
Deploying Multiple Databases from Source Control using SQL Change Automation
July, 4 2018
red-gate.com
Article
SQL Change Automation with PowerShell Scripts: getting up-and-running
June, 29 2018
red-gate.com
Article
SQL Code Analysis from a PowerShell Deployment Script
June, 22 2018
red-gate.com
Article
Finding code smells using SQL Prompt: Asterisk in SELECT list
June, 8 2018
red-gate.com
Article
SQL Server Closure Tables
April, 10 2018
red-gate.com
Article
SQL Code Smells
April, 8 2018
red-gate.com
Article
Using Stored Procedures in SQL Server that return several results.
March, 7 2018
red-gate.com
Article
Scripting the Description of Database Tables Using Extended Properties
March, 3 2018
red-gate.com
Article
An Easier Way of Pivoting Data in SQL Server
January, 16 2018
red-gate.com
Article
Pivot Rotation and Matrix Transpose in SQL Server: A New Method?
December, 12 2017
red-gate.com
Article
The Power of Three and the Wooden Computer
November, 15 2017
red-gate.com
Article
Importing JSON Data from Web Services and Applications into SQL Server
October, 27 2017
red-gate.com
Article
Consuming hierarchical JSON documents in SQL Server using OpenJSON
September, 12 2017
red-gate.com
Article
When is the Data Deleted?
August, 24 2017
red-gate.com
Article
Statistics in SQL: Student's t-test
August, 3 2017
red-gate.com
Article
Pseudonymization and the Inference Attack
August, 1 2017
red-gate.com
Article
Statistics in SQL: The Mann–Whitney U test
June, 30 2017
simple-talk.com
Article
Statistics in SQL: The Mann–Whitney U test
June, 30 2017
red-gate.com
Article
Is It Time To Stop Using IsNumeric()?
June, 23 2017
red-gate.com
Article
How to Automatically Create and Refresh Development and Test Databases using SQL Clone and SQL Toolbelt
June, 7 2017
red-gate.com
Article
Statistics in SQL: The Kruskal–Wallis Test
June, 1 2017
red-gate.com
Article
SQL Server User-Defined Functions
May, 23 2017
simple-talk.com
Article
The Need for Database DevTest
May, 9 2017
simple-talk.com
Article
Visual Checks on How Data is Distributed in SQL Server
May, 5 2017
simple-talk.com
Article
Statistics in SQL: Simple Linear Regressions
April, 13 2017
simple-talk.com
Article
Statistics in SQL: Kendall’s Tau Rank Correlation
April, 10 2017
Authorship Stats
2Sites87Projects151,952Words
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, Extended Events, Sql Prompt, Code Smells, Extended Properties, Code Analysis, Sql Code, Database Objects
© ClearVoice, Inc.