Useful tips for everyday
How do I restore AWS snapshot? Restoring an EBS volume from an Amazon EBS snapshot On the Amazon EC2 console, on the Elastic Block Store…
How do I upgrade my SSIS from 2012 to 2017? Basically, you have two: Use “Upgrade All Packages” option when you right-click the “SSIS Packages”…
How do I change the location of a log file? View or change the default locations for database files In Object Explorer, right-click on your…
Is SQL 2012 still supported by Microsoft? SQL Server 2012 End of Life The mainstream support for SQL Server 2012 ended on 9 January 2018.…
What is dynamic sampling Oracle? Dynamic sampling (DS) was introduced to improve the optimizer’s ability to generate good execution plans. This feature was enhanced and…
What is the storage capacity of MongoDB? The MongoDB’s storage limit on different operating systems are tabulated below as per the MongoDB 3.0 MMAPv1 storage…
How do I link my books to Amazon series? Bookshelf Linking Go to your Bookshelf. Find the book you want to link. Click Link existing…
How to access Enterprise Manager database Express 12C? After the SSH tunnel is created, you can access EM Express by directing your browser to the…
When to include a null field in a query? This criterion applies to a Date/Time field, such as BirthDate. Only records where the number of…
How do I get most recent rows in SQL? Just replace ‘tablename’ with the name of your table, and ‘primaryidfield’ with the name of your…