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.
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
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kerobokan Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Raya Kerobokan No.8, Kerobokan Kelod, Kec. Kuta, Kabupaten Badung, Bali 80361
BCA KCP Graha Paramita No tlpon:083138717148
Whatsapp:083138717148. Jl. Denpasar Raya Blok D-2, Daerah Khusus Ibukota Jakarta 12940
BCA KCP Trenggalek telp:cs.083188951403
Whatsapp:083188951403 Jl. Panglima Sudirman No.27, Sawahan, Sumbergedong, Kec. Trenggalek, Kabupaten Trenggalek, Jawa Timur 66315
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers