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 201    Older >>
 

Are there such things as SQL heresies?

It depends.  Read more...
By Phil Factor 2018/09/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 9 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 | 75 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 | 102 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 | 41 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 | 37 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 | 78 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 | 84 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 | 55 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 | 40 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 | 107 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

Avoiding the Hell of having to Remember DDL syntax

What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.  Read more...
By Phil Factor 2017/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

The struggle to renormalize data

You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.  Read more...
By Phil Factor 2017/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads

The art of getting it right

Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.  Read more...
By Phil Factor 2017/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads

The Tethered Goat

Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".  Read more...
By Phil Factor 2017/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 reads
   Items 1 to 20 of 201    Older >>