Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 114    Older >>
 

Software Projects: the important boring bits

Phil Factor on the sort of boring expertise that will help you thrive as a consultant.  Read more...
By Phil Factor 2014/12/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

Facebooking Up to Your Social Responsibilities

Phil Factor argues that as terrorists and criminals exploit the new opportunities that open up as technology develops, technologists must work with Governments to ensure thoughtful custodianship of data, and sensitivity towards legitimate privacy.  Read more...
By Phil Factor 2014/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

An Unlikely Taste for Documentation and Archiving

So, in general, what information (Scripts, configuration information, lists and documents) ought DBAs to retain about the databases and servers they are responsible for?  Read more...
By Phil Factor 2014/11/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

In Praise of Service Broker

Phil Factor on one of SQL Server's unsung and underused workhorses.  Read more...
By Phil Factor 2014/10/20 | Source: SQLServerCentral.com | Category: service broker
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Static Code Analysis: a necessary irritation.

There is little doubt that static code analysis can contribute to code quality and deliverability. As an aid to a developer, it seems increasingly essential, but can it ever deliver reliable metrics of code-quality? One shudders at the potential misuse of quality metrics in the wrong hands. My hope is that it remains just an aid to human judgement; and creativity.  Read more...
By Phil Factor 2014/07/28 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 34 reads

A IT Consultant for our Times

Phil Factor explains that being a consultant in the latest IT hot topic is a worthy role. Someone has to do it, and Phil explains why.  Read more...
By Phil Factor 2014/07/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 163 reads

Not Good Enough For Government Work

The complexity of financial trading systems is too much for an amateur approach, as the losses of various Bitcoin exchanges show.  Read more...
By Phil Factor 2014/07/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 288 reads

Is It Time To Clear Out Those Quirky Functions?

Phil Factor ponders a cull of some of SQL Server's worst-behaving functions.  Read more...
By Phil Factor 2014/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 264 reads

Application Developers don’t own their data

As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.  Read more...
By Phil Factor 2014/06/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 198 reads

The myth of the ‘shared development model’

Phil Factor fluffs the feathers of the shared sandbox model of development.  Read more...
By Phil Factor 2014/07/02 | Source: SQLServerCentral.com | Category: shared development
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Less and Less Visual

Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?  Read more...
By Phil Factor 2014/06/26 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 86 reads

Same tune, different song

It's not new and I'm already doing it. Phil Factor, a.k.a. Methuselah, on Agile, DevOps and Continuous Delivery.  Read more...
By Phil Factor 2014/06/16 | Source: SQLServerCentral.com | Category: database deployment
Rating: |  Discuss |   Briefcase | 104 reads

Anything Remotely Useful

Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.  Read more...
By Phil Factor 2014/06/09 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Should your Source Control System understand your code?

Phil Factor ponders why improvements to source control and versioning so often lag behind the pace of progress in development as a whole.  Read more...
By Phil Factor 2014/06/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 96 reads

No reason to abandon SQL

The early signs are that we can now run a SQL-based relational database with distributed execution plans over commodity hardware, leaving just the task of splicing together of the result to the engine itself, then why can’t Microsoft or Oracle do it?   Read more...
By Phil Factor 2014/05/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 163 reads

IT Skills Shortage? No, Just Looking in the wrong place

In which Phil ruminates on the ridiculous idea that we in the West suffer from an IT skills shortage. In truth we have a very blinkered idea of the sort of person who would succeed in an IT Development role   Read more...
By Phil Factor 2014/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 200 reads

Divide and Conquer

Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.  Read more...
By Phil Factor 2014/03/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

SQL Best practices, policies and code-smells.

Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.  Read more...
By Phil Factor 2014/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 380 reads

Going over their heads: IT Decisions

Phil factor points out that Marketing people who appeal directly to enterprise CIOs are generally wasting their time, and are better off convincing IT people in general.  Read more...
By Phil Factor 2013/12/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

Cloud Storage. Make it the present instead of the future.

In which Phil Factor wonders why all the different cloud storage offerings are so different, sparse in their features, crude and incompatible  Read more...
By Phil Factor 2013/11/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads
   Items 1 to 20 of 114    Older >>