{"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","priority":3,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"61dfbe748a0e7c6db7fba500","label":"contact","url":"https://link.rajanand.org/bio","priority":1,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"62e9ffbd92b7fd0a78c34f7e","label":"archive","url":"https://blog.rajanand.org/archive","priority":1,"type":"link","series":null,"page":null},{"__typename":"PublicationNavbarItem","id":"625465d2b32ddd968bbe9cb4","label":"download","url":"https://link.rajanand.org/download","priority":0,"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","plausibleAnalyticsEnabled":null,"wmPaymentPointer":"","umamiWebsiteUUID":null,"__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":"","github":"https://github.com/Rajanand","website":"https://www.rajanand.org","hashnode":"","youtube":"https://www.youtube.com/@iRajanand","dailydev":"","linkedin":"","mastodon":"","__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":"63454b5ac8181c1394912ae0","name":"SQL Server Integration Services","coverImage":"","slug":"ssis","description":null,"cuid":"cl9435qfh00bmibnvcame68ud","author":{"id":"576c0b8e956de5c9316890d0","name":"Rajanand Ilangovan","username":"Rajanand","__typename":"User"},"posts":{"edges":[],"pageInfo":{"endCursor":null,"hasNextPage":null,"__typename":"PageInfo"},"__typename":"SeriesPostConnection"},"__typename":"Series"}}}