A Fine Slice Of SQL Server
Pallav Gupta explains what a closure is:
Objects are more flexible for certain use cases because they carry both data members and member functions, whereas a function does not have data members.
So if there is a requirement to pass data members along with functions, How will we achieve it in functional programming ?
The answer is yes, we can achieve it using a closure and a free variable.
Read on for an example.
Comments closedBenjamin Smith updates an R package:
The
mapBlisspackage is a R package which I developed which allows for users to make custom souvenir quality maps of their flights, road trips and favorite cities by utilizing the power of theleafletand other R packages (for a full list, see the Github README here). The goal of the package is to imitate the visualization and print-ability of maps produced by businesses like Atlas.co(my original inspiration), TheLittlePen, Mapiful and MaptracksMe (among many other such businesses).
It’s an interesting-looking package.
Comments closedNicky van Vroenhoven troubleshoots an error:
2 weeks ago I talked about A No-Code Method to Refresh One Table From a Power BI Dataset in the Service. I recently ran into an error using this method, so I thought it was worth sharing this error, and the solution 😀, with you.
Read on to see what causes the error and how you can sidestep it.
Comments closedJose Manuel Jurado Diaz writes a program:
Today, I worked on a service request that our customer is looking for all blocking issues that is happening in their database. We have many articles about it Lesson Learned #22: How to identify blocking issues? – Microsoft Community Hub and in Diagnostics Settings and QDS we can collect this information but all points to that we cannot see the TSQL that is blocking and TSQL command that is blocked in an easy way. In the following script that I share as a script example we could take this one.
First of all, please, remember that a blocking issue is normal and fundamental for any RDBMS. This script is basically when you need to understand what is happening to improve or reduce this.
I was a little surprised the answer wasn’t to use Extended Events, though this does work if you simply need something to run in ad hoc scenarios.
Comments closedAaron Bertrand gets into the whats and wherefores:
Like many companies, Stack Overflow is trying to get out of the business of running our architecture in our own data centers; instead, we want to offload some of the more mundane parts of system administration to a cloud service offering like Azure.
I’m going to cut to the chase for the purpose of this article and concede we’ve already decided on Azure for the majority of our infrastructure and, most importantly to me, our databases.
Click through to learn what their plan is and why Aaron & co went that particular route.
Comments closedJeffrey Wang shares a few tips to avoid issues with window functions in DAX:
Several people had reported running into errors when trying the window functions on fact tables. Let’s look at an example by first adding a calculated table of three columns to the model that is defined by the following DAX expression, and then, add all three columns to a table visual as shown in Figure 1.
Read on for more. This is an area where expected behavior does differ from what you get with window functions in T-SQL.
Comments closed