Managing Incidents and Fighting Fires
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
BIT_COUNT in SQL Server
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
Power BI Best Practices
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
Are You Working More Hours?
AI is causing some people to work more, which seems at odds with the idea of what AI should be: a useful tool.
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
As database changesets accumulate over time, they gradually become more than deployment artifacts. This level explores how a well-organized changeset library evolves into a replayable representation of the database’s structural history, supporting not only reliable deployments but also reconstruction, auditing, and long-term maintainability. Through practical examples and a real-world case study, it shows why maintaining coherent Create and Rollback scripts continues to provide value long after a successful production deployment.
T-SQL in SQL Server 2025: REGEXP_LIKE
This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().
The best AI developer tools in 2026: from coding agents to code review
AI developer tools have matured fast. In 2026, most engineering workflows touch at least one AI coding agent, code reviewer, or research assistant — but the right combination depends heavily on your team size, codebase, and tolerance for setup overhead. This guide breaks down the tools actually worth using across three categories: research and architecture, day-to-day development, and code review, based on real, hands-on experience.
Advanced T-SQL: Replacing Slow Cursors with Window Functions
This article looks at replacing a cursor with a window function to improve performance.
Finding Bad Queries
Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat Kontak BCA KCP Bone Telp:(08218154392)
WA CS 08218154392 Jl. Jend. Ahmad Yani No.169, Watampone, Kec. Tanete Riattang Bar., Kabupaten...
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers