I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a minimum (say, 2-3), and don’t try to do something really slow like fire up a cursor, triggers can be an efficient way to solve hard problems quickly. However, most triggers I run across have a really, really dangerous bug.
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
Cosmos DB is Microsoft’s highly scalable, NoSQL database platform running in Azure. It supports four API models, including Key-Value pair and Documents. Pushpa Sekhara provides an overview of Cosmos DB, including some best practices to improve performance.
Today we have a guest editorial from Andy Warren, looking at learning.
In this series of tips we will look at different ways using temporary data in SQL Server along with examples. In this first part we will cover some reasons for doing this and different types of temporary data stores.
Steve Jones talks about careers, and where you might take your career over time.
Data imports represent some of the more commonly performed database management tasks. Learn about a number of traditional SQL Server data import techniques that you can leverage when importing data into Azure SQL Database.
After installing Microsoft Teams, Steve has a bit of communication overload.
Got a favorite story of unusual, unique, or inspired attempts at data privacy. We'd love to hear them on DBAle's data privacy contest. Share your story for the chance to win a box of beer and the glory of getting your name on DBAle
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Ruko Srondol Square, Jl. Setia Budi No.147 Blok 5 & 6, Srondol Kulon, Kec....
Komplek Ruko Cikarang Square, Jl. Raya Cikarang - Cibarusah No.B12, Pasirsari, Cikarang Sel., Kabupaten...
Jl. Margonda No.88 A-C, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers