Posts

Adding Home Older Newer Post Buttons in new Blogger templates such as Contempo

Image
Requirement: Add Home, Older, Newer Post Buttons in new Blogger templates such as Contempo.

Solution:
Hi for this jump to Blog widget in HTML editor of your template and find and replace code in includables with respective id's with the ones given below also change the order of buttons as shown below in postPagination includable as per your needs.

Code given below shows button in this order  Older Posts Home Newer Posts
Demo: Can be seen by clicking here and scrolling to end of page.
Screenshot:


Note: First page will display only Older posts button as there is nothing to go back when we are on landing or home page and the last page will display Previous posts button and the Home button as there is nothing left to go forward.
Displays buttons in order provided here in frontend ,ID to search postPagination: <b:includable id='postPagination'> <div class='blog-pager container' id='blog-pager'> <b:include cond='data:newerPageUrl' name=&#…

Converting blogger HTML tables into Smart Responsive tables using CSS

Image
Requirement: Make all HTML Tables in Blogspot responsive ,pretty & a bit smarter.
How: Its 2 step process.
Add CSS for styling to templateModify your Table Structure accordingly. Here is the link  of the post having table with formatting provided below to see things in action, try changing size of browser to see how it adapts to various screen sizes.

Here are some screenshots as well:

On Desktop:
 On Mobile/Tablets/Phones:

Steps:1:Add the following CSS code in template from HTML editor:
<style> table { border: 1px solid #ccc; border-collapse: collapse; margin: 0; padding: 0; width: 100%; table-layout: fixed; } table caption { font-size: 1.5em; margin: .5em 0 .75em; } table tr { background-color: white; border: 1px solid #ddd; padding: .35em; } table th, table td { padding: .625em; text-align: center; } table th { font-size: .85em; letter-spacing: .1em; text-transform: uppercase; background-color: white; } table td {border-left: 1px solid #d…

Essential Trace Flags to enable at SQL Server Services startup

Image
List of trace flags to enable on SQL server service startup:


Server NameTrace FlagStatusGlobalSessionPRD-MSSQL01C1222110PRD-MSSQL01C1224110PRD-MSSQL01C4136110
Reason: 

4136 will help in preventing parameter sniffing on sql server and in turn will result in query optimizer to create optimized plans for same queries having different parameters which will result in better performance. Note: Please ensure that you thoroughly test this option, before rolling it into a production environment.
Scope: Global or session1224 disables lock escalation based on the number of locks. However, memory pressure can still activate lock escalation. This helps avoid "out-of-locks" errors when many locks are being used.
Scope: Global or session1222 helps in detecting deadlocks returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema.
Note: Avoid using trace flag 1222 on workload-inten…

Part 3: List of Questions I have been asked in Interviews

Image
How many synchronous and asynchronous nodes are possible in always on?What is RRE lookup?How do you resolve RRE lookup ?What are different types of joins available in SQL server and visible in SQL server execution plans?How many agents are there in replication? What are there names?What is the work of distribution agent ?Replication issues ? Primary key violation issues ? Row mismatched conflicts issues in replication?How do you find out the replication issues errors?How do you solve query timeout errors?Have you worked on mirroring?Have you worked on logshipping?What is a listener?(always on )Ola Hallengren's parameters ?Sample size in Ola Hallengren's scripts?What is the frequency that you are using for updating statistics?Have you worked on SSIS ?Like we have principal and mirror in mirroring ,publisher and subscriber in replication what do we have in terminology in always on ?What is better index seek or index scans?How do you validate that databases are healthy?Have you s…