Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
In this next article, we look at creating balanced dimensions on demand.
Sometimes, Troubleshooting Is Hard
I hop in the Jeep the other day and turn on my ham radio. Have I mentioned I'm a licensed amateur radio operator? Yeah, yeah, I know. I won't shut up about it. Ha! My call sign is KC1KCE. I haven't been on HF in a while, but I'm regularly on the air locally here […]
Cassandra Springboot Integration With Redis
Article Overview In this article we will learn how to integrate a Spring boot application with Apache Cassandra database and Redis cache. This is an extension to one of our previous articles which demonstrates the steps to set up Apache Cassandra and how to integrate is with Springboot, link shared below. https://www.sqlservercentral.com/articles/cassandra-springboot-integration In this tutorial […]
People Make Odd Choices
One of my favorite things about going to in-person events is just the time when we're sitting around chatting, out in the hallway, over at the vendor booths, maybe in the speaker room. Any of them. Inevitably, you start to get what I would call "sea stories" (Navy & Coasties, "war stories" for the pickles, […]
SQL Server 2022 Clusterless Distributed Availability Group
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
Navigating Multi Platform Realities in My Database Life
Working across Oracle, SQL Server, PostgreSQL, and MySQL, I've learned that the real challenge isn’t just knowing each platform, but understanding the subtle differences in terminology, syntax, and mindset, and staying open to learning on the fly every time I jump in. The “Sacred Six” are rules that I’ve learned to live by and accept. […]
Formatting Dates and Times: The SQL Dialect Divide
If you’ve ever had to format dates and times in SQL, you’ve probably come across one of the most jarring realities of working across platforms: every major RDBMS does it differently and sometimes confusingly. What’s a TO_CHAR() in Oracle becomes FORMAT() or CONVERT() in SQL Server, and its sort of the same in PostgreSQL… but […]
Revolutionizing Efficiency: The Power of Custom Automation Software Development
With the ever-increasing pace of the digital era, companies are continuously looking for opportunities to enhance efficiency, cut costs, and optimize operations. The most viable way to accomplish these is through Custom Automation Software Development.
SQL Server and AI: Integrating Machine Learning Services
Get a quick glimpse of using AI in SQL Server by implementing a machine learning system.
Cloning Master Admin User Permissions in Amazon RDS for SQL Server with Fine-Grained Control
This article explores how to securely clone the master user permissions in Amazon RDS for SQL Server using a custom stored procedure, usp_rds_clone_login. It outlines a step-by-step process to generate, review, and apply a script that replicates server- and database-level access from the master user to a new login without directly exposing elevated credentials. The guide emphasizes the principle of least privilege, supports named account management, and enables transparent, auditable permission handling for DBAs and applications. Designed for secure and scalable environments, this solution enhances operational security while maintaining administrative flexibility in Amazon RDS.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCP Pondok Bambu Tlp:0821-8200-233
Telp/WA 62 821-8200-233 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blk A/5-6, RT.2/RW.2, Wil,...
Alamat BCA KCP Klender Telp:0821-8200-203
Telp/WA 62 821-8200-203 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren...
Alamat BCA KCP Pulogadung Trade Centre Tlp:08218200174
Telp/WA 62 8218200174 Kw. Industri Pulogadung, Jl. Raya Bekasi Km. 21, Ruko No.A2/18-19, RW.3,...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers