corpus.blog
56,966 blogs · [ { "id": "01a087e4-bdcc-711e-9b6e-901c28901215", "title": "SQL Server 2025 Private Preview – Built-in AI, Fabric connectivity, Native JSON, and many more…", "url": "https://sqlwithmanoj.com/2024/11/22/sql-server-2025-private-preview-built-in-ai-fabric-connectivity-native-json-and-many-more/", "published_at": "2024-11-22T06:22:55+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c28c63b03", "title": "Azure SQL Database in Fabric Public Preview", "url": "https://sqlwithmanoj.com/2024/11/20/azure-sql-database-in-fabric-public-preview/", "published_at": "2024-11-20T10:18:57+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c28df09f0", "title": "“Generative AI”, my take after finishing a course", "url": "https://sqlwithmanoj.com/2024/01/11/generative-ai-my-take-after-finishing-a-course/", "published_at": "2024-01-11T05:47:16+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c29940af3", "title": "SQL Planner, a monitoring tool for SQL Server for DBAs & Developers", "url": "https://sqlwithmanoj.com/2022/04/22/sql-planner-a-monitoring-tool-for-sql-server-for-dbas-developers/", "published_at": "2022-04-22T06:14:11+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c29ef7d2f", "title": "2021 blogging in review (Thank you & Happy New Year 2022 !!!)", "url": "https://sqlwithmanoj.com/2022/01/01/2021-blogging-in-review-thank-you-happy-new-year-2022/", "published_at": "2022-01-01T04:57:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2a3f757c", "title": "SQL Server 2022 preview announced, some awesome new features !!!", "url": "https://sqlwithmanoj.com/2021/11/08/sql-server-2022-preview-announced-some-awesome-new-features/", "published_at": "2021-11-08T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2aeef9fd", "title": "SQL DBA – Integration Services evaluation period has expired", "url": "https://sqlwithmanoj.com/2021/07/02/sql-dba-integration-services-evaluation-period-has-expired/", "published_at": "2021-07-02T04:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2b487fe1", "title": "Spark – Cannot perform Merge as multiple source rows matched…", "url": "https://sqlwithmanoj.com/2021/06/18/spark-cannot-perform-merge-as-multiple-source-rows-matched/", "published_at": "2021-06-17T19:28:42+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2bb283a7", "title": "Python – Delete/remove unwanted rows from a DataFrame", "url": "https://sqlwithmanoj.com/2021/04/15/python-delete-remove-unwanted-rows-from-a-dataframe/", "published_at": "2021-04-15T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2c27b082", "title": "Python error – Length of passed values is 6, index implies 2 (while doing PIVOT with MultiIndex or multiple columns)", "url": "https://sqlwithmanoj.com/2021/04/14/python-error-length-of-passed-values-is-6-index-implies-2-while-doing-pivot-with-multiindex-or-multiple-columns/", "published_at": "2021-04-14T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2cd86313", "title": "Cosmos DB & PySpark – Retrieve all attributes from all Collections under all Databases", "url": "https://sqlwithmanoj.com/2021/04/12/cosmos-db-pyspark-retrieve-all-attributes-from-all-collections-under-all-databases/", "published_at": "2021-04-12T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2d4391fa", "title": "Using Python in Azure Databricks with Cosmos DB – DDL & DML operations by using “Azure-Cosmos” library for Python", "url": "https://sqlwithmanoj.com/2021/04/09/using-python-in-azure-databricks-with-cosmos-db-to-retrieve-all-attributes-from-all-collections-under-all-databases/", "published_at": "2021-04-09T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2e3adc8d", "title": "Python error: while converting Pandas Dataframe or Python List to Spark Dataframe (Can not merge type)", "url": "https://sqlwithmanoj.com/2021/04/08/python-error-while-converting-pandas-dataframe-or-python-list-to-spark-dataframe-can-not-merge-type/", "published_at": "2021-04-08T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2eab8a50", "title": "Connect to Cosmos DB from Databricks and read data by using Apache Spark to Azure Cosmos DB connector", "url": "https://sqlwithmanoj.com/2021/04/07/connect-to-cosmos-db-from-databricks-and-read-data-by-apache-spark-to-azure-cosmos-db-connector/", "published_at": "2021-04-07T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2eea345b", "title": "Cosmos DB – Retrieve all attributes/fields from the JSON document of all Collections (using .net)", "url": "https://sqlwithmanoj.com/2021/04/06/cosmos-db-retrieve-all-attributes-fields-from-the-json-document-of-all-collections-using-net/", "published_at": "2021-04-06T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2efbd66d", "title": "Cosmos DB – Get record COUNT from all Collections in all Databases (using .net)", "url": "https://sqlwithmanoj.com/2021/04/01/cosmos-db-get-record-count-from-all-collections-in-all-databases-using-net/", "published_at": "2021-04-01T01:30:00+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2f5d0ae0", "title": "Access VSO Work Items in Postman, by using Azure DevOps REST APIs, using PAT (Personal Access Token) authentication", "url": "https://sqlwithmanoj.com/2021/03/04/access-vso-work-items-in-postman-by-using-azure-devops-rest-apis-using-pat-personal-access-token-authentication/", "published_at": "2021-03-04T01:30:13+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c2fca0aea", "title": "REST API, PATCH request error, Postman – Valid content types for this method are: application/json-patch+json", "url": "https://sqlwithmanoj.com/2021/03/02/rest-api-patch-request-error-postman-valid-content-types-for-this-method-are-application-json-patchjson/", "published_at": "2021-03-02T01:30:31+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3040bb3a", "title": "Database backup to Azure blob storage with SQL Server 2016+", "url": "https://sqlwithmanoj.com/2021/02/09/database-backup-to-azure-blob-storage-with-sql-server-2016/", "published_at": "2021-02-09T01:30:07+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c311950de", "title": "2020 blogging in review (Thank you & Happy New Year 2021 !!!)", "url": "https://sqlwithmanoj.com/2020/12/31/2020-blogging-in-review-thank-you-happy-new-year-2021/", "published_at": "2020-12-31T09:07:23+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c312734b0", "title": "Apache Spark – new Features & Improvements in Spark 3.0", "url": "https://sqlwithmanoj.com/2020/10/27/apache-spark-new-features-improvements-in-spark-3-0/", "published_at": "2020-10-27T02:30:14+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c31282d86", "title": "Apache Spark – RDD, DataFrames, Transformations (Narrow & Wide), Actions, Lazy Evaluation (Part 3)", "url": "https://sqlwithmanoj.com/2020/10/23/apache-spark-rdd-dataframes-transformations-narrow-wide-actions-lazy-evaluation-part-3/", "published_at": "2020-10-23T01:30:33+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c31443d8b", "title": "Apache Spark – main Components & Architecture (Part 2)", "url": "https://sqlwithmanoj.com/2020/10/19/apache-spark-main-components-architecture-part-2/", "published_at": "2020-10-19T02:30:16+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c31694a70", "title": "Apache Spark – Introduction & main features (Part 1)", "url": "https://sqlwithmanoj.com/2020/10/12/apache-spark-introduction-main-features-part-1/", "published_at": "2020-10-12T16:52:36+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c32392d9d", "title": "Spark error – Parquet does not support decimal. See HIVE-6384", "url": "https://sqlwithmanoj.com/2020/08/05/spark-error-parquet-does-not-support-decimal-see-hive-6384/", "published_at": "2020-08-05T15:59:29+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3277908b", "title": "Azure Data Factory (ADF) Pipeline failure – found more columns than expected column count (DelimitedTextMoreColumnsThanDefined)", "url": "https://sqlwithmanoj.com/2020/07/29/azure-data-factory-adf-pipeline-failure-found-more-columns-than-expected-column-count-delimitedtextmorecolumnsthandefined/", "published_at": "2020-07-29T15:28:23+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c32c03244", "title": "SQL DBA – Change RECOVERY mode & SHRINK all databases at once in SQL Server", "url": "https://sqlwithmanoj.com/2020/07/17/sql-dba-change-recovery-mode-shrink-all-databases-at-once-in-sql-server/", "published_at": "2020-07-17T10:07:38+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c33683336", "title": "Databricks Notebook error: Your administrator has only allowed sql and scala commands on this cluster.", "url": "https://sqlwithmanoj.com/2020/06/08/databricks-notebook-error-your-administrator-has-only-allowed-sql-and-scala-commands-on-this-cluster/", "published_at": "2020-06-07T18:37:32+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c33f57f23", "title": "Spark SQL – Beware of Implicit datatype conversions (TypeCoercion)", "url": "https://sqlwithmanoj.com/2020/03/06/spark-sql-beware-of-implicit-datatype-conversions-typecoercion/", "published_at": "2020-03-05T20:02:42+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c33f68076", "title": "SQL Error – “SELECT TOP 100” throws error in SparkSQL – what’s the correct syntax?", "url": "https://sqlwithmanoj.com/2020/01/23/sql-error-select-top-100-throws-error-in-sparksql-whats-the-correct-syntax/", "published_at": "2020-01-22T18:41:14+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c34ba5e12", "title": "SQL Server 2019 released, awesome new features – download now !!!", "url": "https://sqlwithmanoj.com/2019/11/04/sql-server-2019-released-awesome-new-features-download-now/", "published_at": "2019-11-04T17:54:39+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c352921ca", "title": "Spark/Scala: Convert or flatten a JSON having Nested data with Struct/Array to columns (Question)", "url": "https://sqlwithmanoj.com/2019/01/09/spark-scala-convert-or-flatten-a-json-having-nested-data-with-struct-array-to-columns-question/", "published_at": "2019-01-09T13:19:04+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3623c2b8", "title": "2018 blogging in review (Happy New Year – 2019 !!!)", "url": "https://sqlwithmanoj.com/2018/12/31/2018-blogging-in-review-happy-new-year-2019/", "published_at": "2018-12-31T01:30:25+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3709e947", "title": "Hadoop/HDFS storage types, formats and internals – Text, Parquet, ORC, Avro", "url": "https://sqlwithmanoj.com/2018/12/30/hadoop-hdfs-storage-types-formats-and-internals-text-parquet-orc-avro/", "published_at": "2018-12-30T09:17:21+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3759fc79", "title": "Powershell – Restart Azure VM and log off Users remotely", "url": "https://sqlwithmanoj.com/2018/10/21/powershell-restart-azure-vm-and-log-off-users-remotely/", "published_at": "2018-10-21T01:30:44+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c378f1dd9", "title": "SQL Server 2019 initial “Community Technology Preview” is out – download and check the CTP 2.0 release now !", "url": "https://sqlwithmanoj.com/2018/09/24/sql-server-2019-initial-community-technology-preview-is-out-download-and-check-the-ctp-2-0-release-now/", "published_at": "2018-09-24T17:14:54+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c37e3ee15", "title": "Migrate your SQL Server database to Azure by using SysTools “SQL to Azure Migration” Tool", "url": "https://sqlwithmanoj.com/2018/09/05/migrate-your-sql-server-database-to-azure-by-using-systools-sql-to-azure-migration-tool/", "published_at": "2018-09-05T01:30:15+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c387f45ad", "title": "SQL Server on Linux – Best practices post installation", "url": "https://sqlwithmanoj.com/2018/08/30/sql-server-on-linux-best-practices-post-installation/", "published_at": "2018-08-30T01:30:22+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c397e60d3", "title": "SQL Python Error – ‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.", "url": "https://sqlwithmanoj.com/2018/08/29/sql-python-error-sp_execute_external_script-is-disabled-on-this-instance-of-sql-server-use-sp_configure-external-scripts-enabled-to-enable-it/", "published_at": "2018-08-29T01:30:24+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3a7d3aeb", "title": "Get started with Python on SQL Server – Run Python with T-SQL on SSMS", "url": "https://sqlwithmanoj.com/2018/08/10/get-started-with-python-on-sql-server-run-python-with-t-sql-on-ssms/", "published_at": "2018-08-10T01:30:50+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3ac37418", "title": "Azure Databricks learning resources (documentation and videos)", "url": "https://sqlwithmanoj.com/2018/08/07/azure-databricks-learning-resources-documentation-and-videos/", "published_at": "2018-08-06T20:27:31+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3b0a574c", "title": "Azure Databricks (a fully managed Apache Spark offering)", "url": "https://sqlwithmanoj.com/2018/07/28/azure-databricks-a-fully-managed-apache-spark-offering/", "published_at": "2018-07-28T04:16:43+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3b4e4400", "title": "Azure SQL Data Sync – keep your data in sync between Azure Hybrid environment SQL Server and SQL DB", "url": "https://sqlwithmanoj.com/2018/07/12/azure-sql-data-sync-keep-your-data-in-sync-between-azure-hybrid-environment-sql-server-and-sql-db/", "published_at": "2018-07-12T01:30:25+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3be8eab8", "title": "All about Blockchain – Introduction", "url": "https://sqlwithmanoj.com/2018/06/25/all-about-blockchain-introduction/", "published_at": "2018-06-25T15:10:28+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3c3e9e5c", "title": "SQL Tips – Issues with BCP when you have two SQL Server instances", "url": "https://sqlwithmanoj.com/2018/06/09/sql-tips-issues-with-bcp-when-you-have-two-sql-server-instances/", "published_at": "2018-06-08T19:22:47+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3cffd365", "title": "SQL Job creation failing (having VBScript step) after SQL Server 2016/2017 upgrade", "url": "https://sqlwithmanoj.com/2018/05/21/sql-job-creation-failing-having-vbscript-step-after-sql-server-2016-2017-upgrade/", "published_at": "2018-05-21T01:30:44+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3d245f56", "title": "SQL Server 2017 Setup error – VS Shell installation has failed with exit code 1638", "url": "https://sqlwithmanoj.com/2018/05/14/sql-server-2017-setup-error-vs-shell-installation-has-failed-with-exit-code-1638/", "published_at": "2018-05-14T17:20:07+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3dfe7d9f", "title": "Prepare for Certification Exam 70-775: Perform Data Engineering on Microsoft Azure HDInsight", "url": "https://sqlwithmanoj.com/2018/04/10/prepare-for-certification-exam-70-775-perform-data-engineering-on-microsoft-azure-hdinsight/", "published_at": "2018-04-09T22:38:05+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3ec3d069", "title": "An introduction to Azure HDInsight – Microsoft’s Big-Data/Hadoop solution on Azure", "url": "https://sqlwithmanoj.com/2018/03/03/an-introduction-to-azure-hdinsight-microsofts-big-data-hadoop-solution-on-azure/", "published_at": "2018-03-02T21:01:53+00:00" }, { "id": "01a087e4-bdcc-711e-9b6e-901c3fad5a33", "title": "Download SQL Server 2017 for free (with full MSBI stack)", "url": "https://sqlwithmanoj.com/2018/03/01/download-sql-server-2017-for-free-with-full-msbi-stack/", "published_at": "2018-03-01T12:39:35+00:00" }, { "id": "01a0d1d2-d541-7386-8d41-54ce2391d494", "title": "Meltdown and Spectre vulnerability, all about, and references for patching Windows OS & SQL Server", "url": "https://sqlwithmanoj.com/2018/02/23/meltdown-and-spectre-vulnerability-all-about-and-references-for-windows-os-sql-server/", "published_at": "2018-02-23T01:30:20+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7aa43a1c", "title": "What is Lambda Architecture? and what Azure offers with its new Cosmos DB?", "url": "https://sqlwithmanoj.com/2018/02/16/what-is-lambda-architecture-and-what-azure-offers-with-its-new-cosmos-db/", "published_at": "2018-02-16T01:30:35+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7b4da8b9", "title": "Create a new Azure SQL Database (on PaaS) step by step", "url": "https://sqlwithmanoj.com/2018/02/15/create-a-new-azure-sql-database-paas-step-by-step/", "published_at": "2018-02-15T01:30:17+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7c356eca", "title": "Get started with Microsoft Azure, create your Account and free Subscription", "url": "https://sqlwithmanoj.com/2018/02/08/get-started-with-microsoft-azure-create-your-account-and-free-subscription/", "published_at": "2018-02-08T01:30:04+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7c990a1f", "title": "An Introduction to Cloud Computing …aligned with Microsoft Azure", "url": "https://sqlwithmanoj.com/2018/02/07/an-introduction-to-cloud-computing-aligned-with-microsoft-azure/", "published_at": "2018-02-07T01:30:53+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7cd30bea", "title": "SQL Error – Cannot open backup device ‘https://xyz.blob.core.windows.net/xyz/xyz.bak’. Operating system error 50(The request is not supported.).", "url": "https://sqlwithmanoj.com/2018/02/06/sql-error-cannot-open-backup-device-https-xyz-blob-core-windows-net-xyz-xyz-bak-operating-system-error-50the-request-is-not-supported/", "published_at": "2018-02-06T01:30:34+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7cecb8dc", "title": "SQL Trivia – SQL Server Code names", "url": "https://sqlwithmanoj.com/2018/01/25/sql-trivia-sql-server-code-names/", "published_at": "2018-01-25T01:30:54+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7d3f1b6e", "title": "SQL Error – SQL Server Installation fails | Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed)…", "url": "https://sqlwithmanoj.com/2018/01/09/sql-error-sql-server-installation-fails-attributes-do-not-match-present-attributes-directory-compressed-notcontentindexed/", "published_at": "2018-01-09T01:30:53+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7ddcbfe4", "title": "Seeking response on: LDAP Authentication with SQL Server 2017 on Linux", "url": "https://sqlwithmanoj.com/2018/01/08/seeking-response-on-ldap-authentication-with-sql-server-2017-on-linux/", "published_at": "2018-01-08T18:03:26+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7ec1e4c9", "title": "Download & Install SQL Server Reporting Services (SSRS) 2017 (decoupled from SQL Server engine setup)", "url": "https://sqlwithmanoj.com/2018/01/07/download-install-sql-server-reporting-services-ssrs-2017-decoupled-from-sql-server-engine-setup/", "published_at": "2018-01-07T01:30:19+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb7f85c857", "title": "2017 blogging in review", "url": "https://sqlwithmanoj.com/2017/12/31/2017-blogging-in-review/", "published_at": "2017-12-31T11:30:05+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8075db81", "title": "SQL Server 2017 – ColumnStore Index enhancements and improvements over previous versions", "url": "https://sqlwithmanoj.com/2017/12/21/sql-server-2017-columnstore-index-enhancements-and-improvements-over-previous-versions/", "published_at": "2017-12-21T01:30:17+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8121e6f0", "title": "SQL Server 2017 In-Memory enhancements and improvements over previous versions", "url": "https://sqlwithmanoj.com/2017/12/20/sql-server-2017-in-memory-enhancements-and-improvements-over-previous-versions/", "published_at": "2017-12-20T01:30:40+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb81456f3a", "title": "SQL Server 2017 RTM, download, and cool “New Features” !!!", "url": "https://sqlwithmanoj.com/2017/11/16/sql-server-2017-rtm-download-and-cool-new-features/", "published_at": "2017-11-16T01:30:32+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb820c2730", "title": "SQL DBA – Get top Tables with Stale Statistics", "url": "https://sqlwithmanoj.com/2017/11/10/sql-dba-get-top-tables-with-stale-statistics/", "published_at": "2017-11-10T11:09:30+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb82cf7174", "title": "Microsoft Azure Data Platform – September (2017) update", "url": "https://sqlwithmanoj.com/2017/10/01/microsoft-azure-data-platform-september-2017-update/", "published_at": "2017-10-01T01:30:01+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb839886c7", "title": "SSMS Installation Error – This version of SSMS cannot be installed because a xyz version of SSMS 17.0 was detected", "url": "https://sqlwithmanoj.com/2017/09/23/ssms-installation-error-this-version-of-ssms-cannot-be-installed-because-a-xyz-version-of-ssms-17-0-was-detected/", "published_at": "2017-09-23T01:30:06+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb83df63b3", "title": "Microsoft Azure Data Platform – August (2017) update", "url": "https://sqlwithmanoj.com/2017/09/01/microsoft-azure-data-platform-august-2017-update/", "published_at": "2017-09-01T01:30:23+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb84d86fea", "title": "Migrate from Oracle to SQL Server for free !!!", "url": "https://sqlwithmanoj.com/2017/08/29/migrate-from-oracle-to-sql-server-for-free/", "published_at": "2017-08-29T01:30:15+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb85a451a3", "title": "Sample 14 Interview Questions and Answers for Hadoop Administration Certified Professional", "url": "https://sqlwithmanoj.com/2017/08/21/sample-14-interview-questions-and-answers-for-hadoop-administration-certified-professional/", "published_at": "2017-08-21T01:30:16+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb868dfe7f", "title": "SQL Trivia – How to convert milliseconds to [hh:mm:ss.ms] format", "url": "https://sqlwithmanoj.com/2017/08/01/sql-trivia-how-to-convert-milliseconds-to-hhmmss-ms-format/", "published_at": "2017-08-01T14:07:47+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8772b8f6", "title": "Microsoft Azure Data Platform – July (2017) update", "url": "https://sqlwithmanoj.com/2017/08/01/microsoft-azure-data-platform-july-2017-update/", "published_at": "2017-08-01T01:30:01+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb87f0e4ad", "title": "SQL Server 2017 Release Candidate (RC1, full & final version) is available for download", "url": "https://sqlwithmanoj.com/2017/07/21/sql-server-2017-release-candidate-rc1-full-final-version-is-available-for-download/", "published_at": "2017-07-21T01:30:27+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb88e25b73", "title": "SQL DBA – Query to check Status of last running SQL Jobs", "url": "https://sqlwithmanoj.com/2017/07/20/sql-dba-query-to-check-status-of-last-running-sql-jobs/", "published_at": "2017-07-20T01:30:55+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8907ae0c", "title": "SQL DBA – SQL Agent Job history not showing or vanishing away", "url": "https://sqlwithmanoj.com/2017/07/17/sql-dba-sql-agent-job-history-not-showing-or-vanishing-away/", "published_at": "2017-07-17T01:30:25+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb89a6f1a6", "title": "SQL DBA – Stop multiple running SQL Jobs at once", "url": "https://sqlwithmanoj.com/2017/06/14/sql-dba-stop-multiple-running-sql-jobs-at-once/", "published_at": "2017-06-14T01:30:36+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8a8b839b", "title": "DACPAC – Could not deploy package, the database platform service with type Sql130DatabaseSchemaProvider is not valid", "url": "https://sqlwithmanoj.com/2017/06/12/dacpac-could-not-deploy-package-the-database-platform-service-with-type-sql130databaseschemaprovider-is-not-valid/", "published_at": "2017-06-12T01:30:42+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8b0d7215", "title": "SQL Error – Cannot connect to xyz_sql_instance, due to remote firewall issue", "url": "https://sqlwithmanoj.com/2017/06/11/sql-error-cannot-connect-to-xyz_sql_instance-due-to-remote-firewall-issue/", "published_at": "2017-06-11T01:30:06+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8b28651b", "title": "SSMS error – The Visual Studio component cache is out of date. Please restart Visual Studio.", "url": "https://sqlwithmanoj.com/2017/06/10/ssms-error-the-visual-studio-component-cache-is-out-of-date-please-restart-visual-studio/", "published_at": "2017-06-10T01:30:44+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8b349066", "title": "Powershell error – Import-Module : File AzureRM.psm1 cannot be loaded because running scripts is disabled on this system", "url": "https://sqlwithmanoj.com/2017/06/09/powershell-error-import-module-file-azurerm-psm1-cannot-be-loaded-because-running-scripts-is-disabled-on-this-system/", "published_at": "2017-06-09T01:30:20+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8b581cdc", "title": "Powershell error – The term ‘Login-AzureRmAccount’ is not recognized as the name of a cmdlet, function, script file, or operable program", "url": "https://sqlwithmanoj.com/2017/06/08/powershell-error-the-term-login-azurermaccount-is-not-recognized-as-the-name-of-a-cmdlet-function-script-file-or-operable-program/", "published_at": "2017-06-08T01:30:45+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8b5dc0b9", "title": "Error – The following feature couldn’t be installed – .NET Framework 3.5", "url": "https://sqlwithmanoj.com/2017/06/04/error-the-following-feature-couldnt-be-installed-net-fremework-3-5/", "published_at": "2017-06-04T01:30:48+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8c1880d2", "title": "Parsing nested JSON in customized SQL Tabular format – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2017/06/02/parsing-nested-json-in-customized-sql-tabular-format-msdn-tsql-forum/", "published_at": "2017-06-02T01:30:33+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8cad8385", "title": "Microsoft hosts its first-ever Accessibility Summit in India to enhance technology access for people with disabilities", "url": "https://sqlwithmanoj.com/2017/05/30/microsoft-hosts-its-first-ever-accessibility-summit-in-india-to-enhance-technology-access-for-people-with-disabilities/", "published_at": "2017-05-30T13:30:39+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8cc19b13", "title": "Preparing for Exam 70-761, Querying Data with Transact-SQL | Certification", "url": "https://sqlwithmanoj.com/2017/05/29/preparing-for-exam-70-761-querying-data-with-transact-sql-certification/", "published_at": "2017-05-29T01:30:58+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8d41842b", "title": "Tabular Model Project does not load in Visual Studio – need SSDT", "url": "https://sqlwithmanoj.com/2017/05/22/tabular-model-project-does-not-load-in-visual-studio-need-ssdt/", "published_at": "2017-05-22T10:04:14+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8d753d4d", "title": "SQL Server 2016 Certification Path", "url": "https://sqlwithmanoj.com/2017/05/21/sql-server-2016-certification-path/", "published_at": "2017-05-21T01:30:00+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8e001ba0", "title": "Microsoft released SQL Server 2017 CTP 2.0 – new features, enhancements & what’s new for Linux", "url": "https://sqlwithmanoj.com/2017/04/19/microsoft-released-sql-server-2017-ctp-2-0-new-features-enhancements-whats-new-for-linux/", "published_at": "2017-04-19T01:30:55+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8e794f6b", "title": "SQL Trivia – Return every Nth row from Table or a result set", "url": "https://sqlwithmanoj.com/2017/04/03/sql-trivia-return-every-nth-row-from-table-or-a-result-set/", "published_at": "2017-04-03T13:22:51+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8f6f3926", "title": "Get Row Count of Insert/Update/Delete records in MERGE Statement – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2017/03/29/get-row-count-of-insertupdatedelete-records-in-merge-statement-msdn-tsql-forum/", "published_at": "2017-03-29T01:30:14+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8fc57852", "title": "SSDT – OLE DB or ODBC error: Login failed for user ‘DOMAIN\\ComputerName $’ 28000", "url": "https://sqlwithmanoj.com/2017/03/23/ssdt-ole-db-or-odbc-error-login-failed-for-user-domaincomputername-28000/", "published_at": "2017-03-23T17:08:05+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8fe3f605", "title": "Which SQL Server Certification should I take: 98-364, 70-461 or 70-761 ? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2017/02/18/which-sql-server-certification-should-i-take-98-364-70-461-or-70-761-msdn-tsql-forum/", "published_at": "2017-02-18T01:30:58+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb8fe4d068", "title": "SQL Server 2016 Install Error – Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed", "url": "https://sqlwithmanoj.com/2017/02/09/sql-server-2016-install-error-rule-oracle-jre-7-update-51-64-bit-or-higher-is-required-for-polybase-failed/", "published_at": "2017-02-09T01:30:06+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb906f8491", "title": "This blog just crossed 2 million hits – Thanks !!!", "url": "https://sqlwithmanoj.com/2017/01/22/this-blog-just-crossed-2-million-hits-thanks/", "published_at": "2017-01-22T01:30:52+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb9100f5db", "title": "New built-in function CONCAT_WS() in SQL Server 2017", "url": "https://sqlwithmanoj.com/2017/01/20/new-built-in-function-concat_ws-in-sql-server-vnext-2018/", "published_at": "2017-01-20T01:30:01+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb918c1ffc", "title": "Connect SQL Server on Linux with SSMS from a Windows machine", "url": "https://sqlwithmanoj.com/2017/01/06/connect-sql-server-on-linux-with-ssms-from-a-windows-machine/", "published_at": "2017-01-06T01:30:48+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb91dc2a60", "title": "Install and Configure SQL Server 2017 on Linux Azure VM", "url": "https://sqlwithmanoj.com/2017/01/04/install-and-configure-sql-server-vnext-on-linux-azure-vm/", "published_at": "2017-01-04T01:30:16+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb91f39828", "title": "Spinning up a new Linux VM on Microsoft Azure", "url": "https://sqlwithmanoj.com/2017/01/02/spinning-up-a-new-ubuntu-linux-vm-on-microsoft-azure/", "published_at": "2017-01-02T01:30:39+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb92cca3db", "title": "2016 blogging in review", "url": "https://sqlwithmanoj.com/2016/12/31/2016-blogging-in-review/", "published_at": "2016-12-31T01:30:03+00:00" }, { "id": "01a0d1d2-d542-737a-b534-1acb9354994b", "title": "New built-in function TRANSLATE() in SQL Server 2017", "url": "https://sqlwithmanoj.com/2016/12/29/new-built-in-function-translate-in-sql-server-vnext-2018/", "published_at": "2016-12-29T01:30:55+00:00" } ] posts Claim your blog
Back to sqlwithmanoj.com
Blog · corpus.blog/blogs/sqlwithmanoj.com/posts

