noreply@blogger.com (Sandesh Segu)Mon, 6 Apr 2026 15:39:54 +0530Blogger http://www.blogger.com384125http://www.sanssql.com/en-usnonoreply@blogger.comhttp://www.sanssql.com/2023/10/understanding-differences-database-vs.htmlcomparisionData LakeData LakehouseData WarehouseDatabaseDifferencesscenariostoolsnoreply@blogger.com (Sandesh Segu)Fri, 20 Oct 2023 14:07:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1276962318660771482In today's data-driven world, businesses rely on various technologies to manage, analyse, and leverage their data effectively. Three key components in this data ecosystem are databases, data warehouses, and data lakes. Each serves a unique purpose and offers specific advantages. In this blog post, we'll explore the differences between these three data storage and management solutions, provide 12http://www.sanssql.com/2023/05/design-principles-for-building-powerful.htmlapiapplicationdevelopmentAWSAzureCloudcloudcomputingcontainerizationDesigndockergcpmicorsoftmicroservicesmonitoringPrinciplesScalabilitynoreply@blogger.com (Sandesh Segu)Fri, 19 May 2023 15:59:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-2091667153266457783In recent years, cloud-native applications have become increasingly popular due to their scalability, resiliency, and agility. Cloud-native applications are designed to run on cloud platforms and leverage the capabilities of the cloud to achieve their goals. To develop effective cloud-native applications, it is essential to follow a set of design principles that ensure the application is scalable13http://www.sanssql.com/2023/03/6-cloud-design-principles-for.htmlCloudCost Optimization AutomationDesignPerformancePrinciplesResiliencyScalabilitySecuritynoreply@blogger.com (Sandesh Segu)Sat, 18 Mar 2023 15:57:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-8119682500322081606As more businesses adopt cloud technology, it’s essential to follow best practices for cloud design to ensure the efficient and effective use of cloud resources. Cloud design principles can help you create a cloud environment that meets your business needs while ensuring reliability, scalability, and security. In this article, we will discuss some of the key cloud design 11http://www.sanssql.com/2023/03/an-introduction-to-azure-landing-zone.htmlArchitectureAzurecloudbasedcloudcomputingcloudengineercloudjourneycloudmigrationlandingzonenoreply@blogger.com (Sandesh Segu)Mon, 13 Mar 2023 15:31:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-3556193654930255558Azure Landing Zone is a best practice methodology for creating a well-architected Azure environment that can scale, provide security and compliance, and optimize cost. It provides a foundation for deploying Azure resources with consistency, repeatability, and automation. In this blog post, we will explore the concept of Azure Landing Zone and how it can help organizations deploy their workloads 6http://www.sanssql.com/2023/03/7rs-of-cloud-migration-strategies.html7RsCloudcloudcomputingcloudjourneydiscovermigrationreadinessstartupstrategiesstrategynoreply@blogger.com (Sandesh Segu)Mon, 6 Mar 2023 23:16:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-2122171776249612229Cloud migration is the process of moving data, applications, and other resources from an on-premises infrastructure to a cloud-based environment. It has become increasingly popular in recent years, as organizations seek to take advantage of the scalability, flexibility, and cost savings offered by cloud computing. However, cloud migration can be a complex and challenging process, and 9http://www.sanssql.com/2022/09/replace-nulls-with-zeros-in-power-bi.htmldashboarddefaultmysqlpowerbipowerbi_trainingpowerbidesktoppowerbideveloperpowerbiservicereplacereplacementreportsanssqlsharingtechbytesvisualizationvisualsnoreply@blogger.com (Sandesh Segu)Wed, 14 Sep 2022 23:39:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1633478082979658701This video demonstrates on how we can relace a specific value with another value. One such case explained in this video is on how we can replace nulls with zeros. 4http://www.sanssql.com/2022/08/connect-to-mysql-db-this-connector.htmlconnectorsdashboardDatabasemysqlmysqlserverpowerbipowerbi_trainingpowerbidesktoppowerbideveloperpowerbiservicereportsanssqlsharingtechbytesviewingviewsvisualizationvisualsnoreply@blogger.com (Sandesh Segu)Sun, 28 Aug 2022 18:15:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-4082906931892307667This video describes how to connect to MySQL Database and fix an common issues with the Power BI MySQL connector  which says "This connector requires one or more additional components to be installed". Download link to MySQL NET Connectorhttps://dev.mysql.com/downloads/connector/net/1http://www.sanssql.com/2022/08/hide-or-unhide-visuals-in-power-bi.htmlbankapplicationdashboardhidepowerbipowerbi_trainingpowerbidesktoppowerbideveloperpowerbiservicereportsanssqlsharingtechbytesunhideviewingviewsvisualizationvisualsnoreply@blogger.com (Sandesh Segu)Fri, 12 Aug 2022 00:00:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-5273721218218114243In this video we create a Power BI report and use bookmarks to Hide or unhide card visuals.4http://www.sanssql.com/2022/08/combine-multiple-files-and-load-to.htmlcombinecsvdashboardExcelfilefilesmultiplepowerbipowerbi_trainingpowerbidesktoppowerbideveloperpowerbiservicereportsanssqltechbytestransformationvisualizationvisualsnoreply@blogger.com (Sandesh Segu)Tue, 9 Aug 2022 02:04:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-902269364731199196In this video we discuss on how we can combine multiple files and load into Power BI. For the demo, we have the following 3 scenariosData Sets with same number of ColumnsData Sets with different number of ColumnsData Sets with different file types2http://www.sanssql.com/2022/08/power-bi-content-sharing-who-can-see.htmlAnalyticsanalyticsinsightBI&Analyticspowerbipowerbi_trainingsanssqltechbytesvisualizationnoreply@blogger.com (Sandesh Segu)Fri, 5 Aug 2022 00:39:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-3876400051401597919This video explains on who can see what content when Power BI content is created or shared across the license types.6http://www.sanssql.com/2022/08/using-custom-fonts-in-power-bi.htmlAnalyticsanalyticsinsightBI&Analyticspowerbipowerbi_trainingsanssqltechbytesvisualizationnoreply@blogger.com (Sandesh Segu)Fri, 5 Aug 2022 00:36:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-3576993453476261974 Custom Fonts are one of the major factors of Branding and for enterprises branding means a lot. This video demonstrates how to use custom fonts in Power BI which are currently not available by default. 10http://www.sanssql.com/2022/07/unzip-and-extract-file-contents-to.htmlAnalyticsanalyticsinsightBI&Analyticspowerbipowerbi_trainingsanssqltechbytesvisualizationnoreply@blogger.com (Sandesh Segu)Sat, 16 Jul 2022 01:04:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-6298803094019705459 This video describes how to unzip and extract file contents to Power BI. Reading zip files without extracting them. Link to Mark's Blog: https://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html2http://www.sanssql.com/2022/07/display-alternate-text-when-image-url.htmlAnalyticsanalyticsinsightBI&Analyticsimageimagespowerbipowerbi_trainingsanssqltechbytesvisualizationnoreply@blogger.com (Sandesh Segu)Fri, 15 Jul 2022 13:05:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1101430680417821544 This video describes how to display alternate text when there is no data present for the image URL in Power BI.3http://www.sanssql.com/2022/07/display-default-image-when-there-is-no.htmlPower BIpower bi desktoppowerbitechbytesnoreply@blogger.com (Sandesh Segu)Thu, 14 Jul 2022 13:47:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1628088123723187800 This video describes how to display a default image when there is no data present for the image URL in Power BI.7http://www.sanssql.com/2022/07/display-urls-as-images-in-power-bi.htmlPower BIpower bi desktoppowerbitechbytesnoreply@blogger.com (Sandesh Segu)Tue, 12 Jul 2022 12:12:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-7326622228900052323 This video describes how to display URL's as images in Power BI.3http://www.sanssql.com/2022/07/connect-to-azure-data-lake-from-power-bi.htmlAzureazure data lake gen 2datalakePower BIpower bi desktoppowerbitechbytesnoreply@blogger.com (Sandesh Segu)Fri, 8 Jul 2022 14:39:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-8235066891666176504This video describes how to connect to Azure Data Lake from Power BI.Download link to Azure Open Datasets: https://docs.microsoft.com/en-us/azure/open-datasets/dataset-catalog1http://www.sanssql.com/2022/05/t-sql-to-find-server-and-sql-restart.htmlMSSQLrestartSQL ServerSQL Server 2008SQL Server 2008 R2SQL Server 2012SQL SERVER 2014SQL Server 2016sql server 2019SQL server Servicesql servicenoreply@blogger.com (Sandesh Segu)Wed, 25 May 2022 12:39:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-170820510400610529This script comes handy when you would like to find out the Server and SQL services restart times. DECLARE @SQLServiceRestartDateTime AS VARCHAR(50), @ServerRestartDateTime AS VARCHAR(50) SELECT @SQLServiceRestartDateTime = create_date FROM sys.databases WHERE database_id=2 SELECT @ServerRestartDateTime = CAST(DATEADD(SECOND, (ms_ticks/1000) * -1, GETDATE()) AS datetime) FROM 7http://www.sanssql.com/2022/05/t-sql-to-find-backup-or-restore-progress.htmlBackupBackup and RestoreMSSQLRestoreSQL ServerSQL Server 2005SQL Server 2008SQL Server 2008 R2SQL Server 2011SQL Server 2012SQL SERVER 2014SQL Server 2016sql server 2019SQL Server Agentnoreply@blogger.com (Sandesh Segu)Fri, 20 May 2022 19:27:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1609613187963198346Here is a script that comes handy while performing a huge database Backup or Restore. This script provides the details on the progress of the Backup or Restore operation including the estimated finish time. SELECT session_id AS SPID, command AS [Command], a.text AS Query, start_time AS [Start Time], percent_complete AS [Percent Complete], dateadd(second,estimated_completion_time/1000,7http://www.sanssql.com/2022/05/t-sql-to-find-navigation-path-in-cms.htmlCentral Management ServerCMSMSSQLSQL ServerSQL Server 2012SQL Server 2016sql server 2019T-SQLnoreply@blogger.com (Sandesh Segu)Mon, 16 May 2022 13:30:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1826008596278405996In large enterprises there will be huge number of SQL servers which will be registered within a Central Management Server (CMS) and times it may become difficult to find out where the server is registered atleast for new team members in the Huge pile of servers and folder structure. This query give you the path where the specified servers is registered within the CMS. DECLARE @ServerName 3http://www.sanssql.com/2022/04/t-sql-to-find-remote-server-name-of.htmllinked serversServer NameSQL ServerSQL Server 2016sql server 2019noreply@blogger.com (Sandesh Segu)Fri, 22 Apr 2022 13:40:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-2435510104650588574At times it happens that you might have named a linked server with a friendly name that the actual server name. As the time flies and people change in the team, it will become difficult to identify how or to where this is linked.  You can find the information using the sp_linkedservers stored procedure but what if the linked server configured uses a entirely different DNS name than the 1http://www.sanssql.com/2020/02/disable-auto-forwarding-of-e-mails-to.htmlAuto-ForwardCloudemailOffice 365Transport Rulenoreply@blogger.com (Sandesh Segu)Thu, 20 Feb 2020 02:31:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-8823656218067052069 e-Mails are one of the most critical components and infrastructure of any business in the current day and age. e-Mails can bring in business as well as loss if misused. A lot of data theft can happens via e-Mails and it becomes most important to safegaurd the e-Mail infrastructure. If a hacker gains access to a user's mailbox, they can auto-forward the user's email to an outside address and 140http://www.sanssql.com/2019/11/importance-of-identity-verification-for.htmlnoreply@blogger.com (Sandesh Segu)Fri, 8 Nov 2019 20:53:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-5785580994947832450 In the world today, almost every grown-up owns a mobile phone, and more than half of them are smartphones with a lot of sensitive data. For the multitude of persons with a mobile device, data security is one of the most critical issues with using one. Whether you own an Android or IOS device, Identity verification should be part of the features you should look out for in a phone. 42http://www.sanssql.com/2019/04/best-security-practice-in-era-of-5g-and.html5GCloudCyber SecurityGuest PostIOTSecuritynoreply@blogger.com (Sandesh Segu)Tue, 9 Apr 2019 21:39:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-1887921763700641458 Greater potential brings greater security responsibilities The real world application of 5G is bound to trigger security issues that might not be evident in labs and test beds. As 5G promises customers, businesses, and service providers unparalleled potentials, so too does it hold unparalleled security lapses that will give way to cyber-attacks. 5G will envelop a vast array of technology 55http://www.sanssql.com/2018/08/tips-to-move-sql-server-database-from.htmlDatabaseGuest PostMSSQLSQL ServerSQL Server Migrationnoreply@blogger.com (Sandesh Segu)Fri, 17 Aug 2018 16:13:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-9057438672945879576 Leading organizations always look to find different solutions for high-performance data replication and secure storage environment. One such step is to move SQL Server database from one server to its updated version. In fact, when you migrate SQL server database, it provides an opportunity to scale the organizations data ecosystem efficiently at an optimum cost. Why should you migrate SQL 34http://www.sanssql.com/2018/08/big-data-use-cases-in-manufacturing.htmlbig dataGuest PostUse Casenoreply@blogger.com (Sandesh Segu)Tue, 14 Aug 2018 12:53:00 +0530tag:blogger.com,1999:blog-370183193676959553.post-4803973926121264463 Big data is processing of data collected from various sources in different formats. Big data may contain sensitive information which is important for the organisation to make decisions. According to a research, the market value of the Big data will achieve around $1.1 billion by the next year. Today, many industries are using Big data, and companies which are not using are going through big data359