FileTables is a new feature introduced in SQL Server 2012. It's a unique table that reflects metadata of files in a specified folder. The file attributes can then be modified either through SQL ...

My SQL Server Log File is too big!!! Your email has been sent ... even if you haven’t ran into problems yet. The following query can be used to determine the recovery model of the databases ...

“Data Lake Virtualization integrates PolyBase with S3-compatible object storage, which adds support for querying parquet files ... SQL database.” SQL Server 2022 has more Intelligent Query ...

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial ... Now that we have downloaded the executable file for SSMS, we can trigger ...

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 extension, and you use them to restore database ...

In SQL Server 2016, Microsoft introduced the Query Store, a feature set designed to capture performance information around query execution. This allows the administrator to quickly identify a ...

In this two-part series, I'll tell you about some improvements Microsoft is making in SQL Server 2022 to improve cardinality estimates and deal with another common query optimization concern ...

So what Microsoft is doing with SQL Server is adding new connectors that allow business to use SQL Server to query other databases ... for Spark and the Hadoop File System. That’s an ...

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.