sqlwithmanoj.com

sqlwithmanoj.com

2024

SQL Server 2025 Private Preview – Built-in AI, Fabric connectivity, Native JSON, and many more…original ↗
22 Nov 2024
Azure SQL Database in Fabric Public Previeworiginal ↗
20 Nov 2024
“Generative AI”, my take after finishing a courseoriginal ↗
11 Jan 2024

2022

SQL Planner, a monitoring tool for SQL Server for DBAs & Developersoriginal ↗
22 Apr 2022
2021 blogging in review (Thank you & Happy New Year 2022 !!!)original ↗
1 Jan 2022

2021

SQL Server 2022 preview announced, some awesome new features !!!original ↗
8 Nov 2021
SQL DBA – Integration Services evaluation period has expiredoriginal ↗
2 Jul 2021
Spark – Cannot perform Merge as multiple source rows matched…original ↗
17 Jun 2021
Python – Delete/remove unwanted rows from a DataFrameoriginal ↗
15 Apr 2021
Python error – Length of passed values is 6, index implies 2 (while doing PIVOT with MultiIndex or multiple columns)original ↗
14 Apr 2021
Cosmos DB & PySpark – Retrieve all attributes from all Collections under all Databasesoriginal ↗
12 Apr 2021
Using Python in Azure Databricks with Cosmos DB – DDL & DML operations by using “Azure-Cosmos” library for Pythonoriginal ↗
9 Apr 2021
Python error: while converting Pandas Dataframe or Python List to Spark Dataframe (Can not merge type)original ↗
8 Apr 2021
Connect to Cosmos DB from Databricks and read data by using Apache Spark to Azure Cosmos DB connectororiginal ↗
7 Apr 2021
Cosmos DB – Retrieve all attributes/fields from the JSON document of all Collections (using .net)original ↗
6 Apr 2021
Cosmos DB – Get record COUNT from all Collections in all Databases (using .net)original ↗
1 Apr 2021
Access VSO Work Items in Postman, by using Azure DevOps REST APIs, using PAT (Personal Access Token) authenticationoriginal ↗
4 Mar 2021
REST API, PATCH request error, Postman – Valid content types for this method are: application/json-patch+jsonoriginal ↗
2 Mar 2021
Database backup to Azure blob storage with SQL Server 2016+original ↗
9 Feb 2021

