Ok, so my boss wants me to find out about making some log files smaller. For example, one database has a data file that's about 50 MB, and the log file is about 550MB. He wants to clear up space and a ...
The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...
Idera, a provider of Microsoft SQL Server management and administration tools, announced SQL virtual database 1.3, the latest release for this solution that enables backup files to look and act just ...
If you are still working on SQL Server 2000 (as many of our customers are), here’s another reason to upgrade to a newer version. One area that has improved vastly is file-level security. SQL Server ...
One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...
A solid database backup plan is just as critical in the cloud as it is on-premise, but running SQL Server on Azure virtual machine introduces a few new issues. Presented by Datavail's Andy McDermid ...
Microsoft Corp. today is introducing updates across its database portfolio as part of general availability announcements for Azure DocumentDB and SQL Server 2025.