'At-Rest Data-Leakage': The Euphemism
If you let working drives leave the building in a readable state, you’re unintentionally in the publishing business.
2012-12-31
89 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
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.
2012-11-23
151 reads
The Small Print
In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.
2012-11-21
119 reads
A Tool for the Job
Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.
2012-11-20
195 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.
2012-10-29
92 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.
2012-10-08
141 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.
2012-09-17
252 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.
2012-09-10
275 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.
2012-08-06
475 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.
2012-07-23
206 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers