Skip to content
  • Blocking and Deadlock
    • Configuring deadlock and Storing Deadlock events in a table
    • Create Blocking Alert – SQL 2005 , SQL 2008 R2 and SQL 2012
  • SQL Server BI
    • SSRS – How to convert in Day/Hour/Minute format in SSRS report
    • How to grant access on SSIS Server
    • Issues related to Oracle Client in SQL Server.
  • SQL Server Maintenance
    • How to export SSIS package ( dtsx file) from SSISDB
  • Production Issues
    • NetFx3 error while installing SQL Server 2012
    • Could not locate file ‘xy_abc_Log’ for database ‘abc’ in sys.database_files.
    • How to bypass restart computer error message while installing SQL Patch
    • Microsoft Best Practice Analyzer
    • The transaction log for database ‘XXX’ is full due to ‘LOG_BACKUP’
    • Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.
    • How to create ODBC connection from text file.
  • Replication Issues
    • Replication – Snapshot is not getting generated
    • Cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server version 7.0 or later.
    • Cannot resolve the collation conflict between “xxx” and “xxx” in the equal to operation
    • Replication Issue – Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.
    • Replication – Agents Job Location
    • Replication Issue – Replication Monitor could not open the Detail Window.
  • Hadoop
    • Reading\Writing Different file format in HDFS by using pyspark
  • SQL on Cloud
    • Comparison between AMAZON RDS and SQL Server on EC2
  • SQL Server Upgrade
    • SQL Server 2012 Upgrade from Standard Edition to Enterprise edition
  • Miscellaneous
    • SQL Server 2017: Advanced Analytics with Python
  • SQL 2012 AlwaysON
    • SQL Server 2012 Always On Step by Step Configuration
  • AWS
    • RedShift
      • Redshift – How to flatten JSON data in redshift
    • Aurora PostgreSQL vs MySQL Feature Comparison

Learn Sql Team

Let's learn together

Tag: JSON

Redshift – How to flatten JSON data in redshift

input [a,b,c,d] [b,c] [f,g,h] output a b c d b c f g h   with NS AS ( select 1 as n union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9… Read More Redshift – How to flatten JSON data in redshift

November 23, 2018November 23, 2018 learnsqlteamgmailcomLeave a comment

AWS Learning Series for Beginner

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

Categories

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,580 other followers

Top Posts

  • How to bypass restart computer error message while installing SQL Patch
  • How to enable cron schedule in AWS EC2 instance
  • Login failed for user 'xxx'. Reason: Server is in single user mode. Only one administrator can connect at this time.
  • How to export SSIS package ( dtsx file) from SSISDB
  • Microsoft Contoso BI Demo Dataset for Retail Industry
  • Installing MSSQL on MAC
  • The target database, 'xxx', is participating in an availability group and is currently not accessible for queries.
  • The server principal "XYZ\USER" is not able to access the database "YourDBName" under the current security context
  • NetFx3 error while installing SQL Server 2012
  • Replication Issue - Replication Monitor could not open the Detail Window.

Recent Comments

learnsqlteamgmailcom on SSRS – How to convert in…
Nida Cuervo on Cannot resolve the collation c…
Shashikant on SSRS – How to convert in…
Roni Vered Adar on Replication Issue – Cann…
Iryna Po on How to export SSIS package ( d…

Social

  • Facebook
Blog at WordPress.com.