Basic Git for DBAs: the Basics of Branches
Learn what a branch is in git and how you can create these, share them, and begin working with copies of your code.
Basic Git for DBAs: What's a Pull Request?
Steve continues his series on Git for DBAs by looking at code review and pull requests.
Moving Away From MySQL
A developer has some harsh things to see as he leaves the MySQL team. Is he right?
Flyway Branching Walkthrough
We'll step through the process of using Flyway Teams to support database branching and merging, where the team split the development effort into isolated, task-based branches, and each branch has its own development database.
Oracle subquery caching and subquery pushing
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.
Document yourself out of a job
Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]
The Backlog
A backlog is important for software development, and Steve has a few thoughts on how to add things to the backlog.
Ordering a result set in SQL Server
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.
Registration is now open for Summit 2022
Now’s the time to save your seat at the world’s largest hybrid conference for data platform professionals, taking place November 15-18! Join attendees from around the globe who are gathering in-person and online for a full week of world-class training, networking, and data-platform focused events. Register today to take advantage of discounted launch pricing, available for a limited time.
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392
WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
ALAMAT BCA KCU RAWAMANGUN Telp:08218154392
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers