A Fine Slice Of SQL Server
Robert Metzger updates us on the state of Apache Flink on Docker:
With over 50 million downloads from Docker Hub, the Flink docker images are a very popular deployment option.
The Flink community recently put some effort into improving the Docker experience for our users with the goal to reduce confusion and improve usability.
Read on to learn more about those recent improvements and how to get started with Flink.
Comments closedKundan Kumarr walks us through a simple data pipeline:
Spark Structured Streaming is a component of Apache Spark framework that enables scalable, high throughput, fault tolerant processing of data streams.
Apache Kafka is a scalable, high performance, low latency platform that allows reading and writing streams of data like a messaging system.
Apache Cassandra is a distributed and wide-column NoSQL data store.
As I’m reading through this, I enjoyed just how straightforward the whole process was.
Comments closedMatt Allington wants to solve a problem:
Using a switch measure to toggle results is a mature and common technique used in Power BI and Power Pivot for Excel. For example, a switch measure can be used to toggle what appears on a chart so that the end user can easily switch the data being visualised (see image below).
This technique uses a disconnected table, a slicer to receive the user selection, and a switch measure to change the result of the measure based on user input. When you select an option on the slicer you can have your chart update to show the result you want to see in the chart. I blogged about this in 2014 here.
The switch measure has a drawback, though: you can only have one number format, so Matt has a new solution using calculation groups.
Comments closedThomas Rushton has a function for us:
(This follows on from my previous script about emailing SQL Job ouput.)
There are times when a SQL server scheduled task needs to look at the output from the previous step, and make decisions based on that – particularly when parsing output from noisy/chatty scripts.
I have, therefore, put together a quick and dirty script to check the output from a SQL Server job step, and pull that into a string, so that it can be examined and a script can then make decisions about what to do next.
Read on for the function definition as well as a few notes on its usage.
Comments closedGilbert Quevauvilliers shows how we can display the last several days as column headers:
I find I do love a good challenge and I find that I get them frequently. I also enjoy sharing what I have learnt with others.
In this blog post I am going to show you how I found a way to create Dynamic Date Column Headers for Tables or Matrixes in Power BI.
Below is what it looks like once completed. What I did was to create a matrix with the last 5 Days (Showing each date for the last 5 days) and then along with this an MTD calculation which shows not only the header of MTD but it includes the current months values.
This is an interesting one for sure. Read on to see how Gilbert solved the problem.
Comments closedBert Wagner takes us through writing recursive statements in T-SQL:
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve.
This post shows one solution for finding all records that are related, either directly or via intermediate records, using recursive queries in SQL Server.
When you know the data size will be fairly small and performance isn’t critical, recursion can be an elegant solution to a data access problem.
Comments closedGrant Fritchey takes us through a question:
I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events.
The answer is, well, sure, we can do that. However, as with all things, there may be wrinkles worth being aware of. Let’s examine this.
Do check out the comments as well.
Comments closedArun Sirpal takes us through one method for improving performance in Azure SQL Database:
One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP based workloads. This means that there is no reason why you cannot point users to these databases via tools such as Power BI as highlighted below.
But there are some things to keep in mind, as Arun points out.
Comments closed