SQL Server General DBA
Question There’s a debate going on within our company about whether or not we should automatically reboot our SQL Servers on a weekly basis. We are not experiencing any current problems, but some people are saying that by regularly rebooting, we will prevent future issues. Will doing so help performance or reliability of SQL Server? […]
How do you get rid of users that are already in the database on the backup server when a restore starts?
QuestionI’m trying to implement log shipping as described in your log shipping article, with a few slight modifications. The question I have is how do you get rid of users that are already in the database on the backup server when a restore starts? If someone is using the read-only capabilities when the restore starts, […]
Importing data from Excel is a simple task if you are using SSIS. You can accomplish this by simply drag and dropping few controls and you are done. But what if your excel workbook has dynamic sheets, which means you will not know the sheet name. Excel Sheet Let us assume we need to import […]