2020

2020 blogging in review (Thank you & Happy New Year 2021 !!!)original ↗
31 Dec 2020
Apache Spark – new Features & Improvements in Spark 3.0original ↗
27 Oct 2020
Apache Spark – RDD, DataFrames, Transformations (Narrow & Wide), Actions, Lazy Evaluation (Part 3)original ↗
23 Oct 2020
Apache Spark – main Components & Architecture (Part 2)original ↗
19 Oct 2020
Apache Spark – Introduction & main features (Part 1)original ↗
12 Oct 2020
Spark error – Parquet does not support decimal. See HIVE-6384original ↗
5 Aug 2020
Azure Data Factory (ADF) Pipeline failure – found more columns than expected column count (DelimitedTextMoreColumnsThanDefined)original ↗
29 Jul 2020
SQL DBA – Change RECOVERY mode & SHRINK all databases at once in SQL Serveroriginal ↗
17 Jul 2020
Databricks Notebook error: Your administrator has only allowed sql and scala commands on this cluster.original ↗
7 Jun 2020
Spark SQL – Beware of Implicit datatype conversions (TypeCoercion)original ↗
5 Mar 2020
SQL Error – “SELECT TOP 100” throws error in SparkSQL – what’s the correct syntax?original ↗
22 Jan 2020

