Improve Power BI Performance with Horizontal Filtering
In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance
DevOps and Exhibits
DevOps continues to improve the way we build software and Steve has a good example in today's editorial.
Experimenting with PostgreSQL in a Container
Learn how to get started using a container to run PostgreSQL, or really any other RDBMS, including a gotcha to watch out for.
SQL Server High CPU Query Use Monitoring with PowerShell
In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.
Application down after SQL Service logon account change
I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the reboot to ensure they were up. I verified all SQL Services and […]
Detecting Logins
A recent issue with malware and SQL Servers has Steve wondering if you would detect a new, and unapproved, login added to an instance.
Hidden treasures of SQL Prompt
You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.
The Social Impact of Artificial Intelligence and Data Privacy Issues
Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should be done to prevent the misuse of data.
Azure Resource Mover
Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure. Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a […]
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 KCP Boulevard Timur Hub.0813•7887•595
BCA KCP Boulevard Timur Hub.0813•7887•595.Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec....
BCA KCP Sumbersari No.Tlp.083179431643
Jl. Sumber Sari No.23 T 12, Babakan, Kec. Babakan Ciparay, Kota Bandung, Jawa Barat...
BCA KCP Ahmad Yani II Whatsapp:083138717148.
Whatsapp:083138717148.Jl. A. Yani No.280, Kacapiring, Kec. Batununggal, Kota Bandung, Jawa Barat 40271
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