BestHub
Sign in
Tag

SQL Server

1 views collected around this technical thread.

Wukong Talks Architecture
Wukong Talks Architecture
Apr 28, 2025 · Databases

Comprehensive Guide to Popular Database Management Tools

This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.

DBeaverDatabase ToolsMySQL
0 likes · 19 min read
Comprehensive Guide to Popular Database Management Tools
Efficient Ops
Efficient Ops
Sep 23, 2024 · Databases

Why Many Developers Prefer SQL Server Over MySQL: Performance, Features, and Tooling

A collection of Zhihu users compares SQL Server and MySQL, highlighting SQL Server's superior locking, performance on massive tables, richer backup and restore tools, tighter C# integration, and enterprise adoption, while acknowledging MySQL's free, lightweight nature and its historical limitations.

BackupC# IntegrationDatabase Comparison
0 likes · 7 min read
Why Many Developers Prefer SQL Server Over MySQL: Performance, Features, and Tooling
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 3, 2023 · Databases

SQLE 2.2302.0-pre3 Release Notes and Feature Overview

The SQLE 2.2302.0-pre3 release introduces a preview version of the SQL audit tool with enhanced SQL Server audit plugin, new rule support, context-aware auditing, rollback generation, and several UI optimizations, while providing links to repositories, documentation, and demo environments.

Release NotesSQL ServerSQL audit
0 likes · 4 min read
SQLE 2.2302.0-pre3 Release Notes and Feature Overview
Top Architect
Top Architect
Aug 20, 2022 · Databases

Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips

An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.

BackupDatabase AdministrationPerformance Tuning
0 likes · 24 min read
Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips
Laravel Tech Community
Laravel Tech Community
Aug 17, 2022 · Databases

Comprehensive SQL Server Database Operations and Techniques Guide

This article provides a comprehensive collection of SQL Server commands and techniques, covering database creation, table manipulation, queries, indexing, backup, replication, and advanced operations, offering practical examples and code snippets for developers and database administrators.

DatabaseSQLSQL Server
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Techniques Guide
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

BackupDatabaseLinked Server
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
macrozheng
macrozheng
Jul 23, 2022 · Databases

July 2023 DB-Engines Ranking: Oracle Drops, MySQL & SQL Server Rise

The July 2023 DB-Engines ranking shows Oracle, PostgreSQL and MongoDB slipping, while MySQL and Microsoft SQL Server climb, and provides detailed scores, trend charts, and the methodology behind the monthly popularity scores for the top ten database systems.

DB-EnginesMySQLOracle
0 likes · 4 min read
July 2023 DB-Engines Ranking: Oracle Drops, MySQL & SQL Server Rise
Selected Java Interview Questions
Selected Java Interview Questions
Jun 28, 2022 · Databases

Designing Cross‑Database Date and Time Types: Comparison of MySQL, Oracle, and SQL Server

The article examines how to design cross‑database date and time storage by comparing MySQL, Oracle, and SQL Server date‑time types, discussing their formats, ranges, storage sizes, and trade‑offs, and proposes practical solutions such as using timestamps, custom conversion functions, and ORM considerations.

DatabaseDateDateTime
0 likes · 7 min read
Designing Cross‑Database Date and Time Types: Comparison of MySQL, Oracle, and SQL Server
macrozheng
macrozheng
Mar 12, 2022 · Databases

March 2024 DB‑Engines Ranking: Who’s Rising and Who’s Falling?

The March 2024 DB‑Engines ranking reveals Oracle, MySQL and SQL Server losing ground while PostgreSQL surges, Snowflake climbs, and detailed top‑10 lists across relational, key‑value, document, time‑series, and graph databases illustrate shifting popularity trends based on five industry metrics.

DB-EnginesPostgreSQLSQL Server
0 likes · 4 min read
March 2024 DB‑Engines Ranking: Who’s Rising and Who’s Falling?
Laravel Tech Community
Laravel Tech Community
Oct 28, 2021 · Databases

Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access

This guide explains how to create a read‑only login in Microsoft SQL Server, map it to specific databases, assign the db_datareader role, and optionally grant permission to view stored procedures, while also summarizing common server and database roles.

Database PermissionsRead-Only UserSQL Server
0 likes · 6 min read
Creating a Read‑Only User in SQL Server and Granting Stored Procedure Access
Architecture Digest
Architecture Digest
Aug 15, 2021 · Databases

