The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
Using Recommendations for MAXDOP and Max Memory During Installation
Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]
Getting Started with Delta Lake Using Azure Data Factory
This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.
Database Modeling - Relationships
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
The Challenges of Resetting Databases
The challenges of state in databases can impact our development efforts.
So, You Want to Be a DBA…
Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.
Learning Isn’t Easy, But It’s Vital
This week Grant notes that we need to work on our learning skills, especially as the world continues to drive forward.
Database Snapshot Use Case: Service Migration
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
Delivering in a Day
This week Steve wonders if you're want to tackle an exciting project for a day or a week.
Reverse-Engineering the Production Database into Source Control
Starting out a new database development with source control is relatively easy. To introduce source control into an existing database application can be more challenging. Phil Factor explains some of the fundamental steps.
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 Tebet Tlpn/Wa:6285188120691
Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet Bar.,...
BCA KCP Mega Kuningan Tlpn/wa:085373737551
Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi, Kota Jakarta...
BCA KCP Cilandak KKO I Tlpn/Wa:6285188120691
Jl. Raya Cilandak KKO No.9, Ragunan, Ps. Minggu, Kota Jakarta Selatan, 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