Useful tips for everyday
Can you have multiple databases? Good reasons to create separate databases would be to support different availability requirements or simplify administration. For example if your…
What is SRID in MySQL? The spatial reference identifier (SRID) of a geometry identifies the SRS in which the geometry is defined. In MySQL, the…
How do I restrict roles in AWS? You cannot switch roles in the AWS Management Console to a role that requires an ExternalId value. You…
How do I configure SSRS reports? Install your report server Find the location of SQLServerReportingServices.exe and launch the installer. Select Install Reporting Services. Choose an…
How do I set permissions in SQL query? Using SQL Server Management Studio Right-click a stored procedure and select Properties. In the Stored Procedure Properties…
How do I export a report from SSRS? To export a report from Report Builder Run or Preview the report. On the ribbon, click Export.…
Does SQL Server use page file? SQL Server doest not need a giant page file. if you’re installing other applications on the server (which we…
How does SQL availability group work? A read-scale availability group is a group of databases that are copied to other instances of SQL Server for…
What is backup media set? A media set is an ordered collection of backup media, tapes or disk files, or Azure Blobs, to which one…
How do I use a check in MariaDB? Introduction to MariaDB check constraint It consists of the check keyword followed by a Boolean expression in…