The following are a few useful commands for Database Performance testing: DBCC FREEPROCCACHE – Clears the procedure cache and forces SQL Server to recompile procedure plans the next time a respective procedure is run DBCC DROPCLEANBUFFERS – Clears the SQL Server data cache i.e any data that exists in the buffer cache from previous execution […]
I just learned how to get substring of specific range using LOCATE() and SUBSTRING(). Let’s say we have email addresses and want to get username part from them. Step 1 Locate the index of ‘@’ character LOCATE(‘@’, email) Step 2 Get substring using it. SUBSTRING(email, 1, LOCATE(‘@’, email) – 1) Note that the starting index is 1 and […]
One of the most useful tools to the DBA when we need to test new features, recreate a fault that we’ve seen in production or just want to see ‘what if…?’ is a test lab. Some of you are going to be lucky enough to have a few servers kicking around or a chunk of […]
Like any other enterprise database, mysql supports secure jdbc connections using ssl/tls. I had a requirement to connect to Mysql using secure JDBC, the initial setup took longer than I anticipated due to the requirement of converting .pem files to jks . I had to look up multiple articles, not satisfied with quality of available […]
What strategies are companies employing for brief bequest apps to the cloud?
Another super easy Keyboard Shortcut to Select Current Column in Microsoft Excel and Google Sheet try yourself with both Spreadsheet programs and also try in whatever Spreadsheet Program you are using, share and write your experience in comments box. Press CTRL + SPACEBAR to Select Current Column in your Microsoft Excel / Google Sheet or any other Spreadsheet Program: share it with your friends on SOCIAL NETWORKS click […]
[Note: This use case/solution can be implemented in both Classic and Lightning Experience.] While process builder has the ability to post to chatter, its capabilities are a bit simplistic. In process builder, you can post to a user, a chatter group or the record. There is no ability to @mention multiple users dynamically. Users can […]