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
1,416 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
97 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
103 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)
439 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
3 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)
401 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
2 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,384 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
5 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)
650 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
I have data in table like this. I want to fill/insert the rows with...
Hello, My company is going about ever increasing our security on all our Servers/databases....
Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running...
Ask SSC