How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.
How to Connect to an Analysis Services Database in Power BI
Learn how to work with SSAS data in Power BI in this article.
Taming Database Documentation with Flyway and MySQL
Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.
T-SQL Comment Best Practices for SQL Server
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
Time To Recharge
Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday. I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll […]
Linked Servers: a Peek Behind the Curtain
Learn how a linked server caused an issue with Gallium Data.
Which Work Is Suited for In-Person?
What is the best way to use an office? Or is there even a best way? Steve asks the question today.
[From the archives] Your guide to choosing the right monitoring tool [Video]
Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.
SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2
In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.
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 KCU INDRAPURA 082225313145 WA CS
WhatsApp 082225313145 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Alamat Kontak BCA KCP Semut 082225313145 WA CS
WhatsApp 082225313145 Jl. Bongkaran No.17-19, Bongkaran, Kec. Pabean Cantian, Surabaya, Jawa Timur 60161
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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