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

Stairway to Exploring Database Metadata Level 7: Extended Properties

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 | 468 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 | 76 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 | 74 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 | 52 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 | 85 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 | 93 reads

Stairway to Exploring Database Metadata Level 6: Idempotent DDL scripts that always achieve the same result: Making changes only once

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

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

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,154 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 | 72 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 | 84 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 | 15 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 | 1,483 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 | 1,218 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 | 73 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 | 54 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

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 | 2,191 reads
   Items 1 to 20 of 167    Older >>