This article shows a number of ways in which you can find out the version of your instance.
The post How to Find the SQL Server Version appeared first on SQLServerCentral.

Deadlocks can occur in any database system, and SQL Server is no exception. In this article, we look at the steps I used to detect and resolve deadlocks in stored procedures.
The post Troubleshoot SQL Server Deadlocks in Stored Procedures appeared first on SQLServerCentral.

Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.
The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.

This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.
The post How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples appeared first on SQLServerCentral.

The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.
The post The SELECT Statement in Oracle appeared first on SQLServerCentral.

SQL Server supports working with JSON data and provides many different functions that can be used. SQL Server 2022 has expanded the ability to check if the JSON format is valid using the ISJSON function which we will cover in this article.
The post ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object appeared first on SQLServerCentral.

A comparison of the lambda and kappa architectures for real time ingestion and analysis of big data.
The post Advantages of Kappa architecture in the Modern Data Stack appeared first on SQLServerCentral.

Is your team looking to modernize and migrate your data but have questions about the complex organizational challenges? This webinar panel on June 29th covers all aspects of data modernization and migration that senior IT leaders should be aware of, including organization culture, communication, and politics. Why not send it to your boss?
The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.