A Fine Slice Of SQL Server
Imke Feldmann continues a series on M functions:
Excel’s FV function returns the future value of an investment based on a constant interest rate. Like for the PV-function, I could use the calculation logic from Greg Deckler:
Read on for the script and explanation.
Comments closedAnthony Nocentino operates a Mac:
Last week I purchased a shiny new MacBook Air with an M2 processor. After I got all the standard stuff up and running, I set out to learn how to run SQL Server containers on this new hardware. This post shows you how to run SQL Server on Apple Silicon using colima.
Colima is a container runtime that runs a Linux VM on your Mac. This Linux VM runs using the Virtualization framework hypervisor native in MacOS. Your containers will run inside this virtual machine.
Read on to see what you’d need for the task.
Comments closedMuhammad Asad Iqbal Khan takes us through one of the classifier options available to PyTorch:
While a logistic regression classifier is used for binary class classification, softmax classifier is a supervised learning algorithm which is mostly used when multiple classes are involved.
Softmax classifier works by assigning a probability distribution to each class. The probability distribution of the class with the highest probability is normalized to 1, and all other probabilities are scaled accordingly.
Read on to learn some of the properties of the Softmax classifier, as well as how you can use this for multi-class classification in PyTorch.
Comments closedAshish Chaudhary does a bit of swapping around:
In this blog, we will be talking about Spark RDD, Dataframe, Datasets, and how we can transform RDD into Dataframes and Datasets.
At this point, most of the libraries I know of accept and produce DataFrames. Occasionally you might need to “downshift” to an RDD to work with some specialty library. But in the event you do have one but want to get to another, Ashish has you covered.
Comments closedAjay Dwiveldi does some digging:
In the above dashboards, I could clearly notice PAGELATCH_** wait at the top along with SOS_SCHEDULER_YIELD. The presence of the above 2 waits is indicative of high CPU issues due to contention on the access of data file pages. I validated and found that this PAGELATCH_** wait is present almost all the time on the server. So decided to check the data of dbo.WhoIsActive that stores captured data of sp_WhoIsActive in SQLMonitor tool.
Read on for the outcome.
Comments closedJose Manuel Jurado Diaz collects a compendium of errors:
1) pyodbc.Error: (‘HY000’, ‘[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)’)
This error ocurrs when the Python code is trying to open a new cursor when we have a previous one with results.
Read on for examples of the problem and solutions for each.
Comments closedImke Feldmann has a function for us:
Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s start collecting some fodder for it, by creating a function to calculate the Present Value (PV) for Power Query:
Click through for that function, as well as an explanation of what it’s doing.
Comments closedIn this article I’ll outline a simple pipeline that trains a regression machine learning model and saves it to a file for use later on. We’ll look at how to load the model using F# and use it to generate new predictions for new data points.
To round things out, I’ll be showing you how to do this all in a Polyglot Notebook, though you can skim over this aspect of the experiment as almost all of the code will work just fine in a normal
.fsfile outside of Polyglot Notebooks.
At the end, Matt mentions that the F# code looks a whole lot like C# code and that’s my biggest problem with the library: it forces you into writing C#-style code.
Comments closedFor this instance, we will setup an alert and action to determine and send out a notification when a Virtual machine has been stopped and also could be restarted whenever such conditions has met.
1. Firstly, Go to search pane on the Azure portal search monitor, click on alert inside monitor and create an alert rule. Further, specify a scope for what you want to setup alert. On this occasion, I am setting it for virtual machine.
Read on to learn more about what Azure Monitor does, as well as the steps to set up an alert and an action.
Comments closedAnother important event for the DAX world has been the release of DAX Studio 3, with an important restyling of the user interface and user experience.
After two years, the composite models – whose official name is DirectQuery for Power BI datasets and Analysis Services – are still in preview. General availability should probably happen in 2023. In the meantime, the feature has been refined and improved. At SQLBI we also released new content about this topic.
Click through for info on eight new DAX functions, as well as what Marco and Alberto have been doing all year.
Comments closed