#sql-server
#sql-server

JavaScript

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.

Data science

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.

2 months ago

Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.

Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.

4 years ago

JavaScript

Here's How to Keep Tempdb From Becoming Your Worst Nightmare | HackerNoon

Tempdb is vital for SQL Server operations; its mismanagement can lead to severe system performance issues.

fromMedium

3 months ago

Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Backup processes must be managed carefully to ensure data consistency, especially with databases.

fromITPro

JavaScript

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.

Data science

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.

2 months ago

Ruby on Rails

Want Everyone Out of the Database? Here's How the Pros Do It | HackerNoon

Single-user mode is essential for performing critical database tasks without conflicts.

Transitioning back to multi-user mode is crucial after maintenance to restore normal operations.

fromMicrosoft for Python Developers Blog

4 years ago

JavaScript

Here's How to Keep Tempdb From Becoming Your Worst Nightmare | HackerNoon

Tempdb is vital for SQL Server operations; its mismanagement can lead to severe system performance issues.

more#database-management

1 month ago

Python

New Python Driver for SQL Server and Azure SQL! - Microsoft for Python Developers Blog

The alpha release of an open-source Python driver for Microsoft SQL Server has been announced.

#microsoft

1 month ago

Business intelligence

Microsoft SQL Server 2019 shuffles out of mainstream support

SQL Server 2019 has moved to extended support as of last week, with only SQL Server 2022 remaining in mainstream support.

5 months ago

Artificial intelligence

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.

10 months ago

Tech industry

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

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

Business intelligence

1 month ago

Microsoft SQL Server 2019 shuffles out of mainstream support

SQL Server 2019 has moved to extended support as of last week, with only SQL Server 2022 remaining in mainstream support.

Artificial intelligence

5 months ago

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.

10 months ago

Tech industry

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

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

more#microsoft

fromMedium

3 months ago

Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Backup methods can lead to data inconsistency. Application-consistent backups are most reliable for protecting data.

fromMedium

3 months ago

Miscellaneous

Backup types-Inconsistent, App consistent, crash consistent

Inconsistent backups can result from changes during the backup process, especially for databases.

Crash-consistent backups capture data at one timestamp, missing in-memory transactions.

Application-consistent backups provide the best protection by capturing complete application state.

#entity-framework

3 years ago

JavaScript

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.

7 months ago

JavaScript

.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.

3 years ago

JavaScript

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.

7 months ago

JavaScript

.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.

more#entity-framework

6 months ago

Privacy professionals

Securing data in SQL Server

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

JavaScript

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.

11 months ago

JavaScript

Small function to replace characters with SQL Server

Utilize CTE in SQL Server functions to replace characters efficiently.