Array Element by Agonizing Array Element
Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.
2017-05-17
98 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
2017-05-16
93 reads
Cracking the SQL Code
Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.
2017-05-15
175 reads
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.
2017-04-03
74 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.
2017-03-27
157 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.
2017-03-13
47 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?
2017-03-06
82 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.
2017-02-13
90 reads
2017-01-23
105 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.
2017-01-09
73 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en California El Departamento...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers