In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
2024-01-08
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
2024-01-05
Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.
2024-01-05
I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces.
2024-01-03
In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.
2024-01-01
Organizations working with on-premises SQL Server Analysis Services may not be able to guarantee optimized deployment of their models and secure and compliant data, especially during peak usage. The more companies invest in hardware and software licenses, the less the deployment of on-premises SSAS solutions becomes attractive, especially for smaller organizations with limited or narrow budgets.
2024-01-01
Learn about Microsoft Fabric and OneLake which is a single logical data lake for the entire Fabric platform in your organization.
2023-12-29
Learn about some of the overlooked but extremely useful features when building Power BI reports and dashboards.
2023-12-27
Learn about Power BI vs Tableau reporting comparison with SQL Server data to see the query differences when retrieving data.
2023-12-25
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers