Practical AI
An AI workflow follows a designed sequence of steps. An AI agent has more freedom to choose actions or tools as it works toward a goal. The right choice depends on how much uncertainty and autonomy the task actually needs.
Slide 1 of 4: AI Agents vs AI Workflows: What Is the Difference?
Technical notes on databases, SQL, systems, and the decisions behind their day-to-day operation.
5 articles
SQL Server Administration
A login gets an identity into the SQL Server instance; a database user represents that identity inside a database. Confusing those two layers causes many common security and migration problems.
4 min read
SQL Server Administration
Recovery model is not just a setting to change when the transaction log grows. It controls how SQL Server manages log information and what kinds of recovery are possible. Choosing the model should follow business recovery requirements.
4 min read
SQL Server Administration
A full backup, differential backup and transaction-log backup do different jobs. Understanding the relationship between them is more useful than memorizing definitions because recovery depends on the sequence you can actually restore.
5 min read
SQL Server Administration
A SQL Server DBA does much more than run queries. The role combines data protection, access control, monitoring, troubleshooting, automation, maintenance and careful change management. Here is what the work looks like when databases support real applications.
6 min read
SQL Server Administration
Becoming a SQL Server database administrator is not about memorizing commands. A good DBA learns how SQL Server works, how to protect and recover data, how to manage access, and how to investigate problems without making them worse. This roadmap explains what to learn and in what order.
7 min read
