The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
433 reads
Phil Factor
Data Transfer Strategies between MongoDB and SQL Server
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
4,611 reads
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
298 reads
Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
176 reads
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
270 reads
Guest editorial: SQL Code Metrics
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
576 reads
Why should SQL Server 2019 excite developers?
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
665 reads
Microservice Reality
Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.
2019-03-11
128 reads
A Capital Error
It's not the zero'th time Phil Factor has complained about the madness of a binary collation.
2019-02-11
54 reads
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
93 reads
Blogs
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
By KendraLittle
I'm not an expert on collation in SQL Server, but there are a few...
Do More, With Less
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...
Daily Coping 16 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Backup server
We will have backup server maintenance with the outage between 15mins to 1 hr....
Is SQL developer edition exactly the same as enterprise edition?
Hey all, Regarding licensing of SQL server, we are considering the possibility of running...
Logging (auditing) in the table vs. having a logging (auditing) table
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...
Ask SSC