SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 171    Older >>
 

The Ideal Agile Database

The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.  Read more...
By Phil Factor 2017/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

I'm "working from home"

Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.  Read more...
By Phil Factor 2017/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 119 reads

The Details are in the Small Print

Phil Factor on the rewards of learning the zen-like skill of writing, reading and understanding IT documentation.  Read more...
By Phil Factor 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 36 reads

Creative IT Learning

If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?  Read more...
By Phil Factor 2017/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 835 reads

The Second Career

From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.  Read more...
By Phil Factor 2017/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

The Inside Job

Grumpy DBA or necessary corporate oversight?  Read more...
By Phil Factor 2017/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

Keeping up to, and down with, Date

It is foolish to insist on reading only up-to-date books on technology. Nothing beats getting the broad perspective.  Read more...
By Phil Factor 2017/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

The Toolchain for the Job?

Phil Factor ponders the use of toolchains in automation, and wonders if there might not be a better way.  Read more...
By Phil Factor 2016/12/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

The Right Stimulus

Phil Factor ponders the I/O implications of different drinks with coding.  Read more...
By Phil Factor 2016/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

What is Normal?

Phil Factor on the virtues of "over normalizing"   Read more...
By Phil Factor 2016/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 94 reads

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.  Read more...
By Phil Factor 2016/12/21 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 915 reads

Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.  Read more...
By Phil Factor 2016/12/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,183 reads

I can ODBC clearly now

ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?  Read more...
By Phil Factor 2016/11/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 76 reads

Teaching a dog to sing

To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.  Read more...
By Phil Factor 2016/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Towards a Single Management Stack

Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.  Read more...
By Phil Factor 2016/09/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 reads

SQL Server docks in Linux

The Database Engine on the Data Platform departs for Linux. A late arrival but worthwhile, says Phil Factor.  Read more...
By Phil Factor 2016/08/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 19 reads

Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,560 reads

Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2016/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,247 reads
   Items 1 to 20 of 171    Older >>