Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Phil Factor

SQLServerCentral.com profile

   Items 1 to 20 of 156    Older >>
 

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 | 78 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 | 42 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 | 9 reads

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

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 | 887 reads

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

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 | 996 reads

Point-in-time data

Phil Factor explains why data detached from its temporal context often loses all meaning.  Read more...
By Phil Factor 2016/08/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

Adding Old Features?

Is Row Level Security a new feature? Or should MS work on improving old ones?  Read more...
By Phil Factor 2016/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads

Delivering Rapid Improvements to SSMS

SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality  Read more...
By Phil Factor 2016/07/18 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,459 reads

Meeting Cheating

A distaste for meetings.  Read more...
By Phil Factor 2016/06/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 108 reads

The Information Schema and Cross-RDBMS Working

A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.  Read more...
By Phil Factor 2016/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

A nice whistle and flute

Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.  Read more...
By Phil Factor 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 98 reads

Hunting in Packs

Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.  Read more...
By Phil Factor 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Code smells versus transgressions

The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?  Read more...
By Phil Factor 2016/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

On formatting SQL code

How much SQL code formatting is too much?  Read more...
By Phil Factor 2016/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads

The New Men of IT

According to the New Men of IT, the industry changes so frequently that experience and qualifications quickly become obsolete and irrelevant. The argument won't wash with Phil Factor.  Read more...
By Phil Factor 2016/03/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 130 reads

Testing times with SMO

SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.   Read more...
By Phil Factor 2016/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads

IDEs sweet but beguiling

IDEs are wonderful, but tend to lull you out of the good habits of thinking up front about how the code you write will be monitored and tested. So argues Phil Factor.  Read more...
By Phil Factor 2016/02/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

SQL, and Ye Shall Find

Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.  Read more...
By Phil Factor 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads
   Items 1 to 20 of 156    Older >>