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
  • RedShift
    • Redshift – How to flatten JSON data in redshift

Learn Sql Team

Let's learn together

Category: RedShift

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

About Me

https://youtu.be/n5LFhw9CEBc
February 2019
M T W T F S S
« Dec    
 123
45678910
11121314151617
18192021222324
25262728  

Categories

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

Join 1,576 other followers

Top Posts

  • How to export SSIS package ( dtsx file) from SSISDB
  • NetFx3 error while installing SQL Server 2012
  • Microsoft Contoso BI Demo Dataset for Retail Industry
  • Microsoft Best Practice Analyzer
  • Comparison between AMAZON RDS and SQL Server on EC2
  • How to bypass restart computer error message while installing SQL Patch
  • 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.
  • The server principal "XYZ\USER" is not able to access the database "YourDBName" under the current security context
  • The target database, 'xxx', is participating in an availability group and is currently not accessible for queries.
  • Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.

Recent Comments

How to enable cron s… on How to connect AWS EC2 instanc…
peng zhang on The transaction log for databa…
Candy G. Fox on Cannot be configured for publi…
learnsqlteam on SQL Server 2012 Always On Step…

Social

  • Facebook
Blog at WordPress.com.