A Fine Slice Of SQL Server
The
maxandminaggregation functions are common to almost every language, and the Kusto Query Language is no exception. As you would think, when you pipe in a datasetmaxreturns the maximum value for the column name you pass in. Likewiseminreturns the lowest value.In addition, there are variants for each,
maxifandminif. We’ll see examples for all of these in this post.
Click through for a few functions you can call via the summarize operator.
Keeping your R code organised is not as straightforward as one might think. Just think about the libraries, variables, functions, and many more. All these objects can be defined and later rewritten, some might get obsolete during the process.
This process is proven to be even more crucial when you are part of a larger group of engineers, and scientists, who collaborate with you.
Click through for some organizational tips specific to R code.
Comments closedKoen Verbeeck hits a concatenation issue:
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very long, for example if a dimension has a lot of columns. When debugging, I noticed a couple of statements failing with various errors. Turns out, they were truncated after 4000 characters. What was going on?
Read on to see what happened.
Comments closedMatthew McGiffen notes how to restore a database with transparent data encryption:
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if the server hosting our SQL instance goes belly-up, can we recover the data that we have encrypted with TDE?
Click through to learn what you’ll need to have.
Comments closedEvery time a user clicks on a row or a column in a visual, every other visual in the page feels an urge to refresh itself and respond to the click.
Visual that are based on direct query may issue multiple queries for each refresh.
Depending on the number of measures used in the visual, the number of generated queries can be as high as 10 or even more for a single visual.
Read on for more information and what you can do to avoid this problem.
Comments closedMarco Russo and Alberto Ferrari lay out the foundations of window functions:
Window functions by themselves do not increase the expressivity of DAX. Most if not all of the calculations performed with window functions can be expressed with more complex DAX code. The goal is to simplify authoring these calculations and improve their performance.
These new functions also introduce a new concept to the DAX language: “apply semantics”. We will publish more articles about window functions and “apply semantics” over time. SQLBI+ subscribers will get a dedicated video course later this year and already have access to the window functions whitepaper we are currently writing.
Click through for an introduction.
Comments closed