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

<< Newer    Items 61 to 80 of 126    Older >>
 

Disconnected database development: solving a problem that needn't exist

A disconnected model is only really needed in the absence of a properly-defined database interface. We, as developers, create a rod for our own backs by insisting on treating a database in a way we wouldn't treat an object, let alone an assembly or namespace.   Read more...
By Phil Factor 2012/03/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 118 reads

Call That a Database? This is a Database.

If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.  Read more...
By Phil Factor 2012/02/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 255 reads

Putting JSON on an equal footing to XML

In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.  Read more...
By Phil Factor 2012/02/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 580 reads

On Database Migrations and Agility

It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.  Read more...
By Phil Factor 2012/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads

Voluntary Constraint?

In which Phil Factor argues that Domain Constraints are a fundamental part of the relational database. If he had to sacrifice a feature of relational databases, it wouldn’t be domain constraints.  Read more...
By Phil Factor 2012/01/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

The Stubborn DBA

Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?  Read more...
By Phil Factor 2012/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 455 reads

GOTO and T-SQL

Today we have a guest editorial from Phil Factor as Steve is on vacation. This piece looks at the complaints against GOTO and whether they are valid.  Read more...
By Phil Factor 2011/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 628 reads

Little Love Lost for SMO

SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.  Read more...
By Phil Factor 2011/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 159 reads

Don't Criticize Code

For anyone eager for a long-term career in IT Development, humility and tact are probably more important habits to acquire than demon coding-skills. Phil Factor explains why.  Read more...
By Phil Factor 2011/11/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 231 reads

Never offend a captive audience

Write what you choose to when the reader can, in turn, choose not to read your work; but when you are writing about Technology, you have a captive audience. They need to read your work to keep abreast of the technology. Don't gratuitously offend them. It is not the action of a gentleman, D____it!  Read more...
By Phil Factor 2011/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Now you ODBC me now you don't

Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.  Read more...
By Phil Factor 2011/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 253 reads

Piracy and Agile

Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.  Read more...
By Phil Factor 2011/09/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Database testing. The ferret and the rabbit

Can one generalize from agile techniques of application testing to database testing. Phil isn't entirely convinced that it can do any more that remove the distracting trivial bugs in order to allow testers to concentrate on the important issues  Read more...
By Phil Factor 2011/05/30 | Source: SQLServerCentral.com | Category: database weekly
Rating: (not yet rated) |  Discuss |   Briefcase | 181 reads

There cometh a shower

Phil Factor speculates on the damage caused to Cloud providers by the Amazon and Sony Outages.  Read more...
By Phil Factor 2011/05/09 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 141 reads

Serialising tabular and relational data.

Guest editorial by Phil who bemoans the difficulty of transferring tabular data by file between differing databases, spreadsheets and analysis tools.  Read more...
By Phil Factor 2011/03/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 170 reads

Is Microsoft neglecting SMO?

Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?  Read more...
By Phil Factor 2011/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 495 reads

A Great Deal of Hot Air

Even though neither the science nor politics of climate change is fully established yet, the legislators and bureaucrats have smelt an opportunity to further tighten their grip on IT. A sign of things to come is the EU’s Code of Conduct for Data Centers on Energy Efficiency.   Read more...
By Phil Factor 2011/01/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

When a Dogma has had its' day

Phil points out that the SQL Server community has a role to play in making sure that the wisdom of SQL Server Pundits is regularly tested and challenged.  Read more...
By Phil Factor 2010/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 117 reads

No free lunch in the Orchard

Phil Factor finds much to admire in Microsoft's new Orchard application but is frustrated by a design decision that seems to limit its use to low-volume applications, with less stringent security requirements.   Read more...
By Phil Factor 2010/11/08 | Source: SQLServerCentral.com | Category: orchard
Rating: |  Discuss |   Briefcase | 137 reads

The One True Script

Phil Factor less-than-fond memories of the days of the One True Source Script. However, despite recent advances, he wonders just how much smoother team-based database development really is.  Read more...
By Phil Factor 2010/10/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads
<< Newer    Items 61 to 80 of 126    Older >>