Comparing Three Methods of Inserting Data into SQL Server with SpringBoot

This article evaluates three ways to insert records into a SQL Server database—repeated single inserts, XML‑concatenated SQL, and batch processing—under SpringBoot, presents performance tests, and recommends the most suitable approach based on data volume and code simplicity.

MyBatisPerformance TestingSQL Server
0 likes · 7 min read
Comparing Three Methods of Inserting Data into SQL Server with SpringBoot
Laravel Tech Community
Laravel Tech Community
Apr 7, 2021 · Databases

Database Performance Tuning: Analyzing and Resolving CMEMTHREAD Waits in SQL Server

This article walks through a systematic, onion‑layer approach to diagnosing and fixing SQL Server performance problems, focusing on hardware, system scale, internal database factors, software environment, business architecture, and code design, with a real‑world hospital case study and concrete remediation steps.

CMEMTHREADDatabaseMemory Contention
0 likes · 10 min read
Database Performance Tuning: Analyzing and Resolving CMEMTHREAD Waits in SQL Server
Python Programming Learning Circle
Python Programming Learning Circle
Mar 18, 2021 · Databases

Performance Comparison of Clustered and Non-Clustered Indexes in SQL Server and MySQL

This article investigates how clustered and non‑clustered indexes affect query, insert, update, and delete performance in SQL Server 2008R2 and MySQL 5.5 using three test tables, presenting detailed timing results and concluding that clustered indexes are optimal for small datasets while indexes dramatically speed up queries in MySQL.

DatabaseIndexingMySQL
0 likes · 7 min read
Performance Comparison of Clustered and Non-Clustered Indexes in SQL Server and MySQL
Architect's Tech Stack
Architect's Tech Stack
Mar 4, 2021 · Databases

Comparing Three Methods for Inserting Data into SQL Server with Spring Boot

This article evaluates three ways to insert records into a SQL Server database—repeated single inserts, XML‑based SQL concatenation, and batch processing—under a Spring Boot environment, providing code examples, performance test results, and practical recommendations for different data volumes.

JavaMyBatisPerformance
0 likes · 6 min read
Comparing Three Methods for Inserting Data into SQL Server with Spring Boot
Architecture Digest
Architecture Digest
Sep 5, 2020 · Databases

Understanding SQL Server Lock Escalation and How to Prevent It

This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.

Lock EscalationPerformance TuningSQL
0 likes · 12 min read
Understanding SQL Server Lock Escalation and How to Prevent It
Wukong Talks Architecture
Wukong Talks Architecture
Sep 3, 2020 · Databases

Understanding SQL Server Transactions, Locks, Isolation Levels, and Deadlocks

This article explains the fundamentals of SQL Server transactions, the ACID properties, various lock types and modes, how to analyze and resolve blocking, the behavior of different isolation levels, and strategies for detecting and handling deadlocks, providing practical T‑SQL examples throughout.

DatabaseDeadlocksIsolation Levels
0 likes · 27 min read
Understanding SQL Server Transactions, Locks, Isolation Levels, and Deadlocks
Java Captain
Java Captain
Aug 15, 2020 · Databases

Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

This article provides a detailed collection of SQL Server commands and techniques covering database creation, table and index management, common DML statements, advanced set operators, various join types, grouping, pagination, maintenance tasks, replication setup, linked‑server usage, and a synchronization stored procedure.

Database AdministrationLinked ServerQuery Optimization
0 likes · 22 min read
Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication
Architects Research Society
Architects Research Society
Jun 9, 2020 · Databases

PostgreSQL vs SQL Server: Performance and Scalability Comparison

An in‑depth comparison of PostgreSQL and Microsoft SQL Server examines their concurrency, partitioning, indexing, compression, cross‑platform support, and overall performance and scalability, concluding that PostgreSQL generally outperforms SQL Server across these parameters while offering more cost‑effective and flexible features.

Database ComparisonPerformancePostgreSQL
0 likes · 6 min read
PostgreSQL vs SQL Server: Performance and Scalability Comparison
DataFunTalk
DataFunTalk
Apr 29, 2020 · Databases

High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip

This article explains Ctrip's high‑availability designs for SQL Server, MySQL, and Redis, describing multi‑replica strategies, evolution from legacy mirroring to AlwaysOn, multi‑node MHA management, and Redis sentinel‑based failover, while emphasizing fault‑tolerance across data centers.

High AvailabilityMySQLRedis
0 likes · 12 min read
High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip