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

Regular Columnist: Phil Factor

SQLServerCentral.com profile

<< Newer    Items 21 to 40 of 137    Older >>
 

Fifty Words for Databases

Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.  Read more...
By Phil Factor 2015/03/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 186 reads

Programming Rules and 'Best Practices' Can't Replace Professional Judgement

In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement  Read more...
By Phil Factor 2015/02/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 187 reads

Where Microsoft went wrong with SQL CLR

We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.  Read more...
By Phil Factor 2015/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 301 reads

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 | 121 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 | 75 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: |  Discuss |   Briefcase | 123 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: |  Discuss |   Briefcase | 127 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: |  Discuss |   Briefcase | 45 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 | 171 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 | 305 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 | 280 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 | 322 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 | 76 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 | 91 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 | 105 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: |  Discuss |   Briefcase | 75 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 | 107 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 | 177 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 | 212 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 | 115 reads
<< Newer    Items 21 to 40 of 137    Older >>