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

Meeting Cheating

A distaste for meetings.  Read more...
By Phil Factor 2016/06/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

Mentors and Professional Groups

By Phil Factor 2016/05/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

The Information Schema and Cross-RDBMS Working

A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.  Read more...
By Phil Factor 2016/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

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 | 96 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 | 102 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 | 103 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 | 133 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 | 128 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 | 75 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 | 93 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 | 79 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 | 109 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 | 109 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 | 158 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 | 261 reads
   Items 1 to 20 of 147    Older >>