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

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 137    Older >>
 

SQL, and Ye Shall Find

Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.  Read more...
By Phil Factor 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

Muting the Immutable

Phil Factor on dealing with "immutable" domain data during database development and deployment.  Read more...
By Phil Factor 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

The SQLite alternative to NoSQL

Phil factor argues that if you are within the SQL and relational mindset, there is no good technical reason to have to change, since SQLite takes care of all the small stuff and the new breed of NewSQL takes care of the jelly-masses of unstructured data.  Read more...
By Phil Factor 2016/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

IT Data Governance and the Insider Job

Good IT data governance is about crime-prevention as well as crime-detection. Legal action runs war a close second as being one of the more futile and debilitating of human activities, so prevention is always better.  Read more...
By Phil Factor 2015/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 91 reads

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: (not yet rated) |  Discuss |   Briefcase | 36 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 | 105 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 | 104 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 | 154 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 | 225 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 | 225 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 | 125 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 | 187 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 | 115 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 | 208 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 | 87 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,970 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 | 104 reads
   Items 1 to 20 of 137    Older >>