Product learning

Posts by

Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications.

Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.

He is a regular contributor to Simple Talk and SQLServerCentral.

Phil Factor

4 September 2017

Phil Factor

4 September 2017

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. Phil Factor shows how to control this behavior, for the times when you need it to be a little less intrusive, such as when working through more intricate coding problems that require careful thought. Read more

24 April 2017

24 April 2017

How to document multiple SQL Server databases using SQL Doc and PowerShell

Phil shows how to use SQL Doc, PowerShell and a SQL Doc XML Project file to document multiple databases at once. Read more

27 March 2017

27 March 2017

Automating database deployments to and from source control using SQL Compare and PowerShell

How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with source. Read more

14 March 2017

14 March 2017

Automatically build-and-fill multiple development databases using PowerShell and SQL Data Generator

This article offers a build-and-fill method for development databases, where each developer will subsequently want to alter the data or metadata in his or her copy of the database. Read more

13 March 2017

13 March 2017

Creating database documentation in ePub format using SQL Doc and PowerShell

Phil Factor provides a PowerShell script that uses SQL Doc produce database documentation and then pandoc to publish it in ePub format. Read more

9 March 2017

9 March 2017

How to Automatically Fill your SQL Server Test Databases with Dummy Data

A PowerShell script to automatically populate a SQL Server database with dummy data, for database development and testing work. Read more

SQL Data Generator

Phil Factor

15 February 2017

Phil Factor

15 February 2017

Getting started with SQL Doc and PowerShell

Phil Factor uses PowerShell and SQL Doc to automatically generate database documentation, and update it on every successful build. Read more

19 December 2016

19 December 2016

How to generate realistic text data using SQL Data Generator

To get the best results, you need to provide SQL Data Generator with some hints on how the data ought to look. Phil Factor nudges it towards realistic text data. Read more

SQL Data Generator

Phil Factor

13 December 2016

Phil Factor

13 December 2016

Generating realistic dates using SQL Data Generator and Python

How to generate more realistic dates, in your SQL Server test data. Read more

SQL Data Generator

Phil Factor

18 October 2016

Phil Factor

18 October 2016

Generating test data with localized addresses using SQL Data Generator

With basic grasp of regex expressions, a tool like SQL Data Generator can generate test data with addresses that are realistic for your part of the world. Read more

SQL Data Generator

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product learning

Posts by

Phil Factor

SQL Prompt Tip: how to control when the suggestion box pops up

How to document multiple SQL Server databases using SQL Doc and PowerShell

Automating database deployments to and from source control using SQL Compare and PowerShell

Automatically build-and-fill multiple development databases using PowerShell and SQL Data Generator

Creating database documentation in ePub format using SQL Doc and PowerShell

How to Automatically Fill your SQL Server Test Databases with Dummy Data

Getting started with SQL Doc and PowerShell

How to generate realistic text data using SQL Data Generator

Generating realistic dates using SQL Data Generator and Python

Generating test data with localized addresses using SQL Data Generator

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Posts by Phil Factor

Posts by

Phil Factor