2019-04-13
197 reads
Database Weekly
Mongo Jumbo Backups
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
2014-02-03
282 reads
DBAs and the Fear of Time Off
Rodney Landrum on why many DBAs find it hard to ask for, and take, their due DBAcations.
2013-05-27
254 reads
The Longevity of the Relational Database
Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.
2012-09-17
254 reads
The Ego, the Id and the DBA
In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and "great" DBAs will often be outnumbered by...well...the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled, but will also need a healthy dose of ego.
2012-09-03
205 reads
Windows Server 2012, ReFS and No SQL Server
ReFS, the new file system with Windows Server 2012, should be good news, but its apparent lack of support for SQL Server is a serious concerned for Phil Factor.
2012-08-06
481 reads
To Specialize or Not to Specialize: that is the $132,000 Question
In a guest editorial, Rodney Landrum reflects on his career path as a an information-hungry generalist.
2012-05-28
247 reads
Amazon RDs and the PaaS formerly known as Azure
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
2012-05-14
250 reads
Database testing. The ferret and the rabbit
Can one generalize from agile techniques of application testing to database testing. Phil isn't entirely convinced that it can do any more that remove the distracting trivial bugs in order to allow testers to concentrate on the important issues
2011-05-30
197 reads
There cometh a shower
Phil Factor speculates on the damage caused to Cloud providers by the Amazon and Sony Outages.
2011-05-09
166 reads
Blogs
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Forums
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Tracking changing prices and recalculating inventory value
I'm trying to figure out a how to do average costing over time in...
What is Between?
Comments posted to this topic are about the item What is Between?
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers