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

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 | 91 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 | 196 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 | 98 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 | 170 reads

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 | 108 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 | 197 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 | 94 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 | 139 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 | 85 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,952 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 | 86 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 | 174 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 | 180 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 | 282 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 | 116 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 | 73 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 | 120 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 | 110 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 | 42 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 | 168 reads
   Items 1 to 20 of 128    Older >>