A Fine Slice Of SQL Server
Adam Bertram is spinning in circles:
One of PowerShell’s key features is its ability to loop through data collections, enabling you to execute a code block repeatedly.
In this tutorial, we will explore three fundamental loop structures in PowerShell:
foreach,for, anddoloops.By the end of this tutorial, you will have a solid understanding of how to use these loops to handle repetitive tasks and process collections of data more effectively.
Click through for the tutorial.
Comments closedJon Voege runs into a problem:
A simple comment App embedded in Power BI was supposed to show all the comments in a Sharepoint List which matched the filters set in Power BI. But…. Not all comments were showing up, even though the Sharepoint List only held about 10 comments at the time!
Why you ask? Well, the issue stems from the fact that the table of data being sent from Power BI to Power Apps, the PowerBIIntegration.Data object, has a hard limitation of 1000 rows. And those 1000 rows, is all that we get to work with.
Read on to learn more, as well as a workaround to this issue.
Comments closedTomaz Kastrun continues a series on Azure AI:
Models from the model catalog can be deployed using programming languages or using the Foundry studio.
Model deployment has two types: Deploy from the base model or deploy from the fine-tuned model. The difference is that fine-tuned model is model taken from the model catalog and later tuned to an additional dataset, as the base model is the model as it is available in Azure AI Foundry.
Click through for a bit more information on the process.
Comments closedSandeep Pawar wants to save some money:
File this under a test I have been wanting to do for some time. If I am exploring some data in a Fabric notebook using PySpark, can I switch between Python and PySpark engines with minimal code changes in an interactive session? The goal is to use the Python notebook for some exploration or use existing PySpark/SparkSQL or develop the logic in a low compute environment (to save CUs) and scale it in a distributed Spark environment. Understandably, there will be limitations with this approach given the difference in environments, configs etc., but can it be done?
Read on for the answer, as well as plenty of notes around it.
Comments closedHenrietta Dombrovskaya provides a warning:
I am unsure whether others have this problem, but I find myself explaining the benefits9and what’s not)of partitioning tables in Postgres over and over again.
Most times, developers have unrealistic expectations that if they partition a gigantic table, “it will be faster to select from it.” I always have to explain that the goal and the purpose of partitioning is improving maintenance, not query optimization, and if the execution speed of short queries remains the same as before partitioning, they should consider it a success (yes, there are no rules without exceptions, and there are cases of performance improvement, but those are exceptions indeed).
Henrietta’s example is specifically around Postgres, but it applies to SQL Server all the same: partitioning is primarily a maintenance benefit rather than a performance benefit.
Comments closedHaripriya Naidu gets optimistic:
In this article, we are going to take a look at how write operations block read operations under default isolation level – Read Committed and how to avoid this using the optimistic isolation level – Read Committed Snapshot.
I do wish that this were the default for new databases in SQL Server, like it is in Azure SQL Database.
H/T Brent Ozar’s newsletter for pointing me in Haripriya’s direction.
2 CommentsDenny Cherry triggers an action:
Sometimes, you want/need to have PowerShell do an action, but it’s hard to do through PowerShell, or it can’t be done at all. If the website If This Then That (IFTTT) can do it instead, you can still do it through PowerShell, with a little extra work. The way to do this will be to call a webhook on an IFTTT Applet and pass the information you need to send to the third-party service. A great example of this would be if you need to automate posting a new post to FaceBook. Posting to Facebook is shockingly hard as you have to write all the pieces to post to Facebook manually, and there’s no current way to post to Facebook via PowerShell. However, you can call an IFTTT Action and have that action do the actual posting to Facebook for you.
Click through for a generic form of the process.
Comments closedJustin Bird switches terminals:
I use vscode on a daily basis on macOS. The default terminal is set to bash but I tend to use PowerShell most often. I want to change the default terminal in vscode so that it starts in Powershell.
Click through for the solution, which is fairly easy to implement cross-platform, as long as you swap a little bit (CMD -> CTRL, osx -> windows/linux, etc.).
Comments closedTomaz Kastrun continues a series on Azure AI:
The management center is a part of the Azure AI Foundry portal. It gives you the overview on activities and governance. From management center you can manage Azure AI Foundry hubs, projects, resources, access, endpoints, models and other resources and general settings.
Click through for an overview of the management center and what it includes.
Comments closedSteven Sanderson has no time for missing data:
Data analysis in R often involves dealing with missing values, which can significantly impact the quality of your results. The complete.cases function in R is an essential tool for handling missing data effectively. This comprehensive guide will walk you through everything you need to know about using complete.cases in R, from basic concepts to advanced applications.
Using complete.cases to find observations with missing values is great. Using it to eliminate observations with missing values can sometimes be helpful, depending on just how many missing values you have.
Comments closed