What’s in that database? Getting information about routines
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.
How SQL Server Can Just Go Faster
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 […]
View R Plots from within SQL Server Management Studio
Describes how to view R plots in SSMS and gives a brief introduction to R plotting
Power BI Filter Pane
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.
The Road to Database CI
One firm's journey on the road to mastering (or at least attempting) continuous database integration.
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
Finding Correlated Rows Using EXISTS or COUNT
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.
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 Gatot Subroto Barat No. Telpon 087781685658
WHATSAPP 087781685658 Jl. Gatot Subroto Barat No.334 Blok B, Padangsambian Kaja, Kec. Denpasar Bar.,...
BCA KCP Taman Melati Telpon. 08388331767
WhatsApp 08388331767 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji,...
BCA Finance Tlpn/Wa:+6285188120691
Jl. Sunset Road No.88 B, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361
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