{"publication":{"__typename":"Publication","id":"61df2a3544f1964f4fa7fba7","url":"https://blog.rajanand.org","canonicalURL":"https://blog.rajanand.org","urlPattern":"SIMPLE","title":"Rajanand's Blog","displayTitle":"blog.rajanand.org","hasBadges":true,"descriptionSEO":"I am a Business intelligence lead with over a decade of experience in building DW/BI solutions. I am a Microsoft Certified Solutions Expert in Data management & analytics and trainer.","about":{"html":"

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

\n","text":"I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.\n","__typename":"Content"},"features":{"newsletter":{"isEnabled":true,"__typename":"NewsletterFeature"},"viewCount":{"isEnabled":true,"__typename":"ViewCountFeature"},"readTime":{"isEnabled":true,"__typename":"ReadTimeFeature"},"textSelectionSharer":{"isEnabled":false,"__typename":"TextSelectionSharerFeature"},"customCSS":{"isEnabled":true,"published":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"draft":{"__typename":"CustomCSS","homeMinified":null,"postMinified":"@import url(\"https://fonts.googleapis.com/css?family=Space+Grotesk&display=swap\") .blog-content-area{font-family:'Space Grotesk',serif}","staticMinified":null},"__typename":"CustomCSSFeature"},"__typename":"PublicationFeatures"},"metaTags":"\n\n\n\n $\"Clicky\"$ \n\n\n\n\n\n\n","ogMetaData":{"image":null,"__typename":"OpenGraphMetaData"},"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png"},"preferences":{"__typename":"Preferences","logo":null,"darkMode":{"__typename":"DarkModePreferences","logo":null,"enabled":false},"navbarItems":[{"__typename":"PublicationNavbarItem","id":"63dbb6cc787b1b79bedc1e02","label":"web","url":"https://link.rajanand.org/home","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"61dfbe748a0e7c6db7fba500","label":"contact","url":"https://link.rajanand.org/bio","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"62e9ffbd92b7fd0a78c34f7e","label":"archive","url":"https://blog.rajanand.org/archive","type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"625465d2b32ddd968bbe9cb4","label":"download","url":"https://link.rajanand.org/download","type":"link","series":null,"page":null}],"enabledPages":{"__typename":"PagesPreferences","badges":false,"newsletter":true,"members":null},"layout":"stacked","disableFooterBranding":false,"isSubscriptionModalDisabled":false},"favicon":null,"headerColor":"#48639C","integrations":{"fbPixelID":"1253148365193934","fathomSiteID":"","fathomCustomDomainEnabled":false,"fathomCustomDomain":"","hotjarSiteID":"2780996","matomoSiteID":null,"matomoURL":"","gaTrackingID":"G-41YJ2WRT3K","gTagManagerID":null,"plausibleAnalyticsEnabled":null,"wmPaymentPointer":"","__typename":"PublicationIntegrations"},"imprintV2":{"__typename":"Content","html":"

Download Scenario based SQL data challenges

\n"},"postsCount":{"totalDocuments":76,"__typename":"PublicationPostConnection"},"isTeam":false,"links":{"twitter":"https://twitter.com/iRajanand","instagram":null,"github":"https://github.com/Rajanand","website":"https://www.rajanand.org","hashnode":null,"youtube":"https://www.youtube.com/@iRajanand","dailydev":null,"linkedin":"https://linkedin.com/in/irajanand","mastodon":null,"facebook":null,"__typename":"PublicationLinks"},"domainInfo":{"__typename":"DomainInfo","hashnodeSubdomain":"rajanand","domain":{"__typename":"DomainStatus","host":"blog.rajanand.org","ready":true},"wwwPrefixedDomain":null},"redirectionRules":[{"source":"/youtube","destination":"https://youtube.com/@iRajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/certifications","destination":"https://www.rajanand.org/certifications/","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/linkedin","destination":"http://linkedin.com/in/irajanand","type":"PERMANENT","__typename":"RedirectionRule"},{"source":"/contact","destination":"https://rajanand.org/contact","type":"PERMANENT","__typename":"RedirectionRule"}],"totalRecommendedPublications":0,"sponsorship":{"content":{"html":"

I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support.

\n","markdown":"I am a Microsoft certified SQL Server and Power BI developer. I write about SQL Server, Power BI, Azure data factory and Azure synapse analytics. If you like the article and if it has helped you in any way, you may consider sponsoring this blog. Thanks for your support. \n\n","__typename":"Content"},"stripe":{"connected":true,"accountId":"acct_1Kjem7SCbsfxEzP7","country":"IN","__typename":"StripeConfiguration"},"__typename":"PublicationSponsorship"},"pro":null,"allowContributorEdits":true,"series":{"id":"63ca888c0a811f9ef11c6d97","name":"Notes","coverImage":"","slug":"notes","description":{"html":"This series contains a list of notes taken by me while learning various topics on the web.\n","markdown":"This series contains a list of notes taken by me while learning various topics on the web.","text":"This series contains a list of notes taken by me while learning various topics on the web.\n","__typename":"Content"},"cuid":"cld4hxtkr008ifunvaete8c1j","author":{"id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","__typename":"User"},"posts":{"edges":[{"node":{"__typename":"Post","id":"63ca87ae090951162faeef9f","title":"SQL Server Performance tuning and troubleshooting checklist","slug":"sql-server-performance-tuning-and-troubleshooting-checklist","publishedAt":"2022-12-20T12:22:50.000Z","cuid":"cld4ht2ec000209l40a9j0djl","url":"https://blog.rajanand.org/sql-server-performance-tuning-and-troubleshooting-checklist","subtitle":"Notes","brief":"I have recently come across a wonderful Video on SQL Server performance tuning and troubleshooting checklist by Kevin Kline. and created the notes below for my reference.\nTroubleshooting Checklist\n\nShortcut! Has anything changed? Try to identify what...","readTimeInMinutes":5,"views":2943,"author":{"__typename":"User","id":"576c0b8e956de5c9316890d0","username":"Rajanand","name":"Rajanand Ilangovan","profilePicture":"https://cdn.hashnode.com/res/hashnode/image/upload/v1642238850976/wNjS4RJ-P.png","followersCount":30},"coverImage":null},"cursor":"NjNjYTg3YWUwOTA5NTExNjJmYWVlZjlmXzIwMjItMTItMjBUMTI6MjI6NTAuMDAwWg==","__typename":"PostEdge"}],"pageInfo":{"endCursor":"NjNjYTg3YWUwOTA5NTExNjJmYWVlZjlmXzIwMjItMTItMjBUMTI6MjI6NTAuMDAwWg==","hasNextPage":false,"__typename":"PageInfo"},"__typename":"SeriesPostConnection"},"__typename":"Series"}}}