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

Day: November 23, 2018

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

November 2018
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Apr   Dec »

Categories

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

Join 1,535 other followers

Top Posts

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

Recent Comments

sam on Cannot be configured for publi…
learnsqlteam on Create single file in AWS Glue…
blink89 on Create single file in AWS Glue…
Lavanya on Replication Issue – Cann…
Richard Sterling on How to export SSIS package ( d…

Social

  • Facebook
Blog at WordPress.com.
  • Follow Following
    • Learn Sql Team
    • Join 1,535 other followers
    • Already have a WordPress.com account? Log in now.
    • Learn Sql Team
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar