Write more compact SQL Server code using new features
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
Adding Disks - Level 3 of the Stairway to SQL Server on Linux
In this level we examine how to add disks to separate our data, log, and tempdb files.
Lax Security is Harmful for Employment
Data breaches do more than harm an organization. There's a human cost.
Transferring Data with JSON in SQL Server
JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.
Overview of Azure SQL Database Information Protection
Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.
Cost estimation for SQL Server Azure VMs
This article provides pricing guidance for SQL Server virtual machines in Azure.
Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
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
Alamat BCA KCU BUKIT BARISAN Telp/WA:0817629933
Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
BCA KCP Kas Narogong Tlpn/wa:085373737551
Jl. San Francisco Narogong - Cileungsi; No. 6 & 7, Limus Nunggal, Kec. Cileungsi,...
BCA KCU THAMRIN. Tlp:(+62) 823-72744391
Menara BCA, Grand Indonesia, Jl. MH Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
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