SQL Server Management Studio<\/h2>\n\n\n\n
SQL Server Management Studio is one of the most widely used relational database management environments in a business context. It provides features to configure, monitor, and manage SQL Server instances and their respective databases. Starting from version 22, GitHub Copilot was added\u2014a feature that helps write T-SQL more quickly and accurately with AI support. Copilot also answers general SQL questions and assists with administrative tasks directly within the SSMS environment.<\/p>\n\n\n\n The most immediate benefit is contextual SQL suggestions. Copilot recognizes the tables and columns of the connected schema and proposes completions while queries are being written, including relevant filters, possible groupings, and joins that match the data model. For those who write dozens of queries per day, the reduction in effort is considerable.<\/p>\n\n\n\n Copilot Chat also allows questions to be asked directly in the editor. It is possible to inquire about the queries with the highest CPU usage in the last hour, the largest tables by number of records, or how to simplify a specific stored procedure. The responses are contextualized based on what is open in the editor.<\/p>\n\n\n\n There is, however, a limitation to keep in mind: Copilot only accesses the schema and the code, not the data itself. Questions that rely on business context still require human intervention.<\/p>\n\n\n\n Azure Data Factory (ADF) is Microsoft\u2019s cloud-based data integration platform. It enables the construction and orchestration of pipelines that move, transform, and load information between systems, from relational databases to Data Lakes, and from external APIs to data warehouses.<\/p>\n\n\n\n AI integration in ADF occurs through Copilot for Azure Data Factory, available directly in ADF Studio. Unlike Copilot in SSMS, which primarily assists with code writing, Copilot in ADF helps with the design, configuration, and diagnostics of data integration pipelines.<\/p>\n\n\n\n Instead of manually configuring each activity, connector, and transformation, the user describes what they want: \u201ccopy data from a SQL Server database to Azure Data Lake Storage and filter records prior to 2020.\u201d Copilot interprets the request and generates a complete pipeline proposal.<\/p>\n\n\n\n This is especially useful in teams with varying levels of experience. Those less familiar with the platform can produce an initial functional framework and then have it validated by someone more experienced, without having to start from scratch without any reference.<\/p>\n\n\n\n When a pipeline fails, Copilot analyzes the error logs and provides an explanation of the issue, along with recommended steps for its resolution. This capability significantly reduces diagnostic time compared to manually reading technical logs, especially in teams with varying levels of experience.<\/p>\n\n\n\n Snowflake is a cloud data platform designed to store and analyze large volumes of information. What sets it apart from other platforms is the way it incorporates artificial intelligence as a native capability through Cortex.<\/p>\n\n\n\n Cortex runs large language models directly on the data stored in Snowflake, without the need to export, move, or integrate it with external services. It provides native SQL functions that allow AI operations to be performed as if they were regular queries. Sentiment analysis, text classification, entity extraction, document summarization, and translation become accessible directly within a query, with no additional configuration.<\/p>\n\n\n\n Cortex Analyst targets a different user profile. While Cortex is a tool used by technical users to programmatically enrich data, Analyst is designed for those who need answers but are not proficient in SQL.<\/p>\n\n\n\n In practice, a technical user or analyst defines a semantic model over the tables, creating an interpretive layer that maps business concepts to technical structures. From there, any user can query the data in natural language and obtain reliable answers, as the model controls the scope of interpretation.<\/p>\n\n\n\n![\"\"](\"https:\/\/b2f.pt\/wp-content\/uploads\/2026\/03\/image-62.png\")
<\/figure>\n\n\n\nWhat changes in practice?<\/strong><\/h3>\n\n\n\n
Azure Data Factory<\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/b2f.pt\/wp-content\/uploads\/2026\/03\/image-63-1024x424.png\")
<\/figure>\n\n\n\nPipeline Creation<\/strong><\/h3>\n\n\n\n
Monitoring and Diagnostics<\/strong><\/h3>\n\n\n\n
Snowflake<\/h2>\n\n\n\n
![\"\"](\"https:\/\/b2f.pt\/wp-content\/uploads\/2026\/03\/image-64.png\")
<\/figure>\n\n\n\nCortex in Snowflake<\/h3>\n\n\n\n
Cortex Analyst<\/h3>\n\n\n\n
![\"\"](\"https:\/\/b2f.pt\/wp-content\/uploads\/2026\/03\/image-65-1024x576.png\")
<\/figure>\n\n\n\n