SQLServerCentral Article

Add a Second NIC for an Availability Group to Separate Network Traffic

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]

External Article

Long Short-Term Memory Network for Machine Learning

While Recurrent Neural Networks (RNN) are powerful, they often struggle with long-term dependencies due to the vanishing gradient problem. Long Short-Term Memory Networks (LSTMs) address this issue by introducing memory cells and gates. For beginners, understanding LSTM components, such as the input, output, and forget gates, can be challenging. This tip breaks down LSTMs in an intuitive way, highlighting their importance and practical applications.

Blogs

SQL Server 2025 Release Candidate Available

By

For those testing SQL Server 2025 before it officially releases, Microsoft has made the...

Scooby-Doo and the Mystery of Cloud Costs (Let’s have some fun!) – Scooby Dooing Episode 1

By

If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other...

Fabric Real Time Data: Making the Shift from Batch to Live Insights

By

Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations...

Read the latest Blogs

Forums

Encryption or Certificate - Trying to NOT put hardcoded password in Proc

By cFauvel

We have a few stored procs where we need to a dos command "net...

Next dates

By smattiko83

CREATE TABLE ADMITS ( ID_NUM INT varchar(15) null ,provider_id varchar(15) null ,provider_name varchar(36) null...

Moving a database from AWS RDS Custom to RDS Standard

By BrainDonor

Having real fun with this. It isn't possible to set the option group, to...

Visit the forum

Question of the Day

Change Tracking and Database Compatibility

I want to enable Change Tracking for a database. What is the minimum database compatibility level I need to set for the Changetable function to work correctly?

See possible answers