Stairway to U-SQL Level 9: Views and C# Expressions
Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.
Beginner Guide to In-Memory Optimized Tables in SQL Server
Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table do not need locks, therefore eliminating blocking and deadlocking. In this Article, Monica Rathbun demonstrates how to get started using memory optimized tables.
Using SQL Prompt Code Snippets for Repetitive Tasks
Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.
The Evolution of AI
Artificial Intelligence systems might dramatically change our world, but they need lots of help and work to get better.
Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments
Phil Factor shows you how to prevent constraint violations from ‘breaking the build’, during SQL Compare deployments, by ferreting out any conflicting rows in advance, and developing a script to fix the data.
SQL Server Checkpoint Monitoring with Extended Events
In this article Aaron Bertrand looks at how to use SQL Server Extended Events to monitor performance of checkpoints for databases not using indirect checkpoints.
Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
What Happened to Hadoop?
For a time, it seemed that everyone wanted to build a Hadoop system. The world has changed, and that's not as popular an idea as it used to be. Today, Steve has a few thoughts.
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 Grand Sudirman Telp:Cs.08216977726
Whatsapp:08216977726 Ruko Grand Sudirman, Jl. P.B. Sudirman Blok C5-C6, Dauh Puri Klod, Kec. Denpasar...
BCA KCP Taman Palem Lestari Hub.0813•7887•595
BCA KCP Taman Palem Lestari Hub.0813•7887•595.Komp. Perum Jl. Taman Palem Lestari No.C5 No. 9...
BCA KCP Klampis No.Telp:087757645171
Whatsapp:087757645171 Ruko Sinar Galaxi, Jl. Klampis Jaya No.92-94, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
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