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,113 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
119 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
594 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)
445 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)
414 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
3 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,738 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
87 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)
680 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Carisol 350mg is the main ingredient. Its powerful formulation, which includes the active ingredient...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers