(Chris Webb) There’s a new, as yet undocumented, option for the Web.Contents() M function that is only available for custom data connectors and not in Power BI Desktop: CredentialQueryOption.
(Jason Brimhall) Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important.
(Kenneth Fisher) Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic SQL, while the second refers to how the optimizer treats parameters differently from variables.
(Rohit Upadhyay) The Stream concept was introduced in Java 1.8 and remains present in the java.util.stream package. It is used to process the object from the collection or any group of objects or data source.
(Bipin Joshi) Now a days NoSQL databases are not uncommon. One such popular database is MongoDB. MongoDB is an open source and cross platform database that allows you to store data in the form of documents. This article series illustrates how MongoDB can be used in ASP.NET Core applications.
(Tapas Pal) Microsoft Azure Cosmos DB is an abstraction level over data stores like Azure DocumentDB and Table Storages, which is a globally distributed multi-model database service.
(Raymond Chen) You thought you’d be able to make it through the entire year without suffering through a CLR Week. And you almost made it.
(Lockwood Lyon) Until recently, business analytics against big data and the enterprise data warehouse had to come from sophisticated software packages.
(Frederic Descamps) There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options !
(stewashton) When I write SQL there is a bit of trial and error (laughter), so I need as complete a set of test cases as possible. Here’s what I came up with.