SQL Tamagotchi! Mini-Servers as Database Pets
If you've ever stuffed SQL Server onto a Raspberry Pi 4 and given it a pet name, don't worry, you're not alone…
2019-08-24
203 reads
Phil Factor
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
256 reads
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
338 reads
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
1,281 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
264 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
160 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
243 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)
566 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
628 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
103 reads
Blogs
Weekly reading #26
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
Delete an Azure DevOps Project
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
Ways to access data in ADLS Gen2
By James-Serra
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
“Included columns” for non-clustered indexes explained
Comments posted to this topic are about the item “Included columns” for non-clustered indexes...
Reindexing a database
Comments posted to this topic are about the item Reindexing a database
Ask SSC