How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
Checking the pulse of Kubernetes
In this article, Michael Sorens describes the many ways that you can monitor Kubernetes.
Creating a SQL Code Snippet in SQL Prompt and SSMS
Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets.
Stairway to XML: Level 3 - Working with Typed XML
You can enforce the validation of an XML data type, variable or column by associating it with an XML Schema Collection. SQL Server validates a typed XML value against the rules defined in the schema collection so that INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.
Bridging the divide between Data Management and DevOps
The speed, flexibility and collaboration of DevOps can be difficult to achieve against the rigid schemas, manual processes, and silos in the world of data management. Join Microsoft Data Platform MVP, Grant Fritchey to discover the key strategies you can implement to bridge the divide between data management and DevOps in your organization.
Free eBook: Understanding SQL Server Concurrency
When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.
SQL Server Clustered Index Fragmentation on GUID Columns
In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.
Block user objects from being created in a master database
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
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 Santa Telpon/WA:085188120691
BCA KCP Santa Telpon/WA:085188120691 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta...
BCA KCP Wahid Hasyim Telpon/WA:087768193341
BCA KCP Wahid Hasyim Telpon/WA:087768193341.Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota...
BCA KCP Raden Saleh Telpon/WA:087768193341
BCA KCP Raden Saleh Telpon/WA:087768193341.Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota...
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