Showing posts from October, 2018

How much affects encryption to your database performance?

Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media is stolen. This technology works by implementing real-time I/O encryption and decryption, so this implementation is transparent for your applications and users. However, this type of implementation could lead to some performance degradation since more resources must be allocated in order to perform the encrypt/decrypt operations. On this post we will compare how much longer take some of the most common DB operations, so in case you are planning to implement it on your database, you can have an idea on what to expect from different operations. Setup of our example For this example we will use the Wide World Importers sample database, and restore it 2 times, one decrypted, and the other one encrypted. Please note that the restored database is around 3.2 GB size, a relatively small one. To encrypt one of t

Query to determine XE Session status

On a previous post , we discussed what is an extended event (XE) and how to create one. With the following T-SQL you can quickly check what are the currently running Extended Events sessions: SELECT, iif( IS NULL , 0, 1) AS running FROM sys.dm_xe_sessions RS RIGHT JOIN sys.server_event_sessions ES ON = --WHERE = '<YOUR XE SESSION NAME>' The column running will show 0 if the session is currently stopped and 1 if it is currently running. In the commented WHERE clause, you can filter for a specific session. Hope this helps you to monitor your XE sessions!

how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to visualize data interactively from different data sources in a collaborative way. On this post I will show you a quick way to embed your PowerBI reports into HTML code, that can help you to publish reports to websites. For this, you will need a PowerBI Pro subscription (you can try it by free for 60 days) Once you are logged to your PowerBI Pro account, select any published report you want to embed, as follows (for this example I will use a test report I have with imported dataset) Generating HTML code for the report Click on File and select Publish to web A message to create an embed code will appear, click on it A warning will also appear since your data will be public, click on publish And that is all, now you have your HTML code to share it wherever you want. What if you want to stop