SQL Server security basics (complete guide) A complete guide to SQL Server security: authentication, permissions, contained databases, built-in accounts, encryption, auditing, and vulnerability tools.…
The ‘Normal Forms’ set of database design rules (complete guide) Proper data normalization is a critical concern in database design, controlled by a set of data modeling rules known as the “normal...
The complete guide to dbt (data build tool) What is dbt (data build tool), how does it work, and why should you use it? Learn everything you need...
How to get started with PostgreSQL (complete step-by-step guide) This is Grant Fritchey's complete set of hands-on labs for getting started with PostgreSQL - designed for any IT professional...
Oracle 26ai Deep Data Security (DeepSec): the complete guide Learn everything you need to know about Oracle Deep Data Security (DeepSec) with Oracle veteran Jim Czuprynski's detailed, step-by-step guides.…
Fabiano Amorim’s complete guide to SQL Server security SQL Server security expert Fabiano Amorim's complete guide to SQL Server security. Learn essential tips and tricks, best practices, and...
How to use GitHub Actions (complete guide) GitHub Actions step-by-step guides and tutorials: what GitHub Actions is, how it works, how to create a workflow, using runners,...
How to build a career in data: top tips from those who’ve done it (complete series) Do you want a career in data? Maybe you're a recent grad, or perhaps you've tired of your current role...
How to become a database administrator (DBA) – the complete ‘DBA in Training’ series Learn how to become a DBA (database administrator) - plus, learn the all the essentials of SQL Server, from the...
Windows containers & Docker basics: a complete guide Complete guide to Windows containers and the basics of Docker: how they work, creation and management, and more.…
Window function performance in SQL Server: a complete guide Learn everything you need to know about window function performance in SQL Server.…
AI text embeddings in SQL Server: complete guide Complete guide to AI text embeddings in SQL Server, featuring everything you need to know - with tips, advice and...
Oracle SQL query parsing: a complete guide Here's everything you need to know about Oracle SQL query parsing in one detailed mini-series.…
The complete guide to SQL in Cosmos DB Cosmos DB is a multi-model NoSQL database. However, one of the models it handles - the document database - can...
Overlap queries in PostgreSQL: a complete guide Learn everything you need to know about overlap queries in PostgreSQL: complete guide featuring expert advice, examples, and sample code.…
The complete guide to Row-Level Security (RLS) in SQL Server Learn everything you need to know about SQL Server Row-Level Security (RLS) with this complete, six-part deep-dive series.…
How I built an app just by talking to an AI LLM (the complete series) Can you build an app, from the ground up, just by talking to an AI LLM? Find out in this...
SQL Server security vulnerabilities you weren’t aware of SQL Server has a surprising number of security vulnerabilities, potentially leading to severe consequences. In this series, learn all about...
Startup Stories – the good, bad, and ugly of startups Simple Talk's Startup Stories series - highlighting the good, bad and ugly of startups, and lessons learned along the way!…
Database questions you were ‘Too Shy to Ask’ – the complete series Whether you're confused about SQL Server foreign keys, curious about data security, or just want to know everything about T-SQL...
