Showing posts with label Artificial Intelligence in sql server. Show all posts
Showing posts with label Artificial Intelligence in sql server. Show all posts

Monday, January 26, 2026

Databricks in Early 2026: Advancements and AI-Driven Innovations

 We will the key advancements and AI-driven innovations within the Databricks Data Intelligence Platform as of late January 2026. The updates focus on unified management, AI agent extensibility, enhanced governance, and the seamless integration of transactional and analytical workloads. These releases emphasize usability improvements, security enhancements, and deeper AI capabilities, building upon the foundation laid in late 2025.

Unified Lakebase Management: A Streamlined Experience

The introduction of the Lakebase App, accessible through the apps switcher in the Databricks UI, marks a significant improvement in usability. This unified interface consolidates the management of both Lakebase Provisioned and Lakebase Autoscaling instances, streamlining the previously cumbersome workflow that required navigating through the Compute tab in the Lakehouse UI.

Lakebase, Databricks’ fully managed PostgreSQL-compatible OLTP database, now offers a more intuitive project-based structure. This enhancement simplifies the process for developers and data teams to handle transactional data alongside analytics, eliminating the need for complex ETL pipelines. Billing for Lakebase Autoscaling commenced in January 2026, following a free exploration period in late 2025. Key features include autoscaling compute, scale-to-zero functionality, database branching, and instant restore capabilities.

Databricks Runtime 18.0 Goes Generally Available

Databricks Runtime 18.0, including its Machine Learning variant, achieved general availability in January 2026. This runtime, powered by Apache Spark 4.1.0 and utilizing JDK 21 as the default (an LTS release), incorporates a range of bug fixes, security patches, performance optimizations, and library upgrades.

Notable behavioral extensions include the application of time travel and VACUUM changes to serverless compute, Databricks SQL, and Unity Catalog managed tables across supported runtimes. These updates ensure consistent data management across diverse environments.

AI/BI and Genie Enhancements for Better Collaboration

The AI/BI suite, which includes Genie (the conversational analytics tool), has received several usability enhancements designed to improve collaboration and efficiency:

  • JSON handling in tables: Objects now remain expanded during copy-paste operations, simplifying data manipulation.
  • Parameterized defaults for catalogs and schemas: This feature is available in dashboard deployments via Databricks Asset Bundles, enabling greater customization and control.
  • Multi-select filter improvements: Pasting comma- or newline-separated values is now easier, streamlining the filtering process.
  • Enhanced question categorization in Genie: The accuracy of Genie has been improved for common query patterns such as top-K queries, percentages, and distributions.
  • Default Consumer access for new users: Administrators can now set this via group cloning, granting view-only access to dashboards, Genie spaces, and apps. This is particularly useful for business users who require access to insights without the ability to create objects.

Furthermore, Databricks Assistant now supports custom agent skills for domain-specific tasks in agent mode, adhering to the open Agent Skills standard. These skills load automatically when relevant, significantly extending the Assistant’s capabilities and making it more adaptable to specific business needs.

Knowledge Assistant became generally available in select US regions (for non-enhanced security workspaces), offering connectors for popular platforms like Google Analytics, Salesforce, and ServiceNow. Row filtering has been added to managed connectors, allowing users to ingest only the necessary data via SQL-like WHERE conditions, optimizing data transfer and storage.

Security, Governance, and Model Serving Updates

Several updates have been implemented to enhance security, governance, and model serving capabilities:

  • Automatic email notifications for expiring personal access tokens are now generally available, providing proactive security measures.
  • Mosaic AI Model Serving has added support for hosted OpenAI GPT-5.1 Codex Max and Codex Mini models, which are specifically optimized for code-related tasks.
  • Delta Sharing continues to evolve with the introduction of recipient-specific URL formats and one-year token expirations, enhancing security and control over shared data.
  • AI/BI Genie and Databricks Assistant are now generally available on AWS GovCloud (including DoD environments), ensuring secure, government-compliant AI-powered workflows.

Looking Ahead in 2026

The Data + AI Summit 2026 is scheduled for June 15–18 in San Francisco, and the call for proposals is already open. Major announcements are anticipated regarding AI agents, multi-model governance, and lakehouse expansions.

Meanwhile, legacy features such as Community Edition were retired on January 1, 2026, with users being directed to the perpetual Free Edition. Legacy dashboards have been fully phased out, encouraging teams to transition to modern AI/BI tools.

These updates collectively reflect Databricks’ ongoing commitment to building a more integrated, AI-native platform. The platform aims to empower data teams to build production-grade agents, unify OLTP and OLAP workloads, and provide business users with trustworthy insights, all while maintaining centralized governance through Unity Catalog.

For the most up-to-date details, please refer to the official Databricks release notes, as rollouts are staged across AWS, Azure, and GCP.

Wednesday, June 20, 2018

Artificial intelligence with SQL Server

D
ata is the business asset for any organisation which is audited and protected. To gain in their business, it is become very urgent for every organization to choose few good predictive data models and validates them using test data before figuring out an operationalization plan for the model to be deployed to production so that applications can consume it.
It is true the data and artificial intelligence is growing with each other and we have to do agree that database platforms were just using for the fundamental operations on data in the from of queries or CRUD operations as well as some basic computation routines not more than that.  With built-in R and Python support in SQL Server 2017 release, SQL Server is in a unique position to fuel innovations that database professionals and developers can co-create with the data science and AI communities. The possibilities are endless.