2019

SQL Server 2019 released, awesome new features – download now !!!original ↗
4 Nov 2019
Spark/Scala: Convert or flatten a JSON having Nested data with Struct/Array to columns (Question)original ↗
9 Jan 2019

2018

2018 blogging in review (Happy New Year – 2019 !!!)original ↗
31 Dec 2018
Hadoop/HDFS storage types, formats and internals – Text, Parquet, ORC, Avrooriginal ↗
30 Dec 2018
Powershell – Restart Azure VM and log off Users remotelyoriginal ↗
21 Oct 2018
SQL Server 2019 initial “Community Technology Preview” is out – download and check the CTP 2.0 release now !original ↗
24 Sept 2018
Migrate your SQL Server database to Azure by using SysTools “SQL to Azure Migration” Tooloriginal ↗
5 Sept 2018
SQL Server on Linux – Best practices post installationoriginal ↗
30 Aug 2018
SQL Python Error – ‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.original ↗
29 Aug 2018
Get started with Python on SQL Server – Run Python with T-SQL on SSMSoriginal ↗
10 Aug 2018
Azure Databricks learning resources (documentation and videos)original ↗
6 Aug 2018
Azure Databricks (a fully managed Apache Spark offering)original ↗
28 Jul 2018
Azure SQL Data Sync – keep your data in sync between Azure Hybrid environment SQL Server and SQL DBoriginal ↗
12 Jul 2018
All about Blockchain – Introductionoriginal ↗
25 Jun 2018
SQL Tips – Issues with BCP when you have two SQL Server instancesoriginal ↗
8 Jun 2018
SQL Job creation failing (having VBScript step) after SQL Server 2016/2017 upgradeoriginal ↗
21 May 2018
SQL Server 2017 Setup error – VS Shell installation has failed with exit code 1638original ↗
14 May 2018
Prepare for Certification Exam 70-775: Perform Data Engineering on Microsoft Azure HDInsightoriginal ↗
9 Apr 2018
An introduction to Azure HDInsight – Microsoft’s Big-Data/Hadoop solution on Azureoriginal ↗
2 Mar 2018
Download SQL Server 2017 for free (with full MSBI stack)original ↗
1 Mar 2018
Meltdown and Spectre vulnerability, all about, and references for patching Windows OS & SQL Serveroriginal ↗
23 Feb 2018
What is Lambda Architecture? and what Azure offers with its new Cosmos DB?original ↗
16 Feb 2018
Create a new Azure SQL Database (on PaaS) step by steporiginal ↗
15 Feb 2018
Get started with Microsoft Azure, create your Account and free Subscriptionoriginal ↗
8 Feb 2018
An Introduction to Cloud Computing …aligned with Microsoft Azureoriginal ↗
7 Feb 2018
SQL Error – Cannot open backup device ‘https://xyz.blob.core.windows.net/xyz/xyz.bak’. Operating system error 50(The request is not supported.).original ↗
6 Feb 2018
SQL Trivia – SQL Server Code namesoriginal ↗
25 Jan 2018
SQL Error – SQL Server Installation fails | Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed)…original ↗
9 Jan 2018
Seeking response on: LDAP Authentication with SQL Server 2017 on Linuxoriginal ↗
8 Jan 2018
Download & Install SQL Server Reporting Services (SSRS) 2017 (decoupled from SQL Server engine setup)original ↗
7 Jan 2018

