There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
Describes how to view R plots in SSMS and gives a brief introduction to R plotting
Data Filtering | Configurations - In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
One firm's journey on the road to mastering (or at least attempting) continuous database integration.
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
WHATSAPP 087781685658 Jl. Gatot Subroto Barat No.334 Blok B, Padangsambian Kaja, Kec. Denpasar Bar.,...
WhatsApp 08388331767 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji,...
Jl. Sunset Road No.88 B, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers