Useful tips for everyday
Can we use SQL Express for commercial use? Reality: While SQL Server is a completely free product, it is also completely capable of legally being…
How do I remove the year from a date in R? To get the year from a date in R you can use the functions…
Can I create index on view mysql? It is not possible to create an index on a view. Indexes can be used for views processed…
How do I change page layout in SSRS? In Main Menu,Click on Report in VS2008, Then click on Report Properties and. in the Page Setup…
What does the SCN represent in Oracle? A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events…
Should I script in bash or Python? Python is the most elegant scripting language, even more than Ruby and Perl. On the other hand, Bash…
Where can I find census data for my area? QuickFacts provides statistics for all states and counties, and for cities and towns with a population…
How to change the default socket used by MySQL? It tries by default to connect to /tmp/mysql.sock, however, this is not the socket that my…
How to run a stress test on MySQL? By using mysqlslap to stress test a server in a non-public environment, you will discover these errors…
How do I transfer data from SQL to Oracle? Select Tools > Migration > Migrate. The migration wizard appears and it will walk you through…