Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

I'm considering dumping our transaction logs to disk more frequently/truncating our logs more frequently. We don't provide up to the second-last successfull transaction restoration in this particular ...

I'm trying to recover an earlier version of a database from a tape. I've got the bak file and all of the TRNs in a folder on a different server (wanted to restore it to our testlab sql server). From ...

LUMIGENT TECHNOLOGIES ON Monday plans to release Log Explorer Version 3.0, which allows users to identify causes of problems in Microsoft SQL Server databases and recover data. The product uses the ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

(MENAFN- EIN Presswire) Devart has released an update for Transaction Log. The new version introduces online audit and rollback of transactions. PRAGUE, CZECH REPUBLIC, November 24, 2020 / ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

SAN DIEGO, CA--(Marketwired - Oct 9, 2013) - Astute Networks ™, Inc., the leading provider of Networked Flash ™ appliances, will showcase its ViSX for SQL Server Performance Storage Appliance at next ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.