Tagged articles
T-SQL
13 articles · Page 1 of 1

ITPUBOct 14, 2026 · Databases
A comprehensive reference of 100 practical T-SQL commands for SQL Server 2016-2022 DBAs, organized into ten categories covering instance basics, space management, session analysis, locking, performance tuning, indexes, Always On, backup/recovery, permissions, and daily health checks.
Backup RecoveryDBADMV
0 likes · 12 min read


liandkAug 22, 2026 · Databases
The article explains that indexes are the key to solving most database slow‑query problems, compares full‑table scans with indexed lookups, describes the two main index types in SQL Server, and provides step‑by‑step T‑SQL commands for creating, testing, and removing indexes while warning against over‑indexing.
Database IndexesQuery TuningSQL Server
0 likes · 5 min read


liandkJul 21, 2026 · Databases
The article explains what SQL Server 2012 stored procedures are, outlines their core advantages, provides a reusable syntax template, walks through three practical examples (no‑parameter, parameterized, and default‑parameter procedures), and covers how to alter, drop, appropriate use cases, and common beginner mistakes.
SQL ServerSQL2012T-SQL
0 likes · 7 min read

This article walks through installing KingbaseES's SQL Server compatible edition, evaluates core T‑SQL features such as GO, PRINT, RAISERROR, THROW, statement terminators, and trailing commas in CREATE TABLE, provides practical code examples, and offers solutions to common Windows installation errors.
Database TestingKingBaseESSQL
0 likes · 15 min read

This article presents a collection of practical T‑SQL techniques—including row‑to‑column pivots, column‑to‑row unpivots, string replacement, date/time conversion, division with percentage formatting, NULL handling, counting methods, UNION ALL inserts, cache inspection, plan cache clearing, line‑break handling, TRUNCATE vs DELETE, system diagnostics, and execution‑time measurement—each illustrated with complete SQL code examples.
Data ManipulationSQLT-SQL
0 likes · 17 min read

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.
Data ManagementSQLSQL Server
0 likes · 23 min read

This article presents a comprehensive list of practical SQL query optimization techniques, emphasizing how to avoid full table scans by using proper indexing, rewriting WHERE clauses, avoiding certain operators, functions, and expressions, and providing example code snippets to improve database performance.
SQLT-SQLquery optimization
0 likes · 10 min read


ITPUBNov 10, 2020 · Databases
This comprehensive cheat sheet gathers over eighty practical T‑SQL statements covering instance properties, configuration, system views, lock monitoring, backup progress, replication, Always On, FILESTREAM, job management, index maintenance, and security, providing DBAs with ready‑to‑run commands for everyday SQL Server administration and troubleshooting.
ReplicationSQL ServerT-SQL
0 likes · 29 min read

The article examines the difficulties of reusing SQL Server stored procedures to obtain simple boolean checks, illustrates a concrete example of counting jobs with temporary tables, discusses maintenance pitfalls, and concludes that business logic is often better implemented outside stored procedures.
Database DesignSQLT-SQL
0 likes · 6 min read

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.
Linked ServerSQLSQL Server
0 likes · 22 min read

The article examines the drawbacks of reusing stored procedures for business logic, illustrates maintenance challenges with example code, and argues that moving simple existence checks to the database while keeping complex logic in application code yields better readability, extensibility, and performance.
Database DesignSQLT-SQL
0 likes · 6 min read


ITPUBMay 30, 2018 · Databases
This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.
DMVRestoreSQL Server
0 likes · 7 min read


DevOpsJan 6, 2016 · Backend Development
This guide demonstrates how to create a linked server to Active Directory in SQL Server, query user and group information via T‑SQL, and store the results in database tables for further analysis with TFS data.
AD Group QueryActive DirectoryLinked Server
0 likes · 6 min read
