In this article, we will explore the HTAP capabilities of Cosmos DB. The goal is to derive real-time insights from transactional changes made to Cosmos DB, in a cost-effective manner with minimal overhead. I want the solution to be scalable, reliable and overall simple to maintain.
2021-11-03
2,188 reads
I haven’t done much blogging in the last 6 months. My last article was posted in January, on Data Governance in the Covid era. After changing jobs in March,...
2021-10-17
128 reads
I haven’t done much blogging in the last 6 months. My last article was posted in January, on Data Governance in the Covid era. I changed jobs in March,...
2021-10-17
729 reads
One common theme that stood out last year is the oversupply of data to our fingertips. In my line of work as a data professional, I produce, consume and...
2021-01-12 (first published: 2021-01-05)
448 reads
Covid-driven disruption calls for a higher degree of consistency and clarity on the data assets handled by any organization, because in the months to come there will be a...
2021-01-05
4 reads
Everyone of us is in a perpetual pursuit of awesomeness - some actively looking for it, while others passively. Either way, it is inherent in our making to reach...
2020-09-11 (first published: 2020-09-06)
420 reads
One unequivocal point to note is that loving oneself is a precursor to awesomeness. You can't be awesome if you don't love yourself. Period!
2020-09-06
4 reads
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
2,774 reads
In this article, we will focus on creating a data pipeline to ETL (Extract, Transform and Load) Cosmos DB container changes to a SQL Server database. Note that this...
2019-07-21
104 reads
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-06-17 (first published: 2019-05-28)
692 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers