SQL Saturday #327 - Johannesburg
SQL Saturday is coming to Johannesburg on August 30. Join in for a free day of SQL Server training and networking. Register while spaces are available.
The SQL of Membership: Equivalence Classes & Cliques
It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical properties needed for an equivalence relationship.
Introducing the Columnstore Index
A brief overview of Columnstore index and its usage with an example
What do you consider important when performance testing?
What data specific considerations do you make when preparing for performance testing?
The Road To Hell - new article from the DBA Team
Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.
Getting Started with Hashing in SQL Server
Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Here's how to get started using it.
Getting It Right First Time. Almost?
Mistakes happen but how can we minimize them and deal with them whey they do happen?
Linked Server Tribulations In SQL Server
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
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
Tips cara buka blokir bank JAGO Salah Autentikasi?
Berikut cara buka blokir Bank JAGO terkunci, Anda bisa Hubungi call center bank JAGO...
Cara buka blokir BWS Mobile banking
Berikut cara buka blokir BWS mobile, Anda bisa Hubungi Call Center BWS mobile via...
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
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