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

99
red-gate.com
Article
Scripting out several databases on a server
March, 20 2019
red-gate.com
Article
What are Inline Indexes?
February, 26 2019
red-gate.com
Article
Using Batch Scripts, and SQLCMD to Write Out a Database's Data.
February, 12 2019
red-gate.com
Article
Using Temporary Procedures
February, 8 2019
red-gate.com
Article
The risks of using EXECUTE ('SQL Script')
January, 11 2019
red-gate.com
Article
The Whys and Wherefores of Untrusted or Disabled Constraints
January, 8 2019
red-gate.com
Article
Saving Data to Various Formats, Using SQL
December, 24 2018
red-gate.com
Article
On Quickly Investigating a SQL Monitor Custom Security Alert
December, 22 2018
red-gate.com
Article
Database Continuous Integration with SQL Clone and SQL Change Automation
December, 13 2018
red-gate.com
Article
Build and fill a database using JSON and SQL Change Automation
December, 5 2018
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
SQL Prompt Code Analysis: A Hint is Used (PE004-7)
November, 15 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
Retrospective Database Source Control with SQL Compare
November, 6 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
Authorship Stats
2Sites99Projects167,091Words
About
Phil_Factor is a writer who has produced content for simple-talk.com and red-gate.com
Key Phrases
Sql Server, Source Control, Phil Factor, Extended Events, Sql Prompt, Code Analysis, Code Smells, Extended Properties, Sql Change, Stored Procedures
© ClearVoice, Inc.