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

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 | 179 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 | 165 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 | 494 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 | 116 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 | 132 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 | 216 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 | 591 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 | 331 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 | 188 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 | 357 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 | 217 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 | 234 reads

A regression of the art of database development

Recent experts in Development techniques don't seem inclined to study the history of programming; There isn't that much that's new in the art of Unit Testing database development work  Read more...
By Phil Factor 2010/05/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 345 reads

I am not a Schema

Of course user-defined Schemas are useful in SQL Server, but are you using them?  Read more...
By Phil Factor 2010/05/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 1,497 reads

Financial Data in the Cloud?

Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.  Read more...
By Phil Factor 2010/04/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 251 reads

ORM Mapping

A guest editorial from Phil Factor that discusses ORMs and how they ca be used, or mis-used, in our applications.  Read more...
By Phil Factor 2010/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 348 reads

Database Documentation: Joining up the Dots

This week, a guest editorial from Phil Factor on how SQL Server database documentation falls woefully short of what is required and expected by most development teams.  Read more...
By Phil Factor 2010/03/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 403 reads
<< Newer    Items 61 to 80 of 114    Older >>