MSSQL

  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 have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …

  First you should restore your certificate to this instance. You can restore your certificate with the help of following script. You must write the …

  You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …

  When you see an error, such as in the following screenshot, you may consider why your database is trying to access a hidden system …

  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 …