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)
321 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)
392 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,067 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)
628 reads
Many people who read my Cosmos DB articles are looking for an effective way to export data to SQL, either on-demand or in real-time. After performing a search term...
2019-05-17 (first published: 2019-05-05)
1,036 reads
The Gartner Magic Quadrant for 2019, announced earlier this month, names Microsoft the leader in Analytics and Business Intelligence Platforms....
2019-03-12 (first published: 2019-02-23)
4,116 reads
Microsoft’s Azure Databricks is an advanced Apache Spark platform that brings data and business teams together. In this introductory article,...
2019-02-17
384 reads
Global AI Bootcamp, Brisbane 2018
Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other...
2018-12-16
432 reads
Recap!
Part 1 of Predictive Modeling using R and SQL Server Machine Learning Services covered an overview of Predictive Modeling and the...
2018-11-27 (first published: 2018-11-18)
3,278 reads
To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...
2018-11-12
455 reads
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
By Arun Sirpal
If you are building database solutions in Azure , using Azure SQL Database then...
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Hi, I have a job that keeps getting a deadlock victim error and fails....
I am using SQL Server 2008 R2. While using XML data type and XQuery...
Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...
Ask SSC