An Age of AI?
The age of artificial intelligence seems to be here, but it's a little different to what we were promised.
Data Transfer Strategies between MongoDB and SQL Server
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
How to find Updated Column in SQL Server Trigger
In this tip we look at how to which columns have been updated when using a SQL Server trigger by using the update and columns_updated functions
Changing Hardware
AMD has new chips coming out and Glenn Berry changes his recommendation against using AMD in SQL Servers.
Are Windows Containers a Good Choice?
Steve doesn't think Windows containers are the future for the data platform.
SQL-On-Hadoop: Hive - Part I
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
Running Linux SQL Server as a Container
Phil Factor starts a series of articles that will demonstrate the use of temporary SQL Server instances, running in Linux containers, into which we can deploy the latest database build, stocked with data, for development and testing work. This initial article shows how to set up a SQL Server instance inside a Linux Docker container, create some sample databases, and persist data locally.
SQL Server Clustered Tables vs Heap Tables
One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.
The AI Manager
AI software is being used to manage the daily work of some employees. Is this a trend that is good or bad?
Testing Databases: What’s Required?
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers