Designing Databases for Distributed Systems
Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.
2023-10-18
Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.
2023-10-18
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
2023-10-18
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
2023-10-16
Find out how good database design is essential to ensure data accuracy, consistency, and integrity and that databases are efficient, reliable, and easy to use.
2023-10-16
This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB
2023-10-13
917 reads
Microsoft has built an amazing platform with Azure SQL Database and has recently announced an offer to use this for free. Read about the capabilities and options with this cloud database platform.
2023-10-13
2,989 reads
2023-10-13
Learn how you can parse a series of parameters that are passed in a string of tuples, meaning pairs, of values and preserve order without using STRING_SPLIT with the ordinal parameter.
2023-10-11
2,190 reads
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.
2023-10-11
This article shows how GENERATE_SERIES can be used with a few practical examples and a warning on parameters.
2023-10-09
10,327 reads
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers