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? Since I'm not ...

TL;DR I can't uncheck NET Framework 4.8 from Server 2022: I'm troubleshooting a problem with an ERP system that we're trying to deploy. The server software runs atop SQL Server and uses AD, so I've ...

Removing Microsoft SQL Writer from one of your business's computers can be helpful if it's causing errors or you want to get rid of unnecessary programs to free up memory. Microsoft SQL Writer comes ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

IT admins can use the Server Manager on a GUI-based Windows Server to easily remove roles and features. In this post, we will walk you through the process of how to remove Roles and Features in ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.