It’s no secret that generative AI is quickly changing how we think about the ways we work. Here is the full transcript of my first conversation with ChatGPT, inspired by a question on one of my Linkedin Learning courses.

There’s been an uptick in the number of people having issues with PostgreSQL and Azure Data Studio lately. Version 15 of Postgres made some internal changes that made it incompatible with the Azure Data Studio Postgres extension, and Microsoft seems to have abandoned the project and is no longer making updates. The transition to Apple Silicon macs has also thrown in some wrinkles if you’re on that platform. Here’s a couple of things to try if you’re having issues.

For the first time, SQL Server 2017 allows users to install the product on Linux. This opens the doors for working with fully-featured SQL Server database engines on MacOS through freely distributable Docker containers. With the addition of a new graphical user interface that's in public preview, Mac users can now leverage the same industry-leading database platform that has previously only been available to Windows users, all on their local computer. Let me show you how to get started in three easy steps.

SQL Server has traditionally run only on Windows. New for 2017 is the ability to install server instances and work with databases on Linux and in Docker containers, which opens the possibility of running SQL Server on macOS. With the extension tools now available as native Linux and macOS applications, users can capitalize on the variety of options available for running a database instance. This course shows how to install SQL Server on new platforms, and how to connect to it from a newly diverse array of environments. Instructor Adam Wilbert also shows how to use SQL Operations Studio to perform routine SQL Server maintenance tasks, such as backups, from Windows, macOS, and Linux.

Microsoft SQL Server can be an intimidating system. In this course, instructor Adam Wilbert provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. Adam goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. He introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.

SQL Server 2017 is the start of the new annual release strategy by Microsoft. SQL developers no longer have to wait two or three years for enhancements. See what's new and notable in the 2017 release, in this overview with Adam Wilbert. See the new Linux compatibility in action, as Adam shows how to install SQL Server on Ubuntu, and learn how to use the machine learning services package, which includes R and Python scripting. Then find out how to use graph databases to model many-to-many relationships as nodes and edges. Adam also reviews the smaller enhancements like automatic query performance tuning and the new dynamic management views.