Optimize SQL queries using subqueries for lookups in Azure SQL Databases Tuesday, April 27, 2021 11:00 PM Toni Pohl I like to work with Azure SQL Databases and use data from the cloud without any administrative effort. When working with apps, App Insights helps to detect anomalies, and to analyze bottle necks. Although SQL Azure can scale very well, we discovered performance issues in some legacy apps. Read here how we solved that by optimizing TSQL data queries. Azure | Developer | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
How to copy table data between Azure SQL Databases Wednesday, September 18, 2019 9:30 PM Toni Pohl Working with Azure SQL Databases is handy. Just, how can I copy data from one Azure SQL database to another database? See the best practice here. Azure | Developer | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Get data from SQL Server for GDPR and more Friday, April 20, 2018 4:00 PM Toni Pohl Getting ready for GDPR? Well, often data is stored in relational databases as in SQL Server – in the cloud or on premises. If you need to report what relevant data is stored in such a SQL database, the following scripts can help. Azure | Cloud | Developer | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Looking for Microsoft SQL Server Configuration Manager? Thursday, April 19, 2018 5:00 PM Toni Pohl In former versions of Microsoft SQL Server, the SQL Server Configuration Manager was an extra app for configuring the SQL Server services. Since this is gone since some versions, we often get the question where to find the configuration tool nowadays with the modern versions of SQL Server… Developer | English | Microsoft | SQL Server | Tools | Windows Mediumlink | Permalink | Comments (1) | Post RSS mehr
Get the size of a SQL Azure database quickly Friday, April 6, 2018 6:00 AM Toni Pohl To get the size of a database, there are multiple ways. TSQL is one of the fastest methods. Here’s how. Azure | Cloud | Developer | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
How to restrict access and to connect to a single SQL Azure database only Saturday, January 27, 2018 5:00 PM Toni Pohl As of today, many organizations use various Microsoft Azure services. SQL Azure databases are popular among them. Often, IT Administrators want to allow departments or vendors full access to just one specific SQL Azure database and to restrict their access to other resources. See here how this works. Azure | Cloud | Developer | English | Microsoft | SQL Server | Security Mediumlink | Permalink | Comments (0) | Post RSS mehr
Get tables and rows of a SQL Azure database quickly Thursday, December 21, 2017 6:00 PM Toni Pohl …by using a query as here. Azure | English | Developer | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Import and export data to an Azure SQL Database Thursday, December 7, 2017 5:00 PM Toni Pohl BCP, the bulk copy program utility is still around - and it’s helpful! It’s a long time, since I used this tool, but nowadays it got promoted for one of my daily jobs. See a short description how to use the Microsoft Command Line Utilities with Azure SQL Database for connecting and importing and exporting data quickly. Azure | Cloud | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Optimize your Azure SQL Database performance with Automatic Tuning Wednesday, December 6, 2017 7:00 AM Toni Pohl When moving SQL databases to Azure, let Azure do some work for you. As the name suggests, the Azure SQL Database Automatic Tuning feature provides automatic performance optimization for databases. Activate it, it’s simple. Azure | Cloud | Developer | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Add your local IP address to a SQL Azure Firewall easily Saturday, May 6, 2017 6:00 AM Toni Pohl When working with SQL Azure you are aware that a connection is just established, if the client’s IP address is configured in the firewall of the SQL Azure database server. You needed to open the Azure Portal-SQL servers service, and add your IP address manually. Well, the good story is, now the SQL Server 2016 Management Studio does this for you! Azure | Cloud | English | Developer | Microsoft | SQL Server | Security Mediumlink | Permalink | Comments (0) | Post RSS mehr
Integrate Microsoft Flow with an onprem SQL Server Tuesday, April 25, 2017 6:00 AM js The blog shows how a Microsoft Flow can be integrated with an onprem SQL Server and retrieve and filter data dynamically from the database. Azure | Cloud | Flow | Microsoft | Office365 | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr
Connect to a SQL Azure database with Power-BI Tuesday, November 22, 2016 7:00 AM Toni Pohl From time to time… user’s have difficulties to connect to a SQL Azure Database with Power-BI. So I decided to post this article as a brief hint (and as reminder for myself), how to connect from Power-BI. Azure | Cloud | English | Microsoft | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr