Think NOLOCK makes your queries untouchable? There's a hidden lock that can still bring everything to a grinding halt - and most developers never see it coming. dataservicesgroup.com.au/your-nolock-qu… #SQLServer #SQLDatabase #SQLPerformance

SQL in Microsoft Fabric is built for modern data work. One system for #analytics and transactions. Auto scaling that adjusts as usage grows. Security and source control are built in from day one. If you’re exploring #MicrosoftFabric and #SQLDatabase basics, checkout below 👀

OPENROWSET and External Tables for Fabric SQL Databases #SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake blog.fabric.microsoft.com/en-US/blog/ope…

Happy New Year! Let's kick it off with Auditing in #Fabric #SQLDatabase with @SQLBalls !! How do we turn it on and how do we query the Audit log? We'll look at this together! Link: youtu.be/v_8KKpoDopI cc @DBABullDog @BradleySchacht @neeraj_jhaveri @JoshLuedeman

Regular SQL maintenance boosts performance and security, strengthened by Qdexi Technology’s expert database support. Read More: qdexitechnology.com/blog/why-is-re… #SQLDatabase #DatabaseMaintenance #DataHealth #DBOptimization #ServerPerformance #TechManagement #QdexiTechnology

#Day2 #sqldatabase db, dbms, sql (reldb) vs nosql, joins (inner, outer, full, cross, natural, self), why joins, CIE, remove duplicate records, subquery, sql vs mysql, IN vs EXISTS, EXISTS vs JOIN, where vs having, between, trigger, second highest salary, views.