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 21 to 40 of 99    Older >>
 

The SQL Server Pro Awards

Phil Factor is pleasantly surprised by the SQL Server Pro awards, and talks about the thinking behind Down Tools Week.  Read more...
By Phil Factor 2012/11/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 112 reads

The Small Print

In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.  Read more...
By Phil Factor 2012/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 114 reads

A Tool for the Job

Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.  Read more...
By Phil Factor 2012/11/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 174 reads

A Tale of Broken BI

Graphs and charts are dangerous in the wrong hands, and if built on data that is carelessly gathered will mislead as often as they lead. Phil Factor speaks from hard experience.  Read more...
By Phil Factor 2012/10/29 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 68 reads

Your Password has Failed the Test

Your data is in the public domain and as a DBA you need to be very familiar with what it is possible for the sinner to do with a handy password, and how easily that sinner can get hold of it.  Read more...
By Phil Factor 2012/10/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 127 reads

The Longevity of the Relational Database

Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.  Read more...
By Phil Factor 2012/09/17 | Source: SQLServerCentral.com | Category: database weekly
Rating: |  Discuss |   Briefcase | 216 reads

Document First, Code Later

Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.  Read more...
By Phil Factor 2012/09/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 227 reads

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 | 195 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 | 194 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 | 161 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 | 187 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 | 194 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 | 110 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 | 244 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 | 480 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 | 138 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 | 81 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 | 444 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 | 535 reads
<< Newer    Items 21 to 40 of 99    Older >>