Joey on SQL Server


Clear Connection: Building APIs for Databases

You don't need to be a software developer to quickly create an API that will retrieve the information you need.

A Love Letter to the Command Line Tool sqlcmd

Often overlooked, it's a powerful tool that can make your life a lot easier. Especially now that Microsoft has updated its functionality.

SQL Server 2022: Every Licensing Detail You Need To Know

Microsoft's relational database engine has had the same licensing model since 2012. The new version released this week brings significant changes that brings SQL Server closer to Azure SQL's licensing model.

Gears

Microsoft Finally Releases SQL Server 2022

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.

Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization

Reduce workload times with this handy feature that can benefit every database pro.

On the Floor of Microsoft Ignite: Day 1 Announcement Thoughts

Despite a smaller floor presence, Microsoft jumped out of the gate with some big announcements for IT and database managers.

Industrial Rigging Graphic

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.

Frozen Glass

Everything You Need To Know About Azure SQL Database Emulator

Microsoft's Asad Khan breaks down some details on the recently announced feature.

DBAs: You Need To Learn PowerShell

It's time. Make your life a lot easier by automating those time-intensive tasks.

Matrix

Microsoft Build: A Deeper Dive into SQL Server 2022

Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for.

Making Managed Instance Better with NoRecovery

Here's how Microsoft can make data migration easier on us.

Tracking Performance Impacts of SQL Server Changes

Getting a bird's eye view can help to quickly spot trouble areas.

Subscribe on YouTube