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

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: (not yet rated) |  Discuss |   Briefcase | 32 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 | 56 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 | 49 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 | 66 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 | 81 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 | 58 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 | 51 reads

Potholes in the Road of Progress

Phil Factor looks at some technologists more famous for thwarting progress than for their own creations.  Read more...
By Phil Factor 2017/07/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 79 reads

The Panjandrum Conundrum

With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.  Read more...
By Phil Factor 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

The Forgotten Editorial

Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.  Read more...
By Phil Factor 2017/06/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

The Value of Surveys

Phil Factor on the perils of trying to squeeze good insights out of bad surveys.  Read more...
By Phil Factor 2017/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 40 reads

The Rate of Change of Data

Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.  Read more...
By Phil Factor 2017/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

Cracking the SQL Code

Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.  Read more...
By Phil Factor 2017/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads

Pseudonymisation

Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.  Read more...
By Phil Factor 2017/05/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

Array Element by Agonizing Array Element

Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.  Read more...
By Phil Factor 2017/05/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

Data Privacy and Security: The Implications of GDPR

There may be new changes to our jobs as data professionals because of GDPR in the European Union.  Read more...
By Phil Factor 2017/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 91 reads

SQL Database Analysis

Static code analysis is immature for SQL code. Today Phil has a few thoughts.  Read more...
By Phil Factor 2017/05/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 73 reads

The Ideal Agile Database

The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.  Read more...
By Phil Factor 2017/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 61 reads

I'm "working from home"

Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.  Read more...
By Phil Factor 2017/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 146 reads

The Details are in the Small Print

Phil Factor on the rewards of learning the zen-like skill of writing, reading and understanding IT documentation.  Read more...
By Phil Factor 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 41 reads
   Items 1 to 20 of 188    Older >>