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

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 | 112 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 | 263 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 | 238 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 | 137 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 | 190 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 | 117 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 | 211 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 | 97 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 | 140 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 | 88 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,972 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 | 124 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 | 188 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 | 189 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 | 307 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
<< Newer    Items 21 to 40 of 153    Older >>