(2025-Feb-12) I will jump straight to the problem statement without a “boring” introduction, which, in a sense, already feels like an opening statement.Moving data between two or more endpoints is a common task. Sometimes it’s as simple as migrating data from one place to another. Other times, it’s a request to copy specific documents from source environments. In more complex cases, you might need to consolidate multiple data files into the same destination, such as loading several separate files into a single database table.Image by Bernd Hildebrandt from PixabayLet’s look at a common data scenario where separate data files are used…
Author: drweb
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR columns. By default, ANSI_PADDING is ON, and it plays a significant role in data storage and consistency. In this post, we’ll explore what ANSI_PADDING does, why it matters, and how it affects your database.Why Does ANSI_PADDING Matter?Storage EfficiencyTurning ANSI_PADDING OFF for fixed-length columns can save storage space when trailing spaces are unnecessary.Data ConsistencyKeeping ANSI_PADDING ON ensures predictable storage behavior across different databases.Application RequirementsFor VARCHAR columns, turning ANSI_PADDING OFF prevents unwanted spaces, which might be critical for some applications.Best…
Introduction Do you remember the effort of tidying up your BI and reporting systems, only to find yourself facing a labyrinth of inconsistent data, missing values, and unclear ownership? Now, imagine handing that same data to an AI system tasked with advising your sales team, guiding sales decisions, or generating insights. Would you trust the results? With 2025 poised to be another pivotal year for AI, particularly agentic AI, the stakes are higher than ever. While previous tech trends like Crypto and Web3 turned out to be more hype than substance, generative AI is demonstrating substantial, long-term potential. However, careful planning…
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial intelligence into their operations, eager to unlock efficiency, automation, and data-driven decision-making. But while AI promises transformative benefits, most organizations are far from truly prepared. The difference between success and failure often comes down to governance, strategy, and responsible implementation. According to recent data from Cisco research, half of businesses have allocated 10–30% of their IT budgets to AI initiatives. Yet only 13% feel ready to leverage AI’s full potential. The same sentiment is confirmed by McKinsey research, stating that 91% of respondents doubt their organizations…
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting 2 sessions with Kerry Kolosko and Shannon Lindsay as well as participating in some other data viz fun. You can find session descriptions below. The lineup for this conference looks fantastic whether you are a Fabric enthusiast or more focused on Power BI.If you haven’t registered yet, you can use code LONGORIA200 to get $200 off of your ticket price.Our SessionsIntro to Data Visualization in Fabric Notebooks for the Power BI…
A recent change made to Redgate Monitor to add a new alert for VLF count. This post looks at the change.This is part of a series of posts on Redgate Monitor. Click to see the other postsTracking Virtual Log FilesVirtual Log Files (VLF) are sections inside of your physical log file (.ldf). These have no fixed size or number per file, but there can be many. The architecture of the log is explained in this doc and it varies according to a number of factors.That doc also explains there are issues with too many VLFs inside of a log file.…
Do you write React Native or JavaScript articles and want to be featured in our blog? Reach out to wyatt@reactnativecoach.com and we’ll review your submiReact Native 0.51React Native was tagged with 0.51 this week. You can catch the full release notes here but here are some highlights:New styling rules for padding, margin, and bordervisible-password for TextInput.keyboardType on AndroidPartial rounded border support 👏🏻Learn how to reproduce the Android lock pattern in React Native and Expo from Audy Tanudjaja. Note: If you’ve already ejected from Expo or used initto create your app you’ll want to look for the react-native-svg project to complete…
This article will teach you how to use the Eclipse JKube project to build images and generate Kubernetes manifests for the Spring Boot application. Eclipse JKube is a collection of plugins and libraries that we can use to build container images using Docker, Jib, or source-2-image (S2I) build strategies. It also generates and deploys Kubernetes and OpenShift manifests at compile time. We can include it as the Maven or Gradle plugin to use it during our build process. On the other hand, Spring Boot doesn’t provide any built-in tools to simplify deployment to Kubernetes. It only provides the build-image goal…
This article will teach you how to use SAML2 authentication with Spring Boot and Keycloak. Security Assertion Markup Language (SAML) is a standard for exchanging authentication and authorization identities between an Identity Provider (IdP) and a Service Provider. It is an XML-based protocol that uses security tokens with information about a principal. Currently, it is less popular than OICD (OpenID Connect) but is not outdated yet. In fact, many organizations still use SAML for SSO. In our example, Keycloak will act as an Identity Provider. Keycloak supports SAML 2.0. We can also use Spring Security mechanisms supporting SAML authentication on…
This article will teach you how to use the Spring AI project to build applications based on different chat models. The Spring AI Chat Model is a simple and portable interface that allows us to interact with these models. Our sample Spring Boot application will switch between three popular chat models provided by OpenAI, Mistral AI, and Ollama. This article is the first in a series explaining AI concepts with Spring Boot. Look for more on my blog in this area soon. If you are interested in Spring Boot, read my article about tips, tricks, and techniques for this framework…