What is Code Coverage For?
Code coverage is a practice that goes hand in hand with automated testing, reporting the percentage of your code that has been exercised during a test run. Ed Elliott and Redgate have partnered to make a code coverage tool available for SQL Server, both free and open source. SQL Cover measures the coverage of your SQL Server stored procedures and functions. It has built-in support for the popular tSQLt unit testing framework, but can also be used alongside any automated testing framework of your choosing. Find out more in this blog post.
Changes to a Writable Partition May Fail Unexpectedly
Paul White shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.
How to fix SQL Server deadlocks with monitoring
Learn about deadlocks and how you might better troubleshoot the issues involved.
The 2015/2016 Simple-Talk Awards: Winners Announced
The 2015/16 Simple-Talk Awards have concluded, the votes have been counted and recounted, and the winners have now been announced.
Hunting in Packs
Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.
The Data Dewey Decimal System
Steve Jones looks at the idea of cataloging our data sets in order to make it easier for
Getting Started with Temporal Table in SQL Server 2016 – Part 1
With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.
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 CBD Pluit Tlp (+62 821°3111°179
Kawasan Hunian dan Bisnis Terpadu, CBD Pluit, Jl. Pluit Selatan Raya Blok B No....
BCA Finance Pekalongan Telpon/WA:08137887595
BCA Finance Pekalongan Telpon/WA:08137887595.Bentengan, Bener, Kec. Wiradesa, Kabupaten Pekalongan, Jawa Tengah 51152
BCA KCP Mangga Besar,Telp/Wa 0821.3111.159
Jl. Raya Mangga Besar No.15, RT.6/RW.5, Mangga Besar, Kec. Taman Sari, Kota Jakarta Barat,...
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