Triple Check Your Restores
After the crash of an US Air Force database was reported, Steve Jones has some advice.
Be the first to try Redgate SQL Compare 12
We are excited to announce the beta release of SQL Compare & SQL Data Compare 12. We want to use this beta period to get as much feedback from you, the SQL community, as possible. Try it out, or for more information on what’s new, read on.
Improved Support for Parallel Statistics Rebuilds
Jonathan Kehayias takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
SQL Server 2016 is Just Faster
SQL Server 2016 runs faster, sometimes without you changing anything.
What SQL Statements Are Currently Using The Transaction Logs?
This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.
How to version a SQL Server Master Data Services model
In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. In this article, Siddarth Mehta covers the standard process that's required to release a completed version of the model to subscribers.
Master Data Management (MDM): Help or Hindrance?
Knut Jürgensen shares his experiences, both positive and negative, with regard to the function that Master Data Management fulfils within a company. Too often this critical aspect of a business is overlooked or pushed aside without paying it the attention it deserves based on the cost benefits available.
Stretch Pricing
The Stretch database feature in SQL Server 2016 is fantastic, but is it too expensive?
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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