In the current era, Machine Learning is very fast growing field because it is used when searching the web, placing ads, credit scoring, stock trading and for many other applications. With the help of new technology called Artificial intelligence (AI), we are looking at an incredibly exciting time for marketing and customer experience, with huge benefits for the consumer and faster than real-time customer service.
AI services will transform how we all interact with media; by understanding our needs ahead of the game, it will change our lives. By entering in conversation directly with a company, and receiving a directly personalised service in return, we will feel that we are being really taken care of as individuals.

Artificial intelligence is reliable on the huge data which is coming from the heterogeneous sources and we never denied that data movement is very costly for any organisation. By doing data science and AI where the data resides, there are many benefits. These include being able to take advantage of the enterprise-grade performance, scale, security and reliability that you’ve come to expect from SQL Server over the years. The most important benefit is that we can eliminate the need for expensive data movement.
By encapsulating the machine learning and AI models as part of the SQL Server stored procedure, it lets SQL Server serve AI with the data. There are other advantages for using stored procedures for operationalizing machine learning and AI (ML/AI).
That why, Microsoft development team has, arguably, built the most complete Machine Intelligence (MI) technology suite in the market. The list of Microsoft’s MI technologies includes advanced platforms such as Azure ML or R Server, Artificial intelligence APIs such as Microsoft Cognitive Services, data visualisation tools such as PowerBI or even vertical solutions included in the Cortana Intelligence Suite. 
In addition, if the data science project involves working with spatial data, non-structured,  temporal data or semi-structured data, we can leverage SQL Server capabilities that let us do this efficiently which takes important steps to bring new MI capabilities to the traditional database platform. 
Most companies already possess reams of data that is not being used; they need to put it to work. Data, analysed by MI/AI, can be used to develop products and services based on patterns and trends of customer behaviour and preferences. In future, we are going to see MI/AI algorithms becoming as common as data access operations in database servers. Microsoft is in a unique position to lead this new trend but we should expect similar moves by competitors such as Oracle, IBM or newcomers such as MongoDB or Couchbase.

For businesses that are small or failing in the current environment where big players take all, AI/MI could provide a real advantage over the competition – these companies need to engage with it now, and fast, to make the best of this advantage.
Conclusion
SQL Server supports Python and R which will allow developers to implement MI/AI models that natively process data stored in SQL Server databases. Those MI/AI models can be directly persisted in the underlying database servers and scaled as part of SQL Server clusters. More importantly, developers will have access to these capabilities using the familiar SQL Server tool set.

Monday, November 6, 2017

What is Engineering data

Engineering data is the foundation for all of the recent, current, and future data hypes: machine learning, deep learning, big data, data science, etc. The success and adoption of these hypes is predicated on data being structured properly and available. However, when customers (internal and external) are not clear on what their expectations are and/or the big picture of what they are trying to use the data for, data engineers are often blamed. 

Machine learning is a method used to devise complex models and algorithms that lend themselves to prediction; These analytical models allow researchers, data scientists, engineers, and analysts to produce reliable, repeatable decisions and results.

Communication is key! Couple of points, "big data" has always been there, just ask Statisticians, as for the data science hype, now every one calls themselves data scientist, somehow knowing SQL makes a person data scientist now. Data Science graduates on a daily basis and many are lacking basic analytical skills and believe Data Science and Data Analysis are all about having basic end-user level knowledge of a new fancy software. It is a hype for a fact.
We can have the best people using the data for analytics or modeling, but if we don’t have people that know how to build the systems to make our data available in a consistent reliable manner then you will just be part of the hype. Having multiple data science teams leads to friction between the teams. While they, mainly concerned about product delivery, has an open door policy across the Enterprise, the other, more concerned about, well we don't know what, treats everyone else with a sense of superiority and thinks that their work is super secret somehow.

The reason for it's crashing is most likely because the software you are using is not a sever software/service, eg. if you use excel everything is processed in memory(like MS products is doing it all the time) if you had a db then it had been paging to disk when then the assign memory get full (short cut explanation).  

My understanding of Data scientist is they try to hard code/program different scenarios to get an answer.  If you know some about philosophy you cans tart there. You say what if condition 1 =1, then they add different condition with different variables.  It's not actually that complicated from my understanding. 

The data science hype now is focused on AI. After the dust settles they will realize that not all big data and data science is what's going on in Google or Facebook. Corporate needs another big data and data science. They need to make sense of their own data and solve their own problems using whatever techniques. I believe Optimization and statistical models are more important than AI for most of corp-orates. They can buy the hard stuff like speech and text analytics from Google or Amazon or anyone of this scale and capacity. Yet they have to retain a team to solve their specific problems using science.

That the industry does not want to reveal the pressing questions they want to get answered - obviously due to competition and conflict of interest. There are some good concepts behind data science and modeling (both mathematical and statistical) lies at the heart of obtaining directed insights. But yes, academia-industry partnership is very much lacking, which has the potential to make data science a hope or a hype.