I have a site on a shared server using MS SQL Server 2005. My allocated SQL Server space is 400MB; however, the DB regular goes beyond that (650MB most recently) and I need to connect to the server ...

This tool is designed to clean up and shrink SQL Server databases based on specified configurations. It processes tables exceeding a defined row threshold and shrinks the database to optimize storage.

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Going forward, there is little question that containers have become firmly established as the technology of choice for application deployment – at least until such a time as alternative approaches ...

Do you have a large data import that leaves your indexes less than perfect? Do you want to backup your current database before you run a purge package? You are in luck; SSIS contains a handful of ...

Data Access Migration Toolkit (DAMT) is a VS Code extension that help users identify SQL code in application source code when migrating from one DB to another and identify SQL compatibility issues.

At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...