Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 144    Older >>
 

A nice whistle and flute

Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.  Read more...
By Phil Factor 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Hunting in Packs

Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.  Read more...
By Phil Factor 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Code smells versus transgressions

The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?  Read more...
By Phil Factor 2016/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

On formatting SQL code

How much SQL code formatting is too much?  Read more...
By Phil Factor 2016/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 123 reads

The New Men of IT

According to the New Men of IT, the industry changes so frequently that experience and qualifications quickly become obsolete and irrelevant. The argument won't wash with Phil Factor.  Read more...
By Phil Factor 2016/03/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 122 reads

Testing times with SMO

SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.   Read more...
By Phil Factor 2016/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

IDEs sweet but beguiling

IDEs are wonderful, but tend to lull you out of the good habits of thinking up front about how the code you write will be monitored and tested. So argues Phil Factor.  Read more...
By Phil Factor 2016/02/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

SQL, and Ye Shall Find

Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.  Read more...
By Phil Factor 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

Muting the Immutable

Phil Factor on dealing with "immutable" domain data during database development and deployment.  Read more...
By Phil Factor 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

The SQLite alternative to NoSQL

Phil factor argues that if you are within the SQL and relational mindset, there is no good technical reason to have to change, since SQLite takes care of all the small stuff and the new breed of NewSQL takes care of the jelly-masses of unstructured data.  Read more...
By Phil Factor 2016/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

IT Data Governance and the Insider Job

Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.  Read more...
By Phil Factor 2015/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 99 reads

Giving Thanks

Phil Factor is gratified to see just how much many developers and DBAs give back to their technical communities as well as society in general.  Read more...
By Phil Factor 2015/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 38 reads

On Learning from Experience and Misfortune

Phil Factor on learning from mistakes. Preferably other people's.  Read more...
By Phil Factor 2015/10/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

The Reality of Data Governance

Uncovering how the data 'works' in a business is harder than you might think. You can't get this knowledge second-hand from the IT department. You have to speak to the business at large. However, many people are fearful of the 'bod from IT' and the change that their IT initiatives will bring.  Read more...
By Phil Factor 2015/10/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

A Case for Database CI

This week Phil Factor looks at database continuous integration.  Read more...
By Phil Factor 2015/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Whatever happened to Database Table Refactoring?

Phil Factor ponders why most people lost their initial enthusiasm for refactoring databases iteratively, in parallel with the evolutionary design of the rest of the system.  Read more...
By Phil Factor 2015/09/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 156 reads

SQL Performance Elevenses

Phil Factor's first eleven principles for diagnosing slow SQL.  Read more...
By Phil Factor 2015/08/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 251 reads

Nope to NoOps, No way to NoDBA

Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.  Read more...
By Phil Factor 2015/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 234 reads

Are DacPacs ready for prime-time?

DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?  Read more...
By Phil Factor 2015/07/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 131 reads

Is the role of the DBA really changing radically?

The term 'DBA' has been the despair of the IT industry, particularly IT recruitment, because there has been so little consensus as to what, precisely, it means. Phil Factor tries to clarify.  Read more...
By Phil Factor 2015/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads
   Items 1 to 20 of 144    Older >>