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
119 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
2017-05-16
105 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
228 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
85 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
171 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
59 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
97 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
103 reads
2017-01-23
119 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
83 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers