In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]
Poor data quality significantly hinders large enterprises from deriving meaningful value. The variety of data is a crucial factor to account for when assessing & rectifying data quality, as diverse data types introduce unique challenges in maintaining accuracy and consistency. Good data quality and integrity are essential for accurate insights, good decision-making, and potential success of large enterprises. Inconsistent, incomplete, and inaccurate data significantly affect business operations, customer satisfaction, and financial performance. SQL provides robust functions to proactively identify and resolve these data quality issues, ensuring accurate, reliable, and consistent data for reporting and analysis.
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.
This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.
Join us on February 12th for the livestream: Navigating the Database Landscape in 2025: Simplifying Complexity. Discover the latest trends and insights from our 2025 report, learn new approaches for professional development, and gain valuable knowledge to stay ahead in your career.
I set up a local AI LLM to run and then conducted some experiments. This post shows a bit about the experiments and a little code. The setup is on my blog using Docker to containerize an Ollama LLM, which you can read about. The Basic Setup If you read my blog, I downloaded an […]
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
How it is implemented? I have installed, tried, it is free for dbs <=30...
Comments posted to this topic are about the item Technical Pain Behaviors
Hello, trying to call a powershell file I created, locally on the server, but...
What does the BIT_COUNT function do in SQL Server?
See possible answers