Erik Darling has a video for us. There’s no graf for me to use as a lead-in quotation, which is why I haven’t been linking to a lot of the videos. Erik’s putting out a lot of great video content and this is no exception, so check it out.
Comments closedCurated SQL Posts
Adi Eldar improves ADX visualization:
Azure Data Explorer (ADX) supports various types of data visualizations including time, bar and scatter charts, maps, funnels and many more. The chosen visualization can be specified as part of the KQL query using ‘render’ operator, or interactively selected when building ADX dashboards. Today we extend the set of visualizations, supporting advanced interactive visualizations by Plotly graphics library. Plotly supports ~80 chart types including basic charts, scientific, statistical, financial, maps, 3D, animations and more. There are two methods for creating Plotly visuals:
Read on to learn more about those two methods.
Comments closedKevin Wilkie does some winter cleaning:
Sometimes, in Snowflake as well as in SQL Server, you’re forced to delete data. Hopefully, you’re not deleting from the main table of a database in Production, but that is definitely one way to wake up in the morning.
The syntax starts off as similar to T-SQL but there are a couple wrinkles in there as well.
Comments closedDavid Fowler has a table for us:
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server.
SQL can encrypt our data at a number of different levels and gives us a quite a few options when doing so. I want to use this post to put together a matrix so you can easily see which method of encryption suits your purpose. I’ll look in to each method in more detail in a future series of posts.
Click through for a rather comprehensive table and remember that “several of these all at once” is usually the correct answer for which to choose.
Comments closedSebastian Sauer compares all values across a row:
Sometimes is is neccessary to compute functions, such as mean values, rowwise, ie., summing the values for multiple variables (
my_vars) for each observation.
It’s actually pretty easy, and applies to functions other than mean(). Click through for a demonstration.
Robert Cain continues a series on KQL:
Business Analysis is becoming mainstream in today’s corporate world. A big part of that analysis is done with pivot tables. Think of an Excel spreadsheet where data is organized into rows and columns.
The
pivotplugin will take one data column from your query, and flip it to become new columns in the output data grid. The other column will become the rows, and an aggregation function will be at the cross section of the rows and columns, supplying the main data. You’ll get a better understanding through the demos in this post.You may be wondering “plugin? What’s a plugin?”
I did, in fact, wonder. And Robert explains what a plugin is, as well as examples of how to pivot.
Comments closedAmit Khandelwal combines a bunch of things together:
One of the new features introduced with SQL Server 2022 is the ability to connect to any S3-compatible object storage and SQL Server supports both Backup/Restore and data lake virtualization with Polybase integration. In this blog, we will demonstrate both of these features for SQL Server 2022 Containers running on Kubernetes. As usual, I will use the Azure Kubernetes Service as my Kubernetes environment
Most of the work is in the container configuration, which is good on net, as it means you only have to do it once.
Comments closedTom Zika gets spun around a bit:
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me. The database ids were off by one, and I couldn’t find some query hashes in the Query Store, even when they were supposed to be there. So my first thought was that I must be connected to a different server with a drift. But the information in the SSMS tab, status bar and even colour coding (courtesy of Redgate’s SQL Prompt) – all pointed to the correct server.
I don’t think I’ve ever run into this before but could see how it’d be really confusing.
Comments closedMarco Russo and Alberto Ferrari bust out the oscilloscope:
Finding errors in DAX measures has always been difficult because a single DAX measure produces different results in different cells of the same report, and we do not have a direct way of executing the code step by step in Power BI. This article describes four techniques to find an error in a DAX formula: we start with variable manipulation that does not require any external tool, and then we see how to leverage features available in DAX Studio, DAX Debug Output, and Tabular Editor 3.
Do check this out, especially if you spend a lot of time writing DAX code.
Comments closedDennes Torres gives us a warning:
While making some CETAS tests, I discovered an interesting new behaviour. The following error message was displayed and it was very strange:
Msg 16539, Level 16, State 1, Line 1
Operation failed since the external data source ‘https://euwe01devqigsa01.blob.core.windows.net/dennes/filescsv/’ has underlying storage account that is not in the list of Outbound Firewall Rules on the server. Please add this storage account to the list of Outbound Firewall Rules on your server and retry the operation.
Read on for the cause of this error message.
Comments closed