Useful tips for everyday
Is mssql for Linux free? The licensing model for SQL Server does not change with the Linux edition. You have the option of server and…
How many databases can you create in MySQL? MySQL has no limit on the number of databases. The underlying file system may have a limit…
How to use SP _ send _ dbmail to send email? Using a SQL Agent, you can easily invoke the sp_send_dbmail stored proc from the…
Is there way to control page breaks in SSRs? SSRS does NOT handle page breaks in sub reports well! You may be able to control…
What is the purpose of using stored procedure in SQL? Stored procedues in SQL allows us to create SQL queries to be stored and executed…
How do I configure SQL Server to listen on port 1433? How To Set Static TCP Port (1433) in Microsoft SQL Server/Express Step 3) Double…
How do I restore a SQL Server TDE database? Restoring Transparent Data encryption (TDE) enabled database backup to a different server Backup the certificate on…
What is the shortcut to merge multiple tables with data in a pivot table? Let’s get started and combine the data. Open the PivotTable and…
How to replay a trace in SQL profiler? You should now have a completed trace file in the location you specified when setting up the…
How to know how much memory MySQL is using? There are global buffers, per-connection buffers (which depend on the workload), and some uncontrolled memory allocations…