Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor March 4, 2004 at 12:45 a.m. PT ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it ...

The big data odyssey of SQL Server 2019, and more data and AI news from Microsoft Ignite; Review: SQL Server 2017 adds Python, graph processing and runs on Linux; Links to Managed Instance and Synapse ...