Creating Two Keys

Practical Graph Structures in SQL Server and Azure SQL: Enabling Deeper Insights Using Highly Connected Data

Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.

• Printed book:
  • US
• Kindle book:
  • US

Running a Service

The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.

Are You Worried About AI?

Many people are worried for their future career prospects with the growth of Artificial Intelligence (AI) in many situations. Steve doesn't think that AI is going to take over the world, but it might affect your future opportunities.

Future Data Driven 2023 is This Week

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has  a great schedule (scroll...

Opening the SQL Prompt Command Palette

A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...

Quickly Creating a tsqlt Test for a Query

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...

SQL Saturday Denver 2023–VCS Primer for the Database slides

My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...

The Upgraded Procedure part 2

A New Word:Wildred

wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...