select 'GRANT EXECUTE ON ' + ROUTINE_SCHEMA + '.' + ROUTINE_NAME + ' TO [myuser]' from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE'
01 October 2009
By: Ken Spencer
select 'GRANT EXECUTE ON ' + ROUTINE_SCHEMA + '.' + ROUTINE_NAME + ' TO [myuser]' from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE'
Business Intelligence
Many businesses rely on citizen developers for application development and usage, through platforms like Power BI. Here are some challneges they face and how to overcome them.
Data platform
A strong SQL server performance is a must for maintaining a stable, steady data platform.
Business Intelligence
After the theory, it is time to look at Power BI and understand the best way to apply the rules for data storytelling and visualization we spoke about in the first post of this series.