MSSQL

  If you are not using any backup software, you may not be able to back up large databases to a single disk. In such …

  You can backup all databases on an Instance with the help of the following script (except tempdb) You should write the path you want …

  This is probably one of the trickiest question that as DBA I get, and trust me, it happens very often and the funny thing …

  No one should be authorized at server level on instance except DBAs. In some cases, as an exception, you may be granted some users …

  With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. …

Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read …