A Fine Slice Of SQL Server
Two Of My Favorite NOLOCK Demos from Paul White and Aaron Bertrand
Erik has covered transaction isolation levels lately in videos. The first demo from Paul White shows an issue where queries stop scanning due to data movement. The second demo from Aaron Bertrand comes from this blog post.
Comments closedSteven Sanderson does the math:
Data transformation is a fundamental technique in statistical analysis and data preprocessing. When working with R, understanding how to properly transform data can help meet statistical assumptions, normalize distributions, and improve the accuracy of your analyses. This comprehensive guide will walk you through implementing and visualizing the most common data transformations in R: logarithmic, square root, and cube root transformations, using only base R functions.
Click through for examples.
Comments closedTomaz Kastrun wraps up a series on Azure AI. First up is tracing in Azure AI Foundry:
Tracing is a powerful tool that offers developers an in-depth understanding of the execution process of their generative AI applications. Though still in preview (in the time of writing this post), It provides a detailed view of the execution flow of the application and the essential information for debugging or optimisations.
After that, we can see how to evaluate model results:
With evaluation you performing iterative, systematic evaluations with the right evaluators and measure and address potential response quality, safety, or security concerns throughout the AI development lifecycle, from initial model selection through post-production monitoring.
With the Evaluation in Azure AI Foundry, you can evaluation the GenAI Ops Lifecycle production. In addition, it also gives you the ability to assess the frequency and severity of content risks or undesirable behavior in AI responses.
Finally, Tomaz wraps up the series with some notes on documentation:
Documentation and material for Azure AI Foundry are plentiful and growing on a daily basis, since the topic on AI and GenAI is evermore so popular.
I appreciate the challenge that Tomaz has of putting together 25 blog posts in a month, especially when they’re all tied to a single theme.
Comments closedVitaly Bruk works through an issue:
High allocated unused space is storage assigned to a SQL Server table that isn’t used. This condition often indicates internal fragmentation. Free space is present within allocated pages. Such fragmentation leads to inefficient storage and can degrade database performance.
Read on for an explanation of the issue, followed by a real-world situation whose ultimate cause was bulk insert operations.
Comments closed