home.social

#sqlcmd — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #sqlcmd, aggregated by home.social.

  1. After extensive analysis, it seems that sqlcmd doesn't manage buffers and transactions properly, and it lead to the error, when there's lot's of data. I wrote my own alternateive program for #SQLCMD using #Python, and now the import was successful. So it turns out that sqlcmd code is just bit bad, and someone had to write better alternative. To be honest, some of the individual insert statements were up to 8 megabytes per row. #SQL
  2. After extensive analysis, it seems that sqlcmd doesn't manage buffers and transactions properly, and it lead to the error, when there's lot's of data. I wrote my own alternateive program for #SQLCMD using #Python, and now the import was successful. So it turns out that sqlcmd code is just bit bad, and someone had to write better alternative. To be honest, some of the individual insert statements were up to 8 megabytes per row. #SQL
  3. After extensive analysis, it seems that sqlcmd doesn't manage buffers and transactions properly, and it lead to the error, when there's lot's of data. I wrote my own alternateive program for #SQLCMD using #Python, and now the import was successful. So it turns out that sqlcmd code is just bit bad, and someone had to write better alternative. To be honest, some of the individual insert statements were up to 8 megabytes per row. #SQL
  4. I created #SQL #dump file using #SSMS. Yet interestingly when running it with #sqlcmd, it says that it hasn't been properly #escaped. - I'll investigate it closer, but it looks interesting. Why it wouldn't be properly escaped? That's really confusing. But I'll dig into it. The dump file just just a hundreds of gigabytes which makes it bit harder.
  5. I created #SQL #dump file using #SSMS. Yet interestingly when running it with #sqlcmd, it says that it hasn't been properly #escaped. - I'll investigate it closer, but it looks interesting. Why it wouldn't be properly escaped? That's really confusing. But I'll dig into it. The dump file just just a hundreds of gigabytes which makes it bit harder.
  6. I created #SQL #dump file using #SSMS. Yet interestingly when running it with #sqlcmd, it says that it hasn't been properly #escaped. - I'll investigate it closer, but it looks interesting. Why it wouldn't be properly escaped? That's really confusing. But I'll dig into it. The dump file just just a hundreds of gigabytes which makes it bit harder.
  7. Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?

  8. Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?

  9. Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?

  10. Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?

  11. Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?

  12. learn.microsoft.com/en-us/sql/ - #sqlcmd for #mssql, rewritten from the ground up to be cross-platform and fast. Now if only it came in a pre-built #Docker #container...

  13. learn.microsoft.com/en-us/sql/ - #sqlcmd for #mssql, rewritten from the ground up to be cross-platform and fast. Now if only it came in a pre-built #Docker #container...

  14. learn.microsoft.com/en-us/sql/ - for , rewritten from the ground up to be cross-platform and fast. Now if only it came in a pre-built ...

  15. learn.microsoft.com/en-us/sql/ - #sqlcmd for #mssql, rewritten from the ground up to be cross-platform and fast. Now if only it came in a pre-built #Docker #container...

  16. Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd

    Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

    winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak

    Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

  17. Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd

    Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

    winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak

    Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

  18. Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd

    Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

    winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak

    Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

  19. Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd

    Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

    winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak

    Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

  20. Oh, cool! From MSFT: aka.ms/sqlcmd #sqlcmd

    Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

    winget install sqlcmd sqlcmd create mssql --using aka.ms/AdventureWorksLT.bak

    Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!