RunAs Radio Richard Campbell

How does artificial intelligence fit in with SQL Server? At the Microsoft Fabric Conference in Las Vegas, Richard sat down with Muazma Fahid and Bob Ward to discuss the AI developments in SQL Server. Muazma talks about SQL Server as a crucial source of data for building machine learning models and the new features added to make SQL Server a key store for vector data and other elements of machine learning. There's also Copilot for Azure SQL Data to help with diagnostics in your databases and to use natural language to write queries - it SQL Server Natural Language Query all over again, but certainly better than ever.

Have you downloaded the latest version of PowerShell? While at the MVP Summit in Redmond, Washington, Richard sat down with Sydney Smith to discuss some of the features in PowerShell 7.4. Sydney talks about the successful delivery of PSResourceGet and PSReadline, two long-in-development features that have reached their so-called "1.0" state. The conversation also digs into the ongoing challenge of some sysadmins sticking with PowerShell 5.1, the last of the Windows-only versions. Today, PowerShell 7 has feature parity with 5.1 and many new features that improve the quality, security, and capabilities of PowerShell. Try the latest!

How can GitHub Copilot help you? Richard chats with Damian Brady at NDC Sydney about the power of GitHub Copilot to help you understand and write the bits of code you need - whether you're using PowerShell, understanding a RegEx expression, or trying to get a Bash prompt right. GitHub Copilot and help to explain the code you've got, even across workspaces - so you can find all the scripts that changes might impact. And if you think it's time to rewrite some old scripts into more modern languages, GitHub Copilot can help with that, too!

As Artificial Intelligence enters our organizations, how do we secure them? While at NDC in Sydney, Richard sat down with Sarah Young to discuss the challenges of securing these new technologies. Sarah talks a bit about the fundamentals - in the end, AI technology is just more software and needs all the same authentication and authorization that other apps need. However, there are some unique aspects and potential exploits that you can address through tooling and education. We're all learning these new AI technologies and how to apply them in our organizations - training is essential!

How can Microsoft Copilot for Security help you? While at NDC in Sydney, Richard chatted with George Coldham about Microsoft Copilot for Security - combining GPT-4 with information about Microsoft security products and your organization's resources in Azure to provide guidance and insight into making your company more secure. George talks about how it's early days for this copilot - and it's only in preview so far. Bringing together the vast array of security products that Microsoft makes, Microsoft Copilot for Security brings the ability of Large Language Models to summarize data to help you understand where the organization's security vulnerabilities exist and how to address them. You want to get in on this preview!

What can GitHub do for you? While at NDC London, Richard chatted with April Edwards about how GitHub can help sysadmins - and everyone in your organization! In the end, GitHub is an engine for managing work, with GitHub Actions kicking off workflows that can send messages, run all sorts of code, activate scripts, and more. Ultimately, you get a good report of what happened - or didn't happen. And over time, those scripts can mature to be more reliable and detailed - and keep a record of every change.