Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
SQL Server Reporting Services Rest API
What functionality is available in the SQL Server Reporting Services REST API and how should you use it?
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Setting Permissions to Drop a Database
Learn which permissions are required to drop a database and see a test to show that these apply.
Using SQL Server's Default Trace to Identify Autogrow Events in tempdb
We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.
Fixing ‘A required Privilege is not held by client’ Error
This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.
The Age of Multiple Databases
There are lots of databases to choose from. Steve discusses using more of them in your work.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA JLN. ANGGREK RT01/RW12 Hub:Cs.083831618816
WhatsApp:083831618816 Perum Bumi Cikarang Asri Blk. F5-F6, Ciantra, Cikarang Sel., Kabupaten Bekasi, Jawa Barat...
BCA KCP Saharjo Telp:08213111109
Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...
BCA KCP Parung No.Tlp.083179431643
Jl. Raya Parung Gg. Kp. Jati Ruko Blok A-B, Parung, Kec. Parung, Kabupaten Bogor,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers