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 41 to 60 of 99    Older >>
 

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 | 144 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 | 227 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 | 103 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 | 233 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 | 95 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 | 175 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 | 160 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 | 491 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 | 96 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 | 114 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 | 129 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 | 209 reads

SQL Server's implementation of Window Functions

Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.  Read more...
By Phil Factor 2010/09/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 551 reads

Getting Fired from an Unpaid Job.

Phil Factor initially brooded about being fired from a job he was just doing unpaid to help out. Then he suddenly realized that they were probably right.  Read more...
By Phil Factor 2010/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 329 reads

Houston, we have a problem

Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.  Read more...
By Phil Factor 2010/08/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 186 reads

The Great Forum Debate

Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.  Read more...
By Phil Factor 2010/06/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

A new IDE for SQL Server?

Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.  Read more...
By Phil Factor 2010/06/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 356 reads

Getting the Message

Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?  Read more...
By Phil Factor 2010/05/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 213 reads

Where a Rose is not a rose…

Just because mistakes have become entrenched in the computer languages that we use doesn't mean we have to tolerate them  Read more...
By Phil Factor 2010/05/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 232 reads
<< Newer    Items 41 to 60 of 99    Older >>