A Fine Slice Of SQL Server
Deleting a single document is pretty straightforward in Elasticsearch. We can simply issue a DELETE on the document id and the document will be deleted from the index.
Click through for that example, as well as the multi-document delete (and a check to ensure that it worked).
Comments closedAfter finishing this tutorial, you will learn
– What the pandas library provides
– What is a DataFrame and a Series in pandas
– How to manipulate DataFrame and Series beyond the trivial array operations
Let’s get started!
Let’s, shall we?
Comments closedBryan Shalloway continues looking at Twitter data:
This is a follow-up to a short post I wrote on R Access to Twitter’s v2 API. In this post I’ll walk through a few more examples of pulling data from twitter using a mix of Twitter’s v2 API as well as the
{rtweet}package.I’ll pull all Twitter users that I (brshallo) have recently been engaged by (e.g. they like my tweet) or engaged with (e.g. I like their tweet). I’ll lean towards using
{rtweet}but will use{httr}in cases where it’s more convenient to use Twitter’s v2 API.
Click through for more information, including several R scripts.
Comments closedJon Fletcher needs to get some PBIX files:
In this blog post I will be sharing a PowerShell script that allows multiple Power BI reports to be downloaded at once.
In the Power BI service, there is no way of downloading multiple Power BI reports at once. Therefore, users must download files one by one which is slow, time consuming and inefficient. Thankfully, there are ways around this, one of which is using PowerShell.
Read on for the script and some additional notes.
Comments closedLionel Penuchot loads some data:
This article reviews a common pattern of streaming data (i.e. real-time message ingestion) in Synapse dedicated pool. It opens a discussion on the simple standard way to implement this, as well as the challenges and drawbacks. It then presents an alternate solution which enables optimal performance and greatly reduces maintenance tasks when using clustered column store indexes. This is aimed at developers, DBAs, architects, and anyone who works with streams of data that are captured in real-time.
I’d probably avoid the MERGE statement in there because of how many problems there are with it. That said, this is a useful pattern for trickle-loading columnstore tables.
Camila Henrique summarizes the most recent T-SQL Tuesday:
I had a lot of fun reading your different takes on it! Here are the posts of everyone who contributed (and dutifully linked it back to me).
Click through for the list of entries.
Comments closedArun Sirpal looks at some of the command language for Azure Redis:
Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do, use the Azure Portal to use the console directly, this isn’t probably the best way but it’s the easiest for this blog. 2 key points here:
Read on for those points, as well as examples of commands you can run.
Comments closed