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

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 using Studio and do a manual shrink on the database.

The most recent update to the Windocks platform was the addition of support for SQL Server Reporting Services (SSRS), Microsoft’s report generating system that is used by many organisations to ...