Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Friday 22 December 2023

The art and science of prompting in Copilot for Microsoft 365

Prompt engineering has recently sprung up. It is how you ask a Copilot to do something.  It is like summarizing and explaining what to do. Microsoft have created a set of resources to guide you through the art and science of it.  

The full guide on the art and science of prompting. There are useful featured prompts for generating ideas, help me write an email etc.

The Prompting do's and don't can be found here.

Monday 11 December 2023

Responsible AI - Metaprompt engineering

Metaprompt design is crucial for generative AI applications. 

The process of grounding or retrieval augmented generation (RAG) is the process of grounding your model on relevant context. This grounding can significantly improve the overall accuracy and relevance of the model outputs. 

Azure AI Studio can help you quickly and securely ground models on structured, unstructured, and real-time data, including data within Microsoft Fabric.

'A metaprompt, or system message, is a set of natural language instructions used to guide an AI system’s behavior (do this, not that)'. (see below)

The grounding data should be used by the metaprompt and enforce rules that help stop harmful content generation or user manipulations like jailbreaks or prompt injections.

Summary of responsible AI best practices for a metaprompt

ProMetaprompt engineering techniques

Infuse responsible AI tools and practices in your LLMOps

Watch the 45-minute Introduction to Azure AI Studio course on Microsoft Learn.

Saturday 9 December 2023

Copilot Studio implementation guide

I came across this excellent resource, the Microsoft Copilot Studio implementation guide.  It covers

a 360-degree review of your project covering

  • Project overview
  • Architecture overview
  • Language
  • AI capabilities
  • Integrations & channels
  • Security, monitoring & governance
  • Application lifecycle management
  • Analytics & KPIs
  • Fit-gap & top requests
  • Dynamics 365 Omnichannel 

Guidance and best practices

Reference architecture examples

Download it from https://lnkd.in/d5h-binr 

Friday 8 December 2023

Bath Azure User Group - December Meetup

The second meeting of the Bath Azure User Group  was on Thu, Dec 7, 2023, 6:00 PM - 8:30 PM held at Cloud Direct, The Vaults, 1 Bartlett Street, Bath, England, GB, BA1 2QZ

The December meeting  had an exciting packed agenda:

Unpacking the Ignite Book of News - Richard Cheney, Luke Fussell

Boosting your Azure CLI with OpenAI - Ira Rainey

The Most Valuable Professional Program - Dr Victoria Holt

I talked about the the program helping the community learn and grow and the passion for working with cutting-edge technology.

There lots of Pizza and plentiful Azure discussions.  A fun night.

Monday 4 December 2023

Data Toboggan Winter Edition 2024

We are pleased to announce that Data Toboggan will return for its 4th year on Saturday 3rd February 2024. Our 2 track virtual conference covering covering all aspects of Azure Synapse Analytics and Fabric including Dedicated SQL Pools, Serverless SQL Pools, Spark, Pipelines, Data Engineering, Power BI, Machine Learning, and much more!

Imaged created in https://designer.microsoft.com/

Saturday 2 December 2023

Live view in Microsoft Purview

Live view in Microsoft Purview is in preview. Live view is a place that users with data access permissions can find Azure resources and their data assets in the Microsoft Purview Data Catalog without set-up or scanning.  The metadata of the resources is immediately available when you access the free or enterprise versions of Microsoft Purview. 

There are some limitations for live view for Microsoft Fabric:

  • Personal workspaces aren't supported yet in live view.
  • Only Microsoft Fabric item level metadata are available in live view.
  • Power BI Datasets don’t support showing schema in live view if the item hasn’t been scanned.
  • Dataflow Gen2 (Preview) items are displayed as Dataflow items.

Microsoft Fabric items  that will be available in the Microsoft Purview Data Catalog using live view are: