# T-SQL Programming

Published articles for T-SQL Programming.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three)

DevFeed: [How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three)](<https://devfeed.tech/articles/how-to-insert-query-and-modify-data-in-postgresql-getting-started-with-postgresql-part-three-113441.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/postgresql/how-to-insert-query-and-modify-data-in-postgresql-getting-started-with-postgresql-part-three/>)

Author: Grant Fritchey

Published: 2026-11-02T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [CRUD](<https://devfeed.tech/topics/crud.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [aliases](<https://devfeed.tech/tags/aliases.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [delete](<https://devfeed.tech/tags/delete.md>), [examples](<https://devfeed.tech/tags/examples.md>), [featured](<https://devfeed.tech/tags/featured.md>), [getting-started](<https://devfeed.tech/tags/getting-started.md>), [gettingstartedpostgresgrant](<https://devfeed.tech/tags/gettingstartedpostgresgrant.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [insert](<https://devfeed.tech/tags/insert.md>), [join](<https://devfeed.tech/tags/join.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [select](<https://devfeed.tech/tags/select.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>), [update](<https://devfeed.tech/tags/update.md>)

### AI overview

The guide demonstrates PostgreSQL's basic data workflow: use INSERT to add rows, omitting IDENTITY columns or supplying DEFAULT so PostgreSQL can generate values; use SELECT with explicit columns and a schema-qualified table for clearer, controlled results; and filter or combine data with WHERE and JOIN. JOIN defaults to INNER JOIN, while LEFT and RIGHT joins return NULLs for nonmatching rows; aliases shorten table references. ORDER BY is needed for predictable ordering, especially with LIMIT. UPDATE and DELETE affect one table at a time and can use other tables for filtering; without WHERE they affect all matching rows in that table. Foreign keys can prevent deleting referenced rows. Under MVCC, changed or removed rows are logically deleted, with VACUUM later cleaning them up. The excerpt also gives container steps for launching the Bluebox sample database.

### Source excerpt

Learn how to insert, query, update, and delete data in PostgreSQL with real examples covering INSERT, SELECT, JOIN, WHERE, and more.... The post How to insert, query, and modify data in PostgreSQL (getting started with PostgreSQL, part three) appeared first on Simple Talk.

## The key syntax differences between MySQL and PostgreSQL - everything you should know

DevFeed: [The key syntax differences between MySQL and PostgreSQL - everything you should know](<https://devfeed.tech/articles/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know-101272.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/the-key-syntax-differences-between-mysql-and-postgresql-everything-you-should-know/>)

Author: Aisha Bukar

Published: 2026-10-26T12:00:00Z

Content type: article

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [syntax](<https://devfeed.tech/topics/syntax.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>)

Tags: [aishabukar-mysql-postgresql](<https://devfeed.tech/tags/aishabukar-mysql-postgresql.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [fetch](<https://devfeed.tech/tags/fetch.md>), [limit](<https://devfeed.tech/tags/limit.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-syntax](<https://devfeed.tech/tags/sql-syntax.md>), [syntax](<https://devfeed.tech/tags/syntax.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

MySQL-to-PostgreSQL migration requires checking behavior as well as SQL syntax. MySQL identifier backticks must be replaced with PostgreSQL double quotes, whose use makes names case-sensitive; renaming keyword conflicts may be easier to maintain. PostgreSQL offers sequence-backed SERIAL and SQL-standard IDENTITY in place of AUTO_INCREMENT, but neither automatically adds a uniqueness constraint; PostgreSQL RETURNING replaces separate retrieval with LAST_INSERT_ID(). Basic LIMIT and OFFSET work in both, while MySQL's LIMIT offset,count shorthand does not; PostgreSQL also supports FETCH FIRST. MySQL's INSERT IGNORE and ON DUPLICATE KEY UPDATE translate to PostgreSQL ON CONFLICT DO NOTHING or DO UPDATE. TRUNCATE differs more substantially: PostgreSQL supports rollback and explicit identity restart/continuation, while MySQL InnoDB TRUNCATE implicitly commits; foreign-key and cascade behavior also needs review.

### Source excerpt

Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and more.... The post The key syntax differences between MySQL and PostgreSQL - everything you should know appeared first on Simple Talk.

## How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide)

DevFeed: [How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide)](<https://devfeed.tech/articles/how-to-secure-temporary-objects-metadata-visibility-and-audit-assurance-in-sql-server-complete-guide-84031.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/how-to-secure-temporary-objects-metadata-visibility-and-audit-assurance-in-sql-server-complete-guide/>)

Author: Fabiano Amorim

Published: 2026-10-09T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>)

Tags: [attack](<https://devfeed.tech/tags/attack.md>), [audit](<https://devfeed.tech/tags/audit.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [fasqlsecurity](<https://devfeed.tech/tags/fasqlsecurity.md>), [featured](<https://devfeed.tech/tags/featured.md>), [guide](<https://devfeed.tech/tags/guide.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

This SQL Server security guide explains risks from global temporary objects, broad metadata visibility through DMVs, and audit gaps. It offers DBA checks and mitigations, including reducing privileges, validating inputs, testing direct and indirect access paths, and protecting audit records.

### Source excerpt

Global temp objects, DMVs, and audit gaps can quietly become attack paths in SQL Server. Learn what to review, monitor, and fix as a DBA.... The post How to secure temporary objects, metadata visibility, and audit assurance in SQL Server (complete guide) appeared first on Simple Talk.

## How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)

DevFeed: [How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)](<https://devfeed.tech/articles/how-to-close-sql-server-operational-blind-spots-linked-servers-dmvs-and-kill-command-security-risks-fixes-59854.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/how-to-close-sql-server-operational-blind-spots-linked-servers-dmvs-and-kill-command-security-risks-fixes/>)

Author: Fabiano Amorim

Published: 2026-09-25T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [Security](<https://devfeed.tech/topics/security.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Server](<https://devfeed.tech/topics/server.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [exploit](<https://devfeed.tech/tags/exploit.md>), [fasqlsecurity](<https://devfeed.tech/tags/fasqlsecurity.md>), [featured](<https://devfeed.tech/tags/featured.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [risks](<https://devfeed.tech/tags/risks.md>), [security](<https://devfeed.tech/tags/security.md>), [security-and-compliance](<https://devfeed.tech/tags/security-and-compliance.md>), [security-privacy-compliance](<https://devfeed.tech/tags/security-privacy-compliance.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

This tutorial examines SQL Server operational blind spots that attackers can abuse after compromising lower-privileged accounts. It focuses on linked servers, traces, Dynamic Management Views, Extended Events, session-management commands, monitoring, and remediation priorities.

### Source excerpt

Learn how attackers exploit SQL Server linked servers, traces, DMVs, and the KILL command - plus the monitoring queries and fixes DBAs need to close these blind spots.... The post How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes) appeared first on Simple Talk.

## SQL Server login failures: how to monitor, report, and alert on them (complete guide)

DevFeed: [SQL Server login failures: how to monitor, report, and alert on them (complete guide)](<https://devfeed.tech/articles/sql-server-login-failures-how-to-monitor-report-and-alert-on-them-complete-guide-50489.md>)

Original publisher: [Read original article](<https://www.red-gate.com/simple-talk/databases/sql-server/sql-server-login-failures-how-to-monitor-report-and-alert-on-them-complete-guide/>)

Author: Edward Pollack

Published: 2026-09-02T12:00:00Z

Content type: tutorial

Language: en

Sources: [Simple Talk](<https://devfeed.tech/sources/simple-talk.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Security](<https://devfeed.tech/topics/security.md>), [Database](<https://devfeed.tech/topics/database.md>), [Logging](<https://devfeed.tech/topics/logging.md>)

Tags: [alert](<https://devfeed.tech/tags/alert.md>), [database](<https://devfeed.tech/tags/database.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [databases](<https://devfeed.tech/tags/databases.md>), [featured](<https://devfeed.tech/tags/featured.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [logging](<https://devfeed.tech/tags/logging.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [t-sql-programming](<https://devfeed.tech/tags/t-sql-programming.md>)

### AI overview

A practical guide to detecting SQL Server login failures, filtering and aggregating error-log data with T-SQL and xp_readerrorlog, and automatically emailing summary alerts. It explains how failures can indicate configuration problems, application bugs, password issues, or unauthorized access attempts.

### Source excerpt

Learn how to detect and report SQL Server login failures using T-SQL and xp_readerrorlog. Includes ready-to-use scripts for filtering, aggregating, and emailing alerts.... The post SQL Server login failures: how to monitor, report, and alert on them (complete guide) appeared first on Simple Talk.