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.
Showing 10–18 of 18 articles
Azure SQL
Moving from SQL Server to Azure SQL Database does not remove database administration; it changes where the operational boundary sits. Microsoft manages more of the platform, while the DBA focuses more on data, security, performance, resilience and cost-aware service configuration.
4 min read
SQL Server Performance
An execution plan is SQL Server's chosen strategy for running a query. You do not need to memorize every operator to start using plans; you need to understand the flow, the estimates and the places where work becomes expensive.
5 min read
SQL Server Performance
Blocking and deadlocks both involve sessions waiting on locks, but they are not the same problem. Blocking can be normal and temporary; a deadlock is a cycle SQL Server must break by choosing a victim.
4 min read
SQL Server Performance
When someone says 'SQL Server is slow,' the statement is too broad to fix. The first job is to narrow the symptom, establish what changed and collect evidence before touching configuration.
5 min read
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
