#sql-server

[ follow ]
#microsoft

Microsoft goes all-in on AI with SQL Server 2025

Microsoft's SQL Server 2025 introduces significant performance enhancements, AI integrations, and features aimed at improving development efficiency and data handling capabilities.

Nearly 20% of SQL Servers running have passed end of support

Admins need to track and update outdated SQL Servers for security and compliance.

Microsoft goes all-in on AI with SQL Server 2025

Microsoft's SQL Server 2025 introduces significant performance enhancements, AI integrations, and features aimed at improving development efficiency and data handling capabilities.

Nearly 20% of SQL Servers running have passed end of support

Admins need to track and update outdated SQL Servers for security and compliance.
moremicrosoft
#entity-framework

How to Solve the Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$ Error | HackerNoon

EF8 may generate SQL queries incompatible with older SQL servers due to compatibility level mismatches.
Synchronizing server and client compatibility levels can resolve syntax errors.

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

The mismatch in Compatibility Levels between Entity Framework and SQL Server causes SQL code generation errors.

How to Solve the Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$ Error | HackerNoon

EF8 may generate SQL queries incompatible with older SQL servers due to compatibility level mismatches.
Synchronizing server and client compatibility levels can resolve syntax errors.

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

The mismatch in Compatibility Levels between Entity Framework and SQL Server causes SQL code generation errors.
moreentity-framework

A haunting Patch Tuesday for October: 117 updates (and 5 zero-day flaws)

Desktop testing updates for SQL Server now include validation of SQL commands and stored procedures.
Windows updates necessitate a comprehensive feature-by-feature testing regime focused on networking, security, and remote desktop functions.

Securing data in SQL Server

Securing data in SQL Server requires multiple layers of security controls to protect against unauthorized access.

Understanding CDC in SQL Server

Change Data Capture (CDC) in SQL Server provides detailed tracking of data changes for auditing and ETL, crucial for maintaining historical data records.

How to Repair Corrupt SQL Database using DBCC CHECKDB Command?

MS SQL databases can suffer corruption from various issues, but DBCC CHECKDB offers solutions to detect and repair these problems.
#database-management

How to check your SQL Server version

Understanding SQL Server versions is crucial for support and feature availability.
Different SQL Server versions have specific support timelines and features.
Outdated SQL Server versions may lack essential security updates.

Is Now the Right Time to Start Using Azure Data Studio? | HackerNoon

Azure Data Studio is an improved alternative to SQL Server Management Studio, especially for user-friendliness and modern database management needs.

Mastering Microsoft SQL Server: Analyzing and Optimizing Complex Queries - DATAVERSITY

Understanding Query Analysis
Using the Execution Plan

How to check your SQL Server version

Understanding SQL Server versions is crucial for support and feature availability.
Different SQL Server versions have specific support timelines and features.
Outdated SQL Server versions may lack essential security updates.

Is Now the Right Time to Start Using Azure Data Studio? | HackerNoon

Azure Data Studio is an improved alternative to SQL Server Management Studio, especially for user-friendliness and modern database management needs.

Mastering Microsoft SQL Server: Analyzing and Optimizing Complex Queries - DATAVERSITY

Understanding Query Analysis
Using the Execution Plan
moredatabase-management

Small function to replace characters with SQL Server

Utilize CTE in SQL Server functions to replace characters efficiently.
#entity-relationship-diagram

SQL Table Dependency Diagram Generator

Use Auto Generate Table Dependency Diagram SSMS extension to quickly create an Entity Relationship Diagram from a subset of tables.

Table Dependency Diagram Generator

Quickly generate Entity Relationship Diagrams in SSMS using Auto Generate Table Dependency Diagram extension.

SQL Table Dependency Diagram Generator

Use Auto Generate Table Dependency Diagram SSMS extension to quickly create an Entity Relationship Diagram from a subset of tables.

Table Dependency Diagram Generator

Quickly generate Entity Relationship Diagrams in SSMS using Auto Generate Table Dependency Diagram extension.
moreentity-relationship-diagram

.NET 8 - Transactional Outbox Pattern With EF Core

Transactional Outbox Pattern ensures data consistency across multiple services in Order Management System.

Navigating Microsoft SQL Server and Kubernetes in a Hybrid and Multi-Cloud Era

DH2i's DxOperator is a game changer for managing SQL Server within Kubernetes in hybrid and multi-cloud environments.
DxOperator streamlines complex deployments and turns specific requirements into optimized actions.

Java JDBC connection string examples

Example JDBC connection strings for popular databases.
[ Load more ]