Create Power BI Connection to Azure SQL Database
Learn how to use Power BI to retrieve data from an Azure SQL Database.
What should you do about memory dumps?
A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.
Building Better Stored Procedures
In a followup, this article includes discussion of more advanced features of using stored procedures.
Introduction to SQL Server Security — Part 3
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
Badly Encrypted Databases
Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.
Using Client Tools - Level 4 of the Stairway to SQL Server on Linux
In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.
SQL Server Referential Integrity Across Databases Using Triggers
In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.
Dealing with Technical Debt
Technical debt can cripple software development, much like financial debt hurts individuals and organizations. Steve wants to know if you measure your debt today.
Isolation Levels in SQL Server
Details discussion on the different isolation levels available in SQL Server
A Re-Introduction to HIPAA and SOX
SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.
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 Kapasan No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasan 155, RT.007/RW.09, Kapasan, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Jembatan Merah Plaza No.Telp 083831617937
Whatsapp.083831617937 Ruko Jembatan Merah Plaza Blok A No. 36-37, 38-39 Surabaya, Jawa Timur, Indonesia...
BCA KCP Jagalan No.Telp 083831617937
Whatsapp.083831617937 Jl. Jagalan No. 117 B, Peneleh, Kec. Genteng, Kota SBY, Jawa Timur Surabaya,...
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