2017

2017 blogging in revieworiginal ↗
31 Dec 2017
SQL Server 2017 – ColumnStore Index enhancements and improvements over previous versionsoriginal ↗
21 Dec 2017
SQL Server 2017 In-Memory enhancements and improvements over previous versionsoriginal ↗
20 Dec 2017
SQL Server 2017 RTM, download, and cool “New Features” !!!original ↗
16 Nov 2017
SQL DBA – Get top Tables with Stale Statisticsoriginal ↗
10 Nov 2017
Microsoft Azure Data Platform – September (2017) updateoriginal ↗
1 Oct 2017
SSMS Installation Error – This version of SSMS cannot be installed because a xyz version of SSMS 17.0 was detectedoriginal ↗
23 Sept 2017
Microsoft Azure Data Platform – August (2017) updateoriginal ↗
1 Sept 2017
Migrate from Oracle to SQL Server for free !!!original ↗
29 Aug 2017
Sample 14 Interview Questions and Answers for Hadoop Administration Certified Professionaloriginal ↗
21 Aug 2017
SQL Trivia – How to convert milliseconds to [hh:mm:ss.ms] formatoriginal ↗
1 Aug 2017
Microsoft Azure Data Platform – July (2017) updateoriginal ↗
1 Aug 2017
SQL Server 2017 Release Candidate (RC1, full & final version) is available for downloadoriginal ↗
21 Jul 2017
SQL DBA – Query to check Status of last running SQL Jobsoriginal ↗
20 Jul 2017
SQL DBA – SQL Agent Job history not showing or vanishing awayoriginal ↗
17 Jul 2017
SQL DBA – Stop multiple running SQL Jobs at onceoriginal ↗
14 Jun 2017
DACPAC – Could not deploy package, the database platform service with type Sql130DatabaseSchemaProvider is not validoriginal ↗
12 Jun 2017
SQL Error – Cannot connect to xyz_sql_instance, due to remote firewall issueoriginal ↗
11 Jun 2017
SSMS error – The Visual Studio component cache is out of date. Please restart Visual Studio.original ↗
10 Jun 2017
Powershell error – Import-Module : File AzureRM.psm1 cannot be loaded because running scripts is disabled on this systemoriginal ↗
9 Jun 2017
Powershell error – The term ‘Login-AzureRmAccount’ is not recognized as the name of a cmdlet, function, script file, or operable programoriginal ↗
8 Jun 2017
Error – The following feature couldn’t be installed – .NET Framework 3.5original ↗
4 Jun 2017
Parsing nested JSON in customized SQL Tabular format – MSDN TSQL forumoriginal ↗
2 Jun 2017
Microsoft hosts its first-ever Accessibility Summit in India to enhance technology access for people with disabilitiesoriginal ↗
30 May 2017
Preparing for Exam 70-761, Querying Data with Transact-SQL | Certificationoriginal ↗
29 May 2017
Tabular Model Project does not load in Visual Studio – need SSDToriginal ↗
22 May 2017
SQL Server 2016 Certification Pathoriginal ↗
21 May 2017
Microsoft released SQL Server 2017 CTP 2.0 – new features, enhancements & what’s new for Linuxoriginal ↗
19 Apr 2017
SQL Trivia – Return every Nth row from Table or a result setoriginal ↗
3 Apr 2017
Get Row Count of Insert/Update/Delete records in MERGE Statement – MSDN TSQL forumoriginal ↗
29 Mar 2017
SSDT – OLE DB or ODBC error: Login failed for user ‘DOMAIN\ComputerName $’ 28000original ↗
23 Mar 2017
Which SQL Server Certification should I take: 98-364, 70-461 or 70-761 ? – MSDN TSQL forumoriginal ↗
18 Feb 2017
SQL Server 2016 Install Error – Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failedoriginal ↗
9 Feb 2017
This blog just crossed 2 million hits – Thanks !!!original ↗
22 Jan 2017
New built-in function CONCAT_WS() in SQL Server 2017original ↗
20 Jan 2017
Connect SQL Server on Linux with SSMS from a Windows machineoriginal ↗
6 Jan 2017
Install and Configure SQL Server 2017 on Linux Azure VMoriginal ↗
4 Jan 2017
Spinning up a new Linux VM on Microsoft Azureoriginal ↗
2 Jan 2017

2016

2016 blogging in revieworiginal ↗
31 Dec 2016
New built-in function TRANSLATE() in SQL Server 2017original ↗
29 Dec 2016
Next