Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
37 reads
SQL Roadie
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,462 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager to check out Cosmos DB, this is a great...
2018-10-01
27 reads
Azure Cosmos DB – Partition and Throughput
In my previous article Introduction to Azure Cosmos DB, I mentioned Partition and Throughput only briefly. Adopting a good partition scheme...
2018-08-17 (first published: 2018-08-05)
2,194 reads
Introduction to Azure Cosmos DB
What is Azure Cosmos DB?
Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a...
2018-04-29
419 reads
Export data from Cosmos DB to SQL Server
Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft...
2018-04-29
2,625 reads
Live Query Statistics – SQL Server 2016
SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works...
2018-03-07
183 reads
Because loyalty is a two-way street
Moving a dog to Australia with no money at hand
I always had plans to move to Brisbane, Australia, where my...
2016-02-27
249 reads
Database Mail shutting down. Mail queue has been stopped.
DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple...
2015-07-27
1,689 reads
XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
244 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Alamat BCA KCP Kyai Caringin Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Tanah Abang Blok A Telp:0821°7555°651
Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers