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.
Using Attributes with Unity
Attributes in Unity allow you to add features like strings and menu items to objects. In this article, Lance Talbert shows you how to add attributes that can then be tested while in editing mode.
Connecting - Level 4 of the Stairway to Azure SQL Database
Learn how to configure connectivity and firewall rules for your Azure SQL Database
DevOps and OSS Can Scale
Microsoft has embraced open source software, and has opened much of their code. They have also proven that DevOps development can scale in this environment.
Monitoring your servers and databases with SCOM and SQL Monitor
SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.
SQL and T-SQL for Beginners in 229 minutes
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers