Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

I'm having to robocopy SQL 2005 dbs to another server for backup, and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days?

Joey on SQL Server A Deep Dive into SQL Server 2022's Query Performance Features, Part 1 An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the ...

How to Open a Microsoft SQL Server .Bak File. You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file ...

Learn how to install and configure SQL Server Management Studio, download a SQL Server, and connect them on a Windows 11/10/Server computer..

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

But there is more! SQL Server 2019 will come with built-in support for Spark and the Hadoop File System. That’s an acknowledgement of the popularity of these open-source tools, as well as the ...