See more about SharePoint Conference 2019 here.
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.
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…
To get the size of a database, there are multiple ways. TSQL is one of the fastest methods. Here’s how.
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.
…by using a query as here.
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.
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.
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!
The blog shows how a Microsoft Flow can be integrated with an onprem SQL Server and retrieve and filter data dynamically from the database.
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.
In vielen Lösungen mit Microsoft-Technologien steckt SQL Server drin. Um Daten in der Cloud-Umgebung im SQL Server abzusichern, bietet Microsoft nun das Feature Always Encrypted in Azure SQL Databases” an. Always Encrypted hilft somit, Daten bereits auf der Client-Seite automatisiert zu verschlüsseln und zu schützen. Mehr dazu hier!
Seit Anfang Juni ist Microsoft SQL Server 2016 RTM verfügbar. Für Developer ist es natürlich interessant, mit den neuesten Bits zu spielen und eigene Apps dafür zu optimieren. Das geht nun ganz einfach, ohne eigene, zeitintensives Setup!