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

Not a cloud to be seen

Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.  Read more...
By Phil Factor 2015/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

The Multi-skilled Developer

Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.  Read more...
By Phil Factor 2015/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 184 reads

Not Only a Meeting of Minds, but of Open Minds.

In which Phil Factor claims that professional application development requires a broad knowledge base.  Read more...
By Phil Factor 2015/05/11 | Category: editorial
Rating: |  Discuss |   Briefcase | 93 reads

Don't exaggerate the difficulties of the RDBMS

Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".  Read more...
By Phil Factor 2015/04/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

One Rule, Umpteen Constraints

Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 81 reads

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 2,926 reads

Microservices, SOA and Service Broker

If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.  Read more...
By Phil Factor 2015/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 76 reads

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 | 166 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 | 173 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 | 271 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 | 112 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 | 72 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 | 119 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 | 104 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 | 39 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 | 166 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 | 297 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 | 276 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 | 308 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
   Items 1 to 20 of 124    Older >>