-
Locked yourself out of a database? get access back …
For any purpose, you set a database [named: test] to a single-user mode and forget to set AUTO_UPDATE_STATISTICS OFF before doing so, use a script to remove the single-user mode (it’s most likely the GUI dialog isn’t accessible, so the quick option is to use T-SQL) and gain access to the database back. The background…
-
When to use which visuals – Power BI
There are several types of visuals to choose from in Power BI. There are even more custom visuals you can get from the market place. Each visual has specific purpose when placed on a report/dashboard. Knowing which one to use for the right kind of data makes your report more readable and useful. Area chart –…