Get Patched If Not Supported
Many organizations that run older versions of SQL Server are not patched.
Getting Sneaky With Forced Parameterization
In which Erik works around the documented limitations with CROSS APPLY.
SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
Power BI Introduction: Visualizing SQL Server Audit Data — Part 9
SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
Code Reviews
This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.
Streamline Log Shipping Failovers: DR Made Just For You…
A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.
Not So Forced Parameterization
If you can't get forced parameterization to work due to variables, try using a temp table instead.
There is a New COUNT in Town
Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this article, Greg Larson tests the new APPROX_COUNT_DISTINCT function for performance and accuracy.
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 Finance Tangerang Layanan Mobil Telpon/WA:085188120691
BCA Finance Tangerang Layanan Mobil Telpon/WA:085188120691 Scientia Garden, Jl. Gading Serpong Boulevard No.1 Blok...
BCA KCU HARAPAN INDAH Telpon/WA:085188120691
BCA KCU HARAPAN INDAH Telpon/WA:085188120691 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2...
BCA MULTI FINANCE CAB SUNTER Telpon/WA:085188120691
BCA MULTI FINANCE CAB SUNTER Telpon/WA:085188120691 Ruko Danau Sunter Utara, BLK. a 36D Jl....
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