It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL extension for Visual Studio Code. Microsoft recently ended support for Azure Data ...

In this article, I will discuss the Lost Update Concurrency Problem in SQL Server with Examples. Please read our previous article discussing the Dirty Read Concurrency Problem in SQL Server with ...

Born out of Microsoft’s SQL Server Big Data Clusters investments, the Apache Spark Connector for SQL Server and Azure SQL is a high-performance connector that enables you to use transactional data in ...

The Workflows tab brings up the Workflow editor, where you can create different types of custom Workflows. You can either create a workflow from scratch, or customize one of the six existing ones. For ...

The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...

💰 Mentorship to six figure software engineer - https://calcur.tech/mentorship ⚙️ Backend Engineering Mind Map - https://calcur.tech/mindmap 💻 System Design Playlist - ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

For the last 7 years, I have worked professionally with Tableau, and for 7 years we have been asked questions about write back to a database. Can it be done, and what does it require? This blog post ...