A Capital Error
It's not the zero'th time Phil Factor has complained about the madness of a binary collation.
2019-02-11
75 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
111 reads
Where Microsoft went wrong with SQL CLR
We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.
2018-12-12 (first published: 2015-01-19)
458 reads
Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
2018-12-03
379 reads
Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
2018-10-22
2,339 reads
2018-09-24
148 reads
'Comedy Limited' with SQL Server
Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.
2018-08-27
521 reads
The TSB disaster: Where were the grown-ups?
Phil Factor describes how TSB performed a major public disservice with micrsoservices.
2018-08-13
180 reads
Detecting SQL code smells using code analysis
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
2018-07-02
386 reads
An Unlikely Taste for Documentation and Archiving
So, in general, what information (Scripts, configuration information, lists and documents) ought DBAs to retain about the databases and servers they are responsible for?
2018-05-31 (first published: 2014-11-10)
201 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