SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 205    Older >>
 

Where's that Snippet?

Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?  Read more...
By Phil Factor 2019/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

The Wild Developers of SQL Server like Wildcards

Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.  Read more...
By Phil Factor 2018/12/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Data with Provenance

File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.  Read more...
By Phil Factor 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Naming Conventions for SQL Server Objects

Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.  Read more...
By Phil Factor 2018/10/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

'Comedy Limited' with SQL Server

Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.  Read more...
By Phil Factor 2018/08/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

The TSB disaster: Where were the grown-ups?

Phil Factor describes how TSB performed a major public disservice with micrsoservices.  Read more...
By Phil Factor 2018/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

Detecting SQL code smells using code analysis

Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.  Read more...
By Phil Factor 2018/07/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

One law for me, another for EU

Phil Factor notes that the EU's approach to the GDPR seems to be "do as I say, not as I do".  Read more...
By Phil Factor 2018/06/04 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

The Technology Journey to Disaster

Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.  Read more...
By Phil Factor 2018/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

Stumbling over Words

Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.  Read more...
By Phil Factor 2018/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads

Troublesome Names

Building a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right.   Read more...
By Phil Factor 2018/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 reads

Database Taming

Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.  Read more...
By Phil Factor 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 reads

Data-driven Prototypes

Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.  Read more...
By Phil Factor 2018/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 41 reads

The Appearance of the Flat File Wizard.

After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.  Read more...
By Phil Factor 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

A well-earned break from the database

Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.  Read more...
By Phil Factor 2017/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 reads

Microservices in SQL Server

In SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor.   Read more...
By Phil Factor 2017/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 118 reads

Timing is Everything

Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.  Read more...
By Phil Factor 2017/10/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

The Achilles Heel

In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.  Read more...
By Phil Factor 2017/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 67 reads

The Worms-eye View

Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.  Read more...
By Phil Factor 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads
   Items 1 to 20 of 205    Older >>