SQL Planner, a monitoring tool for SQL Server for DBAs & Developers
SQL with Manoj
by Manoj Pandey
10M ago
  SQL Planner is a Microsoft SQL Server monitoring Software product that helps DBA or Developer to identify issues (for ex. High CPU, Memory, Disk latency, Expensive query, Waits, Storage shortage, etc) and root cause analysis with a fast and deep level of analytical reports. Historical data is stored in the repository database for as ..read more
Visit website
2021 blogging in review (Thank you & Happy New Year 2022 !!!)
SQL with Manoj
by Manoj Pandey
1y ago
  Happy New Year 2022… from SQL with Manoj !!!   As WordPress.com Stats helper monkeys have stopped preparing annual report from last few years for the blogs hosted on their platform. So I started preparing my own Annual Report every end of the year to thank my readers for their support, feedback & motivation ..read more
Visit website
SQL Server 2022 preview announced, some awesome new features !!!
SQL with Manoj
by Manoj Pandey
1y ago
  SQL Server 2022 is coming !!!   On 2nd November 2021 in MS Ignite 2021 event Microsoft announced the preview of new version of SQL Server i.e. SQL Server 2022.     SQL Server 2022 will be more focused on Azure-enabled cloud and big data space, here are some excerpts from the announcements:   ..read more
Visit website
SQL DBA – Integration Services evaluation period has expired
SQL with Manoj
by Manoj Pandey
1y ago
  I got an email from one SQL Server developer that he is not able to use import/export wizard and it is failing with below error: TITLE: SQL Server Import and Export Wizard -------------------------------------- Data flow execution failed. Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has expired. Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has ..read more
Visit website
Spark – Cannot perform Merge as multiple source rows matched…
SQL with Manoj
by Manoj Pandey
1y ago
  In SQL when you are syncing a table (target) from an another table (source) you need to make sure there are no duplicates or repeated datasets in either of the Source or Target tables, otherwise you get following error: UnsupportedOperationException: Cannot perform Merge as multiple source rows matched and attempted to modify the same ..read more
Visit website
Python – Delete/remove unwanted rows from a DataFrame
SQL with Manoj
by Manoj Pandey
1y ago
  As you start using Python you will fall in love with it, as its very easy to solve problems by writing complex logic in very simple, short and quick way. Here we will see how to remove rows from a DataFrame based on an invalid List of items.   Let’s create a sample Pandas ..read more
Visit website
Python error – Length of passed values is 6, index implies 2 (while doing PIVOT with MultiIndex or multiple columns)
SQL with Manoj
by Manoj Pandey
1y ago
  As I’m new to Python and these days using it for some Data Analysis & Metadata handling purpose, and also being from SQL background here I’m trying to use as many analysis features I use with SQL, like Group By, Aggregate functions, Filtering, Pivot, etc.   Now I had this particular requirement to PIVOT ..read more
Visit website
Cosmos DB & PySpark – Retrieve all attributes from all Collections under all Databases
SQL with Manoj
by Manoj Pandey
1y ago
  In one of my [previous post] we saw how to retrieve all attributes from the items (JSON document) of all Collections under all Databases by using C# .net code. Here in this post we will see how we can retrieve the same information in Azure Databricks environment by using Python language instead of C ..read more
Visit website
Using Python in Azure Databricks with Cosmos DB – DDL & DML operations by using “Azure-Cosmos” library for Python
SQL with Manoj
by Manoj Pandey
1y ago
  In one of my [previous post] we saw how to connect to Cosmos DB from Databricks by using the Apache Spark to Azure Cosmos DB connector. But that connector is limited to read and write data in Cosmos DB from Databricks compute using Scala language. Here in this post we will see how can ..read more
Visit website
Python error: while converting Pandas Dataframe or Python List to Spark Dataframe (Can not merge type)
SQL with Manoj
by Manoj Pandey
1y ago
  Data typecasting errors are common when you are working with different DataFrames across different languages, like here in this case I got datatype mixing error between Pandas & Spark dataframe: TypeError: field col1: Can not merge type <class 'pyspark.sql.types.longtype'> and <class 'pyspark.sql.types.stringtype'>   While converting the Pandas DataFrame to Spark DataFrame its throwing error ..read more
Visit website

Follow SQL with Manoj on Feedspot

Continue with Google
OR