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

Regular Columnist: Phil Factor

SQLServerCentral.com profile

<< Newer    Items 21 to 40 of 178    Older >>
 

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 | 77 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 | 86 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 | 22 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,585 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,260 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 | 76 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 | 55 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 | 37 reads

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

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 | 2,306 reads

Meeting Cheating

A distaste for meetings.  Read more...
By Phil Factor 2016/06/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 113 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 | 54 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 | 99 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: |  Discuss |   Briefcase | 106 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 | 111 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 | 146 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 | 133 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
<< Newer    Items 21 to 40 of 178    Older >>