SQL Server Profiler in Azure Data Studio
December 28, 2018In this article, we will explore SQL Server Profiler in Azure Data Studio in detail including download and installation, execution plans, coding T-SQL and more.
Search Results for: azure
SQL Server 2019 on Linux with Ubuntu and Azure Data Studio
November 29, 2018In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following
How to use JSON data in Azure Machine Learning
November 9, 2018Azure Machine Learning (also known as Azure ML) is cloud-based machine learning solution of Microsoft. Microsoft Azure Machine Learning is a fully-managed cloud-based service that provides the ability to create and train predictive analytic solutions. Another advantage of Azure ML is that you can access and easily make changes anywhere in machine learning models with […]
Getting Started with Azure Cosmos DB and MongoDB API
November 7, 2018In the previous article on Azure Cosmos DB, we reviewed NoSQL concepts and how to integrate with the Microsoft Azure platform-as-a-service model using the API. After working as a database engineer for over a decade, I feel that this technology is the future for many organizations for various reasons. I had that in mind as […]
Graph database implementation with Azure Cosmos DB using the API
November 5, 2018In my previous article, I’ve discussed a lot about the Graph database implementation with SQL Server 2017. In this case, we’ll see a walk-through of Graph API integration with Azure Cosmos DB. Before we jump into the concepts though, let’s take a high-level overview of NoSQL databases. A NoSQL database is designed in such a […]
SQL Server Data Import using Azure Data Studio
September 18, 2018Azure Data Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW.
Getting started with Azure Data Studio (ADS); initial installation and configuration
August 14, 2018Microsoft Azure Data Studio is a new GUI-based (vs CLI) lightweight tool for developing and managing your modern SQL databases. The tool resembles Microsoft’s lightweight code editor, the open source IDE Visual Studio Code in terms of functionalities and the UI in general. If you’ve used Visual Studio Code (or VS Code), you’d feel at home […]
Dynamic Partitioning in Azure Analysis Services (tabular)
August 6, 2018Objective The real-life requirement Disclaimer: I assume dear Reader, that you are more than familiar with the general concept of partitioning and star schema modeling. The intended audience is people who used to be called BI developers in the past (with a good amount of experience), but they have all sorts of different titles nowadays […]
Backup and Restore operations with SQL Server 2017 on Docker containers using Azure Data Studio
July 19, 2018In this 18th article of the series, we will discuss the concepts of database backup-and-restore of SQL Server Docker containers using Azure Data Studio. Before proceeding, you need to have Docker engine installed and Azure Data Studio configured on your host machine. This article covers the following topics: Overview of Azure Data Studio (ADS) How […]
How to Sync Azure SQL databases and on-premises databases with SQL Data Sync
June 4, 2018SQL Data Sync allows you to synchronize data across multiple Azure SQL databases and on-premises SQL Server databases. In this article, how to synchronize Azure SQL database with on-premises SQL Server database will be shown.
Connecting to Azure SQL Database
May 23, 2018The below screenshots and code samples are valid at the time of writing (May 2018) but as things in Azure can change so quickly, please check the latest documentation if a code sample doesn’t work as expected!
List of top Azure SQL Database tools
May 1, 2018This list provides an overview of tools that work with SQL Azure Database. If you noticed a tool we missed, please let us know in the comments below.
How to simulate the Azure SQL Database storage account behavior using the emulator
April 30, 2018Introduction When you practice and play with the Azure Storage, you spent money because you need to pay for the service. This obviously provides an incentive to discover a way to emulate the Azure Storage behavior. In this article, we will use an emulator and learn how it works.
Integrating Azure SQL database alerts into Slack
April 27, 2018Database administrators have a lot of tasks and responsibilities but perhaps the most challenging task is performance tuning. Because performance tuning issues can cause huge problems in the business area, database administrators have to monitor performance metrics and have to get immediate, if not sooner, notifications when the performance values cross an optimal state. Generally, […]
How to connect and perform a SQL Server database restore from Azure BLOB storage
April 18, 2018Having things in the cloud should make life simpler but I have experienced it’s not that straightforward. Once all access / configuration is sorted out then yes, of course! But in the meantime it can be tedious (even frustrating) and the end result is something that could have been achieved with a different method. I […]
How to install and configure Azure Data Studio for Windows
February 1, 2018Azure Data Studio is free, lightweight database development and operations cross-platform tool for private and commercial usage, that can be installed on Windows, macOS, and Linux for SQL Server, Azure SQL Database and Azure SQL Data Warehouse. Azure Data Studio is built to simplify work of database developers, database administrators, and system administrators. Azure Data […]
How to develop a K-Means model on Azure Machine Learning Studio
January 30, 2018In this article, we will discuss the k-means algorithm and how can we develop a k-means model on Azure Machine Learning Studio. Machine learning is an area of artificial intelligence that helps us develop relationships between data and predict the future. There are many secrets that are hidden in the data. To discover these secrets, […]
How to integrate SQL Server and Azure Machine Learning
January 11, 2018Good, clean and reliable data is important for every company, because well-analyzed data will open new possibilities to success. When we look at successful companies, we see that they’ve analyzed customers, sales, and finance data very well. At this point, a game changer enters: machine learning. Machine learning Machine learning is a type of artificial […]
How to use BULK INSERT to import data locally and in Azure
November 16, 2017Introduction BULK INSERT is a popular method to import data from a local file to SQL Server. This feature is supported by the moment in SQL Server on-premises. However, there is a new feature that is supported only in SQL Server 2017 on-premises. This feature allows importing data from a file stored in an Azure […]
Introduction and FAQs about Microsoft Azure technologies
October 13, 2017Most of the DBAs, Data Scientists, BI and Database developers are working on SQL Server on-premises. Is it time to migrate to the Cloud? In this new article, we will talk about numbers, statistics, Azure technologies like Virtual Machines with SQL Server, Azure SQL, Azure Data Factory, Azure Machine learning and other technologies.
How to create a linked server to an Azure SQL database
September 27, 2017Linked servers allow to access data from another SQL Server or another data source (e.g. Excel) by using SQL Server Management Studio (SSMS) or Transact-SQL. This article will explain how to create and configure a linked server to retrieve data from an Azure SQL database. Also, we will explain how to solve some common problems/issues […]
How to connect to the Azure Storage Account with SQL Server Management Studio (SSMS)
September 25, 2017Introduction In SQL Server Management Studio (SSMS), it is possible to connect to the Azure Storage. The Azure Storage Account is useful because it creates replicas automatically in the cloud. You only need to upload your file to the Azure Storage Account and the replication is automatic. You can have multiple replications in different regions […]
How to connect to (and query) Power BI and Azure using PowerShell
September 13, 2017Power BI “as a whole” is a bit of a black box. If you’re like me and used to using SQL Server & its components; SSRS, SSAS etc. you have access to installation directories, Event logs, trace logs, error logs, chocolate logs? You can see full instances & their contents in one go, whether that […]
8 things to know about Azure Cosmos DB (formerly DocumentDB)
September 4, 2017Introduction Azure Cosmos DB is a low-latency, high throughput, globally distributed, a multi-model database which can scale within minutes and offers 5 consistency options to let you decide how to deal with the CAP theorem. Azure Cosmos DB used to be known as Document DB, but since additional features were added it has now morphed […]
Configure Multi-Factor Authentication in Azure SQL Database
August 30, 2017Introduction The new SSMS 17.2 allows users to authenticate using Active Directory with Multi-Factor Authentication (MFA). This is a secure method for authentication where you have more than one method to validate your authentication. That way, you have a more secure authentication and prevent your Azure Portal or applications to be easily attacked by hackers […]