Useful tips for everyday
Are MySQL queries encrypted? By default MySQL does not encrypt its client/server communication: https://dev.mysql.com/doc/refman/5.6/en/security-guidelines.html. You can setup MySQL to accept connections over SSL and require…
How do I export a single table in SQL Server? Exporting Tables Using SQL Server Management Studio Right-click on the database that contains tables you…
Is PostgreSQL good for data warehousing? Though it was designed for production systems, with a little tweaking Postgres can work extremely well as a data…
What is the limitation of data compression? Can’t Search Compressed Files: once files are stored in compressed formats, they must be completely de-compressed before searching…
How do you swap two tables in SQL? Create a temporary table with the values as same as the table T1 values. Then update the…
How do I completely remove SQL Server from Windows 7? To begin the removal process, navigate to the Control Panel and then select Programs and…
What are event handlers in SSIS package? SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is…
How do I enable Create Catalog option in Integration Services catalogs? To create this catalog database, right-click on the “Integration Services Catalog” option and select…
Can you TRUNCATE in a transaction? In Informix, the behaviour of TRUNCATE is slightly different; you can use TRUNCATE in a transaction, but the only…
How do I export Datagrip database? Export to a file Right-click a result set, a table, or a view, select Export Data. Right-click a query…