Table of Contents
Learn dbatools in a Month of Lunches
Return to dbatools, SQL Server Bibliography, PowerShell Bibliography, Manning SQL Server Series, Manning SQL Series], [[Manning Data Science Series, In a Month of Lunches, Manning Books Purchased by Cloud Monk, Manning Bibliography, Cloud Monk's Book Purchases, Cloud Monk Library, Bibliography, Manning Publications
Fair Use Sources
SQL Server: SQL Server PowerShell, dbatools, Microsoft SQL, Azure SQL Server, T-SQL (Transact-SQL), T-SQL keywords, SQL Reserved Words, SQL Server glossary, SQL Server GitHub, SQL Server 2022, SQL Server 2019, SQL Server 2017, SQL Server 2014, SQL Server 2012, SQL Server on Kubernetes, SQL Server on Containers, SQL Server on Linux, Awesome SQL Server (navbar_sqlserver - see also navbar_dbatools — MERGE navbar_sqlserver and navbar_sql_server and replace navbar_sql_server on all articles)
PowerShell Programming Language, PowerShell Shell, PowerShell Script, PowerShell .ps1 File, PowerShell Pipeline, PowerShell PowerShell.exe Executable, PowerShell pwsh Executable, PowerShell Core, PowerShell ISE (Integrated Scripting Environment), PowerShell Module, PowerShell Cmdlet, PowerShell Get-Command Cmdlet, PowerShell Get-Help Cmdlet, PowerShell Get-Process Cmdlet, PowerShell Get-Service Cmdlet, PowerShell Get-Item Cmdlet, PowerShell Set-Item Cmdlet, PowerShell Remove-Item Cmdlet, PowerShell Get-Content Cmdlet, PowerShell Set-Content Cmdlet, PowerShell Add-Content Cmdlet, PowerShell Out-Host Cmdlet, PowerShell Out-File Cmdlet, PowerShell Out-Null Cmdlet, PowerShell Out-GridView Cmdlet, PowerShell Select-Object Cmdlet, PowerShell Where-Object Cmdlet, PowerShell ForEach-Object Cmdlet, PowerShell Sort-Object Cmdlet, PowerShell Measure-Object Cmdlet, PowerShell Group-Object Cmdlet, PowerShell Format-Table Cmdlet, PowerShell Format-List Cmdlet, PowerShell Format-Wide Cmdlet, PowerShell Format-Custom Cmdlet, PowerShell Compare-Object Cmdlet, PowerShell Tee-Object Cmdlet, PowerShell New-Item Cmdlet, PowerShell Copy-Item Cmdlet, PowerShell Move-Item Cmdlet, PowerShell Rename-Item Cmdlet, PowerShell Test-Path Cmdlet, PowerShell Join-Path Cmdlet, PowerShell Split-Path Cmdlet, PowerShell Resolve-Path Cmdlet, PowerShell Push-Location Cmdlet, PowerShell Pop-Location Cmdlet, PowerShell Set-Location Cmdlet, PowerShell Get-ChildItem Cmdlet, PowerShell Invoke-Item Cmdlet, PowerShell Clear-Host Cmdlet, PowerShell Clear-Content Cmdlet, PowerShell Get-Date Cmdlet, PowerShell Get-Variable Cmdlet, PowerShell Set-Variable Cmdlet, PowerShell New-Variable Cmdlet, PowerShell Remove-Variable Cmdlet, PowerShell New-Alias Cmdlet, PowerShell Get-Alias Cmdlet, PowerShell Set-Alias Cmdlet, PowerShell Import-Module Cmdlet, PowerShell Get-Module Cmdlet, PowerShell Remove-Module Cmdlet, PowerShell Export-ModuleMember Cmdlet, PowerShell Update-Help Cmdlet, PowerShell Save-Help Cmdlet, PowerShell Set-ExecutionPolicy Cmdlet, PowerShell Get-ExecutionPolicy Cmdlet, PowerShell Invoke-Command Cmdlet, PowerShell Enter-PSSession Cmdlet, PowerShell Exit-PSSession Cmdlet, PowerShell New-PSSession Cmdlet, PowerShell Remove-PSSession Cmdlet, PowerShell Import-PSSession Cmdlet, PowerShell Export-PSSession Cmdlet, PowerShell New-PSSessionOption Cmdlet, PowerShell Enable-PSRemoting Cmdlet, PowerShell Disable-PSRemoting Cmdlet, PowerShell Set-StrictMode Cmdlet, PowerShell Get-PSProvider Cmdlet, PowerShell Get-PSDrive Cmdlet, PowerShell New-PSDrive Cmdlet, PowerShell Remove-PSDrive Cmdlet, PowerShell Set-PSBreakpoint Cmdlet, PowerShell Remove-PSBreakpoint Cmdlet, PowerShell Get-PSBreakpoint Cmdlet, PowerShell Start-Job Cmdlet, PowerShell Get-Job Cmdlet, PowerShell Stop-Job Cmdlet, PowerShell Receive-Job Cmdlet, PowerShell Remove-Job Cmdlet, PowerShell Wait-Job Cmdlet, PowerShell Start-Process Cmdlet, PowerShell Stop-Process Cmdlet, PowerShell Wait-Process Cmdlet, PowerShell New-Object Cmdlet, PowerShell Select-String Cmdlet, PowerShell Invoke-Expression Cmdlet, PowerShell Write-Host Cmdlet, PowerShell Write-Output Cmdlet, PowerShell Write-Error Cmdlet, PowerShell Write-Warning Cmdlet, PowerShell Write-Verbose Cmdlet, PowerShell Write-Debug Cmdlet, PowerShell Write-Information Cmdlet, PowerShell Get-Credential Cmdlet, PowerShell ConvertTo-SecureString Cmdlet, PowerShell ConvertFrom-SecureString Cmdlet, PowerShell Read-Host Cmdlet, PowerShell Get-Random Cmdlet, PowerShell New-TemporaryFile Cmdlet, PowerShell Start-Transcript Cmdlet, PowerShell Stop-Transcript Cmdlet, PowerShell Show-Command Cmdlet, PowerShell Add-Type Cmdlet, PowerShell Invoke-RestMethod Cmdlet, PowerShell Invoke-WebRequest Cmdlet, PowerShell Out-String Cmdlet, PowerShell Out-Printer Cmdlet, PowerShell Out-Default Cmdlet, PowerShell Out-Clipboard Cmdlet, PowerShell Get-Clipboard Cmdlet, PowerShell Set-Clipboard Cmdlet, PowerShell Start-Sleep Cmdlet, PowerShell Start-BitsTransfer Cmdlet, PowerShell ConvertTo-Json Cmdlet, PowerShell ConvertFrom-Json Cmdlet, PowerShell ConvertTo-Xml Cmdlet, PowerShell ConvertFrom-StringData Cmdlet, PowerShell ConvertTo-CSV Cmdlet, PowerShell ConvertFrom-CSV Cmdlet, PowerShell Import-CSV Cmdlet, PowerShell Export-CSV Cmdlet, PowerShell Import-Clixml Cmdlet, PowerShell Export-Clixml Cmdlet, PowerShell ConvertFrom-Markdown Cmdlet, PowerShell Get-InstalledModule Cmdlet, PowerShell Install-Module Cmdlet, PowerShell Update-Module Cmdlet, PowerShell Uninstall-Module Cmdlet, PowerShell Find-Module Cmdlet, PowerShell Save-Module Cmdlet, PowerShell Test-ModuleManifest Cmdlet, PowerShell Publish-Module Cmdlet, PowerShell Register-PSRepository Cmdlet, PowerShell Unregister-PSRepository Cmdlet, PowerShell Set-PSRepository Cmdlet, PowerShell Get-PSRepository Cmdlet, PowerShell Install-Package Cmdlet, PowerShell Get-Package Cmdlet, PowerShell Uninstall-Package Cmdlet, PowerShell Save-Package Cmdlet, PowerShell Find-Package Cmdlet, PowerShell Register-PackageSource Cmdlet, PowerShell Unregister-PackageSource Cmdlet, PowerShell Set-PackageSource Cmdlet, PowerShell Get-PackageSource Cmdlet, PowerShell Trace-Command Cmdlet, PowerShell Set-PSDebug Cmdlet, PowerShell Register-ScheduledJob Cmdlet, PowerShell Unregister-ScheduledJob Cmdlet, PowerShell Get-ScheduledJob Cmdlet, PowerShell Disable-ScheduledJob Cmdlet, PowerShell Enable-ScheduledJob Cmdlet, PowerShell Set-ScheduledJob Cmdlet, PowerShell Start-Job -InitializationScript Parameter, PowerShell Foreach-Object -Parallel Feature, PowerShell New-PSRoleCapabilityFile Cmdlet, PowerShell Suspend-Job Cmdlet, PowerShell Resume-Job Cmdlet, PowerShell Start-ThreadJob Cmdlet, PowerShell Get-ThreadJob Cmdlet, PowerShell New-Guid Cmdlet, PowerShell Get-PSCallStack Cmdlet, PowerShell Add-History Cmdlet, PowerShell Get-History Cmdlet, PowerShell Invoke-History Cmdlet, PowerShell Clear-History Cmdlet, PowerShell Set-PSReadlineKeyHandler Cmdlet, PowerShell Get-PSReadlineKeyHandler Cmdlet, PowerShell Remove-PSReadlineKeyHandler Cmdlet, PowerShell Set-PSReadlineOption Cmdlet, PowerShell Get-PSReadlineOption Cmdlet, PowerShell Format-Hex Cmdlet, PowerShell ConvertFrom-String Cmdlet, PowerShell ConvertTo-Html Cmdlet, PowerShell Select-XML Cmdlet, PowerShell Test-Json Cmdlet, PowerShell Get-TypeData Cmdlet, PowerShell Update-TypeData Cmdlet, PowerShell Remove-TypeData Cmdlet, PowerShell Register-ObjectEvent Cmdlet, PowerShell Register-WmiEvent Cmdlet, PowerShell Register-EngineEvent Cmdlet, PowerShell Unregister-Event Cmdlet, PowerShell Get-EventSubscriber Cmdlet, PowerShell Remove-Event Cmdlet, PowerShell Get-Event Cmdlet, PowerShell Wait-Event Cmdlet, PowerShell New-Event Cmdlet, PowerShell Send-MailMessage Cmdlet, PowerShell Test-Connection Cmdlet, PowerShell Get-WmiObject Cmdlet, PowerShell Get-CimInstance Cmdlet, PowerShell New-CimInstance Cmdlet, PowerShell Remove-CimInstance Cmdlet, PowerShell Set-CimInstance Cmdlet, PowerShell Invoke-CimMethod Cmdlet, PowerShell Import-Counter Cmdlet, PowerShell Export-Counter Cmdlet, PowerShell Get-Counter Cmdlet, PowerShell Add-Computer Cmdlet, PowerShell Rename-Computer Cmdlet, PowerShell Restart-Computer Cmdlet, PowerShell Stop-Computer Cmdlet, PowerShell Test-ComputerSecureChannel Cmdlet, PowerShell Reset-ComputerMachinePassword Cmdlet,
PowerShell: Effective PowerShell, PowerShell Standard Library, PowerShell Fundamentals - PowerShell Basic Commands, PowerShell Inventor - PowerShell Language Designer: Jeffrey Snover, Bruce Payette, James Truher (et al.) of Microsoft on November 14, 2006; PowerShell DevOps - PowerShell SRE, PowerShell in the Cloud (Azure PowerShell - AWS PowerShell - GCP PowerShell - VMware PowerShell), PowerShell Core, Windows PowerShell, Windows Server PowerShell, Linux PowerShell (PowerShell on Ubuntu, PowerShell on Debian, PowerShell on RHEL, PowerShell on Fedora - brew install powershell), macOS PowerShell - brew install powershell, Cloud Native PowerShell - PowerShell on Kubernetes - PowerShell on AWS - PowerShell on Azure - PowerShell on GCP), PowerShell Microservices, PowerShell Containerization (PowerShell Docker - PowerShell on Docker Hub), Serverless PowerShell, PowerShell Data Science - PowerShell DataOps - PowerShell and Databases (PowerShell ORM), PowerShell ML - PowerShell DL, Functional PowerShell (1. PowerShell Immutability, 2. PowerShell Purity - PowerShell No Side-Effects, 3. PowerShell First-Class Functions - PowerShell Higher-Order Functions, PowerShell Lambdas - PowerShell Anonymous Functions - PowerShell Closures, PowerShell Lazy Evaluation, 4. PowerShell Recursion), Reactive PowerShell), PowerShell Concurrency - PowerShell Parallel Programming - Async PowerShell, PowerShell Networking, PowerShell Security - PowerShell DevSecOps - PowerShell OAuth, PowerShell Memory Allocation (PowerShell Heap - PowerShell Stack - PowerShell Garbage Collection), PowerShell CI/CD - PowerShell Dependency Management - PowerShell DI - PowerShell IoC - PowerShell Build Pipeline, PowerShell Automation - PowerShell Scripting, PowerShell Package Managers, PowerShell Modules - PowerShell Packages, PowerShell Installation (PowerShell Windows - Chocolatey PowerShell (choco search powershell, choco install powershell-core), PowerShell macOS - Homebrew PowerShell, PowerShell on Linux), PowerShell Configuration, PowerShell Observability (PowerShell Monitoring, PowerShell Performance - PowerShell Logging), PowerShell Language Spec - PowerShell RFCs - PowerShell Roadmap, PowerShell Keywords, PowerShell Data Structures - PowerShell Algorithms, PowerShell Syntax, PowerShell OOP (1. PowerShell Encapsulation - 2. PowerShell Inheritance - 3. PowerShell Polymorphism - 4. PowerShell Abstraction), PowerShell Design Patterns - PowerShell Best Practices - PowerShell Style Guide - Clean PowerShell - PowerShell BDD, PowerShell Generics, PowerShell I/O, PowerShell Serialization - PowerShell Deserialization, PowerShell APIs, PowerShell REST - PowerShell JSON - PowerShell GraphQL, PowerShell gRPC, PowerShell Virtualization, PowerShell Development Tools: PowerShell SDK, PowerShell Compiler - PowerShell Transpiler, PowerShell Interpreter - PowerShell REPL, PowerShell IDEs (JetBrains PowerShell, PowerShell Visual Studio Code), PowerShell Linter, PowerShell Community - PowerShellaceans - PowerShell User, PowerShell Standard Library - PowerShell Libraries - PowerShell Frameworks, PowerShell Testing - PowerShell TDD, PowerShell History, PowerShell Versions, PowerShell Research, PowerShell Topics, PowerShell Uses - List of PowerShell Software - Written in PowerShell - PowerShell Popularity, PowerShell Bibliography - Manning PowerShell Series - PowerShell Courses, PowerShell Glossary - PowerShell Official Glossary, PowerShell GitHub, Awesome PowerShell, PowerShell Versions. (navbar_powershell)
SQL Programming Language, SQL SELECT, SQL FROM, SQL WHERE, SQL INSERT, SQL UPDATE, SQL DELETE, SQL INNER JOIN, SQL LEFT JOIN, SQL RIGHT JOIN, SQL FULL JOIN, SQL CROSS JOIN, SQL CREATE TABLE, SQL ALTER TABLE, SQL DROP TABLE, SQL CREATE DATABASE, SQL DROP DATABASE, SQL CREATE INDEX, SQL DROP INDEX, SQL CREATE VIEW, SQL DROP VIEW, SQL CREATE PROCEDURE, SQL DROP PROCEDURE, SQL CREATE FUNCTION, SQL DROP FUNCTION, SQL CREATE TRIGGER, SQL DROP TRIGGER, SQL CREATE SCHEMA, SQL DROP SCHEMA, SQL CREATE USER, SQL DROP USER, SQL CREATE ROLE, SQL DROP ROLE, SQL GRANT, SQL REVOKE, SQL COMMIT, SQL ROLLBACK, SQL SAVEPOINT, SQL TRANSACTION, SQL DISTINCT, SQL GROUP BY, SQL HAVING, SQL ORDER BY, SQL LIMIT, SQL OFFSET, SQL TOP, SQL UNION, SQL UNION ALL, SQL INTERSECT, SQL EXCEPT, SQL CASE, SQL CAST, SQL CONVERT, SQL COALESCE, SQL NULLIF, SQL IS NULL, SQL IS NOT NULL, SQL BETWEEN, SQL LIKE, SQL IN, SQL EXISTS, SQL ANY, SQL ALL, SQL COUNT, SQL SUM, SQL AVG, SQL MIN, SQL MAX, SQL CHAR, SQL VARCHAR, SQL TEXT, SQL NCHAR, SQL NVARCHAR, SQL NTEXT, SQL DATE, SQL TIME, SQL TIMESTAMP, SQL DATETIME, SQL SMALLDATETIME, SQL DATETIME2, SQL DATETIMEOFFSET, SQL YEAR, SQL BINARY, SQL VARBINARY, SQL IMAGE, SQL DECIMAL, SQL NUMERIC, SQL FLOAT, SQL REAL, SQL INT, SQL SMALLINT, SQL TINYINT, SQL BIGINT, SQL MONEY, SQL SMALLMONEY, SQL BIT, SQL ROWID, SQL XML, SQL JSON Support, SQL DEFAULT, SQL CHECK, SQL FOREIGN KEY, SQL PRIMARY KEY, SQL UNIQUE, SQL INDEX, SQL CLUSTERED INDEX, SQL NONCLUSTERED INDEX, SQL FULLTEXT INDEX, SQL SPATIAL INDEX, SQL HASH INDEX, SQL PARTITION, SQL TEMPORARY TABLE, SQL GLOBAL TEMPORARY TABLE, SQL LOCAL TEMPORARY TABLE, SQL CURSOR, SQL FETCH, SQL CLOSE CURSOR, SQL DEALLOCATE CURSOR, SQL EXECUTE, SQL PREPARE, SQL CALL, SQL BATCH, SQL MERGE, SQL UPSERT, SQL RENAME, SQL COMMENT, SQL ANALYZE, SQL EXPLAIN, SQL HINT, SQL WITH CLAUSE, SQL CTE (Common Table Expression), SQL RECURSIVE CTE, SQL WINDOW FUNCTIONS, SQL OVER, SQL PARTITION BY, SQL RANK, SQL DENSE_RANK, SQL ROW_NUMBER, SQL LAG, SQL LEAD, SQL FIRST_VALUE, SQL LAST_VALUE, SQL CUME_DIST, SQL PERCENT_RANK, SQL NTILE, SQL PIVOT, SQL UNPIVOT, SQL CASE WHEN, SQL CHARINDEX, SQL PATINDEX, SQL SUBSTRING, SQL REPLACE, SQL STUFF, SQL CONCAT, SQL CONCAT_WS, SQL TRIM, SQL LTRIM, SQL RTRIM, SQL LOWER, SQL UPPER, SQL REVERSE, SQL LEN, SQL LENGTH, SQL LEFT, SQL RIGHT, SQL SPACE, SQL STR, SQL ASCII, SQL UNICODE, SQL NCHAR FUNCTION, SQL CHAR FUNCTION, SQL CAST FUNCTION, SQL CONVERT FUNCTION, SQL ABS, SQL CEILING, SQL FLOOR, SQL ROUND, SQL POWER, SQL SIGN, SQL SQRT, SQL EXP, SQL LOG, SQL LOG10, SQL RAND, SQL SIN, SQL COS, SQL TAN, SQL COT, SQL ACOS, SQL ASIN, SQL ATAN, SQL ATN2, SQL DEGREES, SQL RADIANS, SQL PI, SQL GETDATE, SQL GETUTCDATE, SQL SYSDATETIME, SQL CURRENT_TIMESTAMP, SQL DATEADD, SQL DATEDIFF, SQL DATENAME, SQL DATEPART, SQL EOMONTH, SQL ISDATE, SQL DAY, SQL MONTH, SQL YEAR FUNCTION, SQL HOUR, SQL MINUTE, SQL SECOND, SQL MILLISECOND, SQL MICROSECOND, SQL TRY_CONVERT, SQL TRY_CAST, SQL TRY_PARSE, SQL PARSE, SQL ISNUMERIC, SQL IIF, SQL CHOOSE, SQL FORMAT, SQL COLLATE, SQL SET LANGUAGE, SQL SET DATEFORMAT, SQL TRANSLATE, SQL REPLICATE, SQL NTH_VALUE, SQL LISTAGG, SQL STRING_AGG, SQL JSON_VALUE, SQL JSON_QUERY, SQL JSON_ARRAY, SQL JSON_OBJECT, SQL JSON_MODIFY, SQL XML PATH, SQL XML FOR AUTO, SQL XML FOR EXPLICIT, SQL XML NODES, SQL XMLATTRIBUTES, SQL CAST (XML), SQL CROSS APPLY, SQL OUTER APPLY, SQL EXCEPT ALL (some DB), SQL INTERSECT ALL (some DB), SQL DATABASE, SQL TABLE, SQL COLUMN, SQL ROW, SQL INDEX STRATEGY, SQL Normalization, SQL Denormalization, SQL Referential Integrity, SQL Constraints, SQL Collation, SQL Distributed Transactions, SQL Linked Server, SQL Stored Procedure, SQL User-Defined Function, SQL Scalar Function, SQL Table-Valued Function, SQL Inline Table-Valued Function, SQL Stored Function (in some dialects), SQL Trigger AFTER, SQL Trigger BEFORE, SQL Trigger INSTEAD OF, SQL DDL (Data Definition Language), SQL DML (Data Manipulation Language), SQL DQL (Data Query Language), SQL DCL (Data Control Language), SQL TCL (Transaction Control Language), SQL ACID Properties, SQL Atomicity, SQL Consistency, SQL Isolation, SQL Durability, SQL Isolation Levels, SQL READ UNCOMMITTED, SQL READ COMMITTED, SQL REPEATABLE READ, SQL SERIALIZABLE, SQL SNAPSHOT, SQL Optimizer, SQL Execution Plan, SQL Index Seek, SQL Index Scan, SQL Table Scan, SQL Clustered Index Seek, SQL Clustered Index Scan, SQL Page Split, SQL Fillfactor, SQL Statistics, SQL Parameter Sniffing, SQL CTE performance, SQL Hints (e.g. WITH (NOLOCK)), SQL NOLOCK Hint, SQL FORCESEEK Hint, SQL MERGE Hint (Oracle), SQL USE INDEX Hint (MySQL), SQL Query Tuning, SQL Performance Profiling, SQL Query Plan Cache, SQL DBCC Commands (SQL Server), SQL CHECKDB (SQL Server), SQL CLUSTERED COLUMNSTORE INDEX, SQL NONCLUSTERED COLUMNSTORE INDEX, SQL Rowstore vs Columnstore, SQL Partitioned Table, SQL Partition Function, SQL Partition Scheme, SQL Database Backup, SQL Database Restore, SQL Point-in-Time Recovery, SQL Log Shipping, SQL Database Mirroring, SQL AlwaysOn Availability Groups, SQL Replication, SQL Snapshot Replication, SQL Transactional Replication, SQL Merge Replication, SQL CDC (Change Data Capture), SQL Change Tracking, SQL PolyBase (SQL Server), SQL Linked Server (SQL Server), SQL MySQL, SQL PostgreSQL, SQL SQLite, SQL MariaDB, SQL Firebird, SQL Oracle Database, SQL Oracle RAC (Real Application Clusters), SQL Oracle Exadata, SQL Oracle SQL Cloud Services, SQL SQL Server, SQL SQL Server 2017, SQL SQL Server 2019, SQL SQL Server 2022, SQL Azure SQL Database, SQL Azure SQL Managed Instance, SQL Azure Synapse Analytics, SQL AWS RDS for SQL Server, SQL Amazon Aurora (MySQL-compatible), SQL Amazon Aurora (PostgreSQL-compatible), SQL Amazon Redshift (SQL-based), SQL GCP Cloud SQL for MySQL, SQL GCP Cloud SQL for PostgreSQL, SQL GCP Cloud SQL for SQL Server, SQL IBM DB2, SQL IBM DB2 for z/OS, SQL IBM DB2 LUW, SQL CockroachDB, SQL YugabyteDB (Postgres-compatible), SQL MemSQL (SingleStore), SQL Snowflake (Cloud Data Warehouse), SQL Teradata, SQL Greenplum, SQL Vertica, SQL Netezza, SQL Exasol, SQL TimesTen, SQL SAP HANA, SQL MariaDB ColumnStore, SQL MySQL InnoDB Engine, SQL MySQL MyISAM Engine, SQL MySQL Memory Engine, SQL MySQL NDB Cluster, SQL MySQL Performance Schema, SQL MySQL sys Schema, SQL Oracle Autonomous Database, SQL Oracle Data Guard, SQL Oracle GoldenGate, SQL Oracle SQL Developer Tool, SQL Oracle Enterprise Manager, SQL SQL*Plus, SQL SQLcl, SQL psql (PostgreSQL), SQL pgAdmin (PostgreSQL), SQL pgDump (PostgreSQL), SQL pg_restore (PostgreSQL), SQL MySQL Workbench, SQL MySQL Shell, SQL mysql Command Line, SQL SQL Server Management Studio, SQL Azure Data Studio, SQL JetBrains DataGrip, SQL JetBrains DataSpell, SQL DBeaver, SQL Navicat, SQL Toad for Oracle, SQL Toad for SQL Server, SQL SQL Developer, SQL RazorSQL, SQL HeidiSQL, SQL phpMyAdmin, SQL DBVisualizer, SQL Aqua Data Studio, SQL Adminer, SQL SQuirreL SQL Client, SQL dbForge Studio, SQL Valentina Studio, SQL CLI Tools (like sqlcmd), SQL sqlcmd (SQL Server), SQL bcp (SQL Server), SQL sqlplus (Oracle), SQL impdp (Oracle Data Pump Import), SQL expdp (Oracle Data Pump Export), SQL orapki (Oracle) , SQL Redshift CLI , SQL psql CLI (PostgreSQL), SQL mysql CLI, SQL xtrabackup (MySQL), SQL Arctype , SQL SQLBench tools , SQL Percona Toolkit, SQL Non-Relational with SQL interfaces (Presto), SQL Trino (PrestoSQL), SQL Apache Hive (SQL-like), SQL Apache Drill (SQL-on-Hadoop), SQL Apache Phoenix (SQL on HBase), SQL PrestoDB, SQL Calcite (SQL Parser/Optimizer), SQL JOOQ (SQL DSL for Java), SQL Liquibase (DB Schema Migration), SQL Flyway (DB Schema Migration), SQL Alembic (for SQLAlchemy), SQL Knex.js (JS SQL Builder), SQL Diesel (Rust ORM with SQL), SQL SQLAlchemy (Python ORM), SQL TypeORM (TypeScript ORM), SQL Sequelize (Node.js ORM), SQL EF (Entity Framework for .NET), SQL NHibernate (.NET), SQL JPA (Java Persistence API), SQL Hibernate (Java ORM), SQL Ecto (Elixir ORM), SQL Doctrine (PHP ORM), SQL Laravel Eloquent (PHP ORM), SQL Rails ActiveRecord (Ruby ORM), SQL Django ORM (Python), SQL JOIN Strategies (Nested Loop, Hash Join, Merge Join), SQL Indexing Strategies (B-Tree, Hash, GIN, BRIN), SQL Partition Pruning, SQL Sharding, SQL Federation, SQL Materialized Views, SQL Columnstore Technology, SQL OLTP (Online Transaction Processing), SQL OLAP (Online Analytical Processing), SQL Data Warehouse, SQL ETL (Extract, Transform, Load), SQL ELT (Extract, Load, Transform), SQL SQL Injection (Security Issue), SQL Parameterized Queries, SQL Prepared Statements, SQL Transactions Autocommit, SQL Isolation in Transactions repeated, SQL Snapshot isolation repeated, SQL Row Versioning, SQL Deadlock, SQL Locking Mechanisms, SQL Pessimistic Locking, SQL Optimistic Locking, SQL Row-level Lock, SQL Table-level Lock, SQL Shared Lock, SQL Exclusive Lock, SQL Dirty Read, SQL Phantom Read, SQL Non-repeatable Read, SQL T-SQL (Transact-SQL for SQL Server), SQL PL/SQL (Procedural Language for Oracle), SQL PL/pgSQL (PostgreSQL Procedural Language), SQL MySQL Stored Routines, SQL MariaDB Stored Procedures, SQL Functions vs Procedures, SQL Temp Table vs Table Variable (SQL Server), SQL CTE vs Temp Table debate, SQL sys schema (MySQL), SQL INFORMATION_SCHEMA, SQL pg_catalog (PostgreSQL), sys.tables, sys.columns), SQL sp_who2 (SQL Server), SQL sp_configure (SQL Server), SQL DBCC CHECKDB (SQL Server), SQL DBCC CHECKALLOC (SQL Server), SQL DBCC CHECKTABLE (SQL Server), SQL Full-Text Search, SQL LIKE wildcard '%', SQL LIKE wildcard '_', SQL RLIKE (MySQL) regex, SQL SIMILAR TO (PostgreSQL), SQL GLOB (SQLite), SQL MERGE Statement (SQL Server, Oracle), SQL REPLACE (MySQL), SQL ON DUPLICATE KEY UPDATE (MySQL), SQL UPSERT (some dialects), SQL EXPLAIN ANALYZE (PostgreSQL), SQL SHOW PLAN (SQL Server), SQL SHOW CREATE TABLE (MySQL), SQL SHOW CREATE DATABASE (MySQL), SQL DESCRIBE TABLE, SQL EXPLAIN PARTITIONS (MySQL), SQL VACUUM (PostgreSQL), SQL ANALYZE TABLE (MySQL), SQL OPTIMIZE TABLE (MySQL), SQL CHECKSUM TABLE (MySQL), SQL FLUSH PRIVILEGES (MySQL), SQL REPAIR TABLE (MySQL), SQL mysqldump (MySQL Backup), SQL mysqlimport (MySQL Import), SQL pg_basebackup (PostgreSQL), SQL pg_rewind (PostgreSQL), SQL pgbouncer (Connection Pool), SQL pgpool-II (Connection Pool), SQL MHA (MySQL High Availability), SQL Orchestrator (MySQL failover) , SQL HA features in SQL Server (AlwaysOn), SQL InnoDB Lock Monitor (MySQL), SQL Performance Schema (MySQL), SQL sys.dm_ views (SQL Server Dynamic Management Views), SQL WAITFOR DELAY (T-SQL), SQL RAISERROR (T-SQL), SQL sp_executesql (T-SQL), SQL xp_cmdshell (T-SQL) (Security risk), SQL Oracle SQL Plus scripts, SQL Oracle Plan Guides, SQL Redwood interface (Oracle old) , SQL CUBRID (another DB), SQL H2 Database, SQL HSQLDB, SQL Derby (Java DB), SQL IBM Informix, SQL SAP ASE (Sybase), SQL Sybase (Old), SQL Progress OpenEdge (SQL engine), SQL InterBase, SQL Firebird repeated, SQL Drizzle (MySQL fork), SQL MariaDB ColumnStore repeated, SQL MySQL Document Store, SQL MyRocks (MySQL engine), SQL Oracle Cloud Autonomous Data Warehouse, SQL AWS Aurora MySQL compatible repeated, SQL AWS Aurora PostgreSQL compatible repeated, SQL GCP BigQuery (SQL-like), SQL Qubole SQL service , SQL Azure Data Factory (ETL) , SQL Azure Data Lake (SQL On top) , SQL T-SQL Memory-Optimized Tables, SQL T-SQL Table Variable Deferred Compilation , SQL Bulk Insert, SQL BCP Utility (SQL Server), SQL SQL*Loader (Oracle), SQL COPY Command (PostgreSQL), SQL LOAD DATA INFILE (MySQL), SQL Import Export Wizard (SQL Server), SQL Data Pump (Oracle) repeated , SQL Migration Tools, SQL Database Migrations.
SQL: SQL Fundamentals, SQL Inventor - SQL Language Designer: Donald D. Chamberlin and Raymond F. Boyce from IBM San Jose Research Laboratory in 1974 after learning about the relational model from Edgar F. Codd; SQL DevOps - SQL SRE, Cloud Native SQL (SQL on Kubernetes - SQL on AWS - SQL on Azure - SQL on GCP - SQL on Mainframe), SQL Microservices, SQL Containerization (SQL Docker - SQL on Docker Hub), Serverless SQL, SQL Data Science - SQL DataOps - SQL and Databases (SQL ORM), SQL ML - SQL DL, Database - Database Fundamentals, Relational Databases (Oracle Database, MySQL, SQL Server (T-SQL - Transact-SQL), PostgreSQL, IBM Db2, Azure SQL Database, Snowflake, Google BigQuery, Google BigTable, SQLite), Functional SQL (1. SQL Immutability, 2. SQL Purity - SQL No Side-Effects, 3. SQL First-Class Functions - SQL Higher-Order Functions, SQL Lambdas - SQL Anonymous Functions - SQL Closures, SQL Lazy Evaluation, 4. SQL Recursion), Reactive SQL), SQL Concurrency SQL and ACID - SQL Parallel Programming - Async SQL, SQL Networking, SQL Security - SQL DevSecOps - SQL OAuth, SQL Memory Allocation (SQL Heap - SQL Stack - SQL Garbage Collection), SQL CI/CD - SQL Dependency Management - SQL DI - SQL IoC - SQL Build Pipeline, SQL Automation - SQL Scripting, SQL Package Managers, SQL Modules - SQL Packages, SQL Installation (SQL Windows - Chocolatey SQL, SQL macOS - Homebrew SQL, SQL on Linux), SQL Configuration, SQL Observability (SQL Monitoring, SQL Performance - SQL Logging), SQL Language Spec - SQL RFCs - SQL Roadmap, SQL Keywords, SQL Operators, SQL Functions, SQL Data Structures - SQL Algorithms, SQL Syntax, SQL OOP (1. SQL Encapsulation - 2. SQL Inheritance - 3. SQL Polymorphism - 4. SQL Abstraction), SQL Design Patterns - SQL Best Practices - SQL Style Guide - Clean SQL - SQL BDD, SQL Generics, SQL I/O, SQL Serialization - SQL Deserialization, SQL APIs, SQL REST - SQL JSON - SQL GraphQL, SQL gRPC, SQL Virtualization, SQL Development Tools: SQL SDK, SQL Compiler - SQL Transpiler, SQL Interpreter - SQL REPL, SQL IDEs - Database IDEs (JetBrains DataSpell, SQL Server Management Studio, MySQL Workbench, Oracle SQL Developer, SQLiteStudio, JetBrains SQL, SQL Visual Studio Code), SQL Linter, SQL Community - SQLaceans - SQL User, SQL Standard Library - SQL Libraries - SQL Frameworks, SQL Testing - SQL TDD, SQL History, SQL Research, SQL Topics, SQL Uses - List of SQL Software - Written in SQL - SQL Popularity, SQL Bibliography - Manning SQL Series - Manning Data Science Series - SQL Courses, SQL Glossary - SQL Official Glossary, SQL GitHub, Awesome SQL. (navbar_sql - see also navbar_database, navbar_postgresql, navbar_sqlserver, navbar_mysql)
Manning Publications: Manning Books Purchased by Cloud Monk, Manning Books Series, Manning Bibliography, In a Month of Lunches, In Action, Manning API Series, Manning "Functional Programming in" Series, Manning Concurrency Async Multithreaded Parallel Programming Series, Manning Grokking Series, Manning Java-JVM Languages Series (Manning Java Series, Manning Kotlin Series), Manning JavaScript Series, Manning TypeScript Series, Manning Microservices Series, Manning Python Series, Manning Security Series, Manning Spring Series, Manning SQL Series, Manning Database Series, Manning Data Science Series, Manning Mistakes and How to Avoid Them Series, Manning Books that were Cancelled, MEAP, Cloud Monk's Book Purchases, Cloud Monk Library. (navbar_manning)
Cloud Monk is Retired ( for now). Buddha with you. © 2025 and Beginningless Time - Present Moment - Three Times: The Buddhas or Fair Use. Disclaimers
SYI LU SENG E MU CHYWE YE. NAN. WEI LA YE. WEI LA YE. SA WA HE.