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)
379 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)
395 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,076 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)
630 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,098 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,147 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
404 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,367 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
474 reads
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Comments posted to this topic are about the item Understanding the Internals of a...
Comments posted to this topic are about the item Preventing Trigger Execution
Ask SSC