Azure Data Studio - A First Look
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
3,560 reads
azure
Creating an Azure SQL Database Using Azure Cloud Shell
This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.
2023-07-07
1,019 reads
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
Azure Automation With Visual Studio Code
Microsoft combined the power of two powerful tools by announcing the public preview of Azure Automation Visual Studio Code Extension. This article will show you how to get started.
2023-02-22
4,989 reads
Assert Transformations in Azure Data Factory
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
2,866 reads
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,070 reads
Database Deployment with Terraform - The Basics
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
11,953 reads
Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
8,404 reads
Monitoring Azure Blob Storage
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
2022-07-08
2,107 reads
Understanding Shared Access Signature and Access Policy in Azure Storage
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
2022-06-15
5,973 reads
Blogs
Executing One Line in VSCode–#SQLNewBlogger
By Steve Jones
I wrote about arrays in PowerShell last week, but I realized one of the...
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Forums
Selecting from a view, base table has a DENY on a column
This is something I've never seen before and I can't think of the right...
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Ask SSC