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 ...

I have a SQL Server database that's 145GB, about 80% of that space is occupied by "files". Staff have the ability to upload files from the web front end application into the database, this is used to ...

Microsoft announced a roadmap shift, indicating that it will focus on supporting Open Database Connectivity for SQL Server application programming interfaces in the near future. The shift is of ...

PipelineDB, a Y Combinator Winter 2014 graduate, announced the availability of the open source version of its streaming SQL database product today. A commercial version is expected later this year.

I'm trying to connect to an Excel spreadsheet and populate it with data. Ideally, I'd like to be able to create the file on a remote machine. Here's the test SQL I ...