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
5 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,436 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
2 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,166 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
388 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,526 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
163 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
219 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,027 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
218 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers