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

Windows Server 2012, ReFS and No SQL Server

ReFS, the new file system with Windows Server 2012, should be good news, but its apparent lack of support for SQL Server is a serious concerned for Phil Factor.  Read more...
By Phil Factor 2012/08/06 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 201 reads

What to look for in an employer

A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.  Read more...
By Phil Factor 2012/07/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

Pioneering with PowerShell

In PowerShell, Phil Factor believes we have a true novelty: a Windows Scripting language that outsmarts Perl and Python and Ruby and one that will continue to cause radical changes to Windows server applications, and the tools we use to administer them.  Read more...
By Phil Factor 2012/06/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 165 reads

Amazon RDs and the PaaS formerly known as Azure

Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.  Read more...
By Phil Factor 2012/05/14 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 191 reads

Open Source Software and Cacoëthes Scribendi

Phil Factor on the irresistible urge to write code in the public domain, and the occasional desire to be free from the snails-trail of software that needs maintainence.  Read more...
By Phil Factor 2012/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

The Clonesome Database

You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....  Read more...
By Phil Factor 2012/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 197 reads

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 | 115 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 | 251 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 | 525 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 | 85 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 | 447 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 | 593 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 | 154 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 | 229 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 | 245 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 | 97 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 | 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
<< Newer    Items 41 to 60 of 112    Older >>