Database Ledger in SQL Server 2022
Learn how ledger databases and ledger tables work in SQL Server 2022.
Limiting the Ability to Concentrate and Collaborate
Open offices have an interesting side effect: less collaboration.
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has been given a name, and a parameter list, so can be used like an inline macro. Technically, you’re supposed to think of it as a virtual table.
I Love Editorials
Why do I love editorials, I can hear you asking. The answer is simple. It's all about opinions. I have opinions. Lots of them. Lots and lots of them. I'm flying home from Hong Kong after visiting a Redgate customer. They are doing amazing work.. It's so cool getting to see how people are solving […]
Building a RESTful API with FastAPI and PostgreSQL
This article shows how to use Python to create a REST API for your application that developers can use to access the database.
The Journey to PostgreSQL (or anything)
Learning is fundamental in technology. Steve has a few thoughts on adopting a new technology at work.
T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell Script
Most SQL bulk insert and SQL Server openrowset tutorials skip file access issues that can stop imports cold. Both the bulk insert statement and openrowset function rely on the SQL Server service account to read a source file. The SQL Server service account must have read permission on the file or its folder. It is also convenient to have read & execute as well as list folder content permissions.
No, Accelerated Database Recovery Doesn’t Fix NOLOCK.
I have never seen a T-SQL feature that people love as much as NOLOCK.
Migrate SSRS Reports to a New Server in Just a Few Clicks
Learn how to migrate SSRS reports to a new server using SSRS Reports Migration Wizard. Step-by-step guide to move reports, data sources, and datasets in just a few clicks.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCP Pulogadung Trade Centre Tlp:08218200174
Telp/WA 62 8218200174 Kw. Industri Pulogadung, Jl. Raya Bekasi Km. 21, Ruko No.A2/18-19, RW.3,...
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers