SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling
This article shows how one can use SSIS to find differences in SAP.
2022-10-31
2,080 reads
Uncategorized
SQL Cheat Sheet for Basic T-SQL Commands
In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.
2022-10-31
Friendship and Your Career
PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up […]
2022-10-29
131 reads
SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more
In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.
2022-10-28
10 Considerations for a Database Migration to AWS RDS
This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.
2022-10-26
3,602 reads
The Work of Work
Meeting are work, even though we sometimes don't think of them as a productive part of our job.
2022-10-19
190 reads
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
10,066 reads
SQL Server Internals: Reading Pages
The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.
2022-10-17
2022-10-14
8,278 reads
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
2022-10-08
158 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers