Moving beyond principal components analysis
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
The Work of the Ancients
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
Find SQL Server Installation Date for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
Foreign Keys and Multi-Table Inserts in Oracle
Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...
Free Solution Brief – Dedicated Database Environments for Dev, Test and CI
Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.
Feedback and Change
Today Steve asks you to be a part of the change you'd like to see in our professional organization.
The Basics of INCLUDE
Learn how the INCLUDE phrase of an index can change the performance of a query.
Handling Tricky Data Migrations during State-based Database Deployments
This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst preserving existing data.
SQL Server Management Studio is as Relevant as Ever
In this Simple Talk editorial Kendra Little discusses how SSMS is as relevant as ever.
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Purwosari +62 838-4945-0961
Wa:083849450961 Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta,...
Telp BCA KCU SOLO SLAMET RIYADI +62 838-4945-0961
Wa:083849450961 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta, Jawa...
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers