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
571 reads
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
233 reads
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
147 reads
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
231 reads
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)
556 reads
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
583 reads
Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.
2019-03-11
102 reads
It's not the zero'th time Phil Factor has complained about the madness of a binary collation.
2019-02-11
52 reads
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
84 reads
Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.
2018-12-17
100 reads
By Steve Jones
This post continues looking at some of the Kubernetes concepts I’ve been learning with...
By James-Serra
Below are the top 15 questions I am seeing from customers looking to build...
I’ve always said if you’re running a script for the first time in a...
I have a table used for staging during ETL. It is empty most of...
Hello, I have set up and configured xp_cmdshell using a proxy account and I...
Ask SSC