Select Page

How to use PowerShell in Azure Data Studio

Sydney Smith joins Scott Hanselman to show the rich editing experience provided by the PowerShell extension in Azure Data Studio by creating a SQL Server in a Linux Docker container with external storage—all using PowerShell Core in Azure Data Studio.To ... continue reading

Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters

Today were announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data ... continue reading

Visual Studio Code: Develop PySpark jobs for SQL Server 2019 Big Data Clusters

Today were announcing the support in Visual Studio Code for SQL Server 2019 Big Data Clusters PySpark development and query submission. It provides complementary capabilities to Azure Data Studio for data engineers to author and productionize PySpark jobs after data ... continue reading
createnewSQLDB.png

Getting started with Azure SQL Database Hyperscale

Azure SQL Database Hyperscale (or Hyperscale for short :smileyhappy:) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more ... continue reading
createnewSQLDB.png

Getting started with Azure SQL Database Hyperscale

Azure SQL Database Hyperscale (or Hyperscale for short) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more queries ... continue reading
A SQL Server tale of two cities

A SQL Server tale of two cities

No one disputes that data is critical to the lifeblood of business, applications, and the computer industry. SQL Server sits at the forefront of any discussion about data these days. So its no coincidence that SQL Server is seen, heard, ... continue reading
Screenshot of Postgres database health check notebook

Operationalizing your PostgreSQL database health checks using SQL Notebooks

In Craig Kerstiens‘s blog post, “A health check playbook for your Postgres database” he emphasizes the need for periodic checks for your Postgres databases to ensure it’s healthy and performing well. Most Postgres database administrators and community members would usually ... continue reading
3 ways to gain insights with SQL Server 2019 big data clusters

3 ways to gain insights with SQL Server 2019 big data clusters

Businesses today are faced with the challenge of staying profitable and investing in future innovations. Speed and flexibility are the name of the game, and effective data-scaling techniques are highly sought after. Yet exploding data volumes, diverse data types, and ... continue reading
PowerShellExample

The PowerShell Extension is now in the Azure Data Studio Marketplace

We are excited to announce the PowerShell Extension is available in the Azure Data Studio (ADS) marketplace! Now you can write PowerShell scripts with the full benefits of PowerShell Editor Services using the excellent IDE-like interface that Azure Data Studio ... continue reading
Azure Data Studio – Setting up your environment

Azure Data Studio – Setting up your environment

This blog entry comes from Buck Woody, who recently rejoined the SQL Server team from the Machine Learning and AI team. For those of you who havent met me or read any of my books or blog entries, its great ... continue reading