Using a Service Account in Microsoft Fabric
Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.
2024-10-25
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
2,085 reads
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier.
2024-10-02
Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric
Learn how updates and concurrency can work in Fabric with Delta Parquet data.
2024-10-02
1,326 reads
Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric
This next article examines the impact of transaction sizes on the performance of our Delta Parquet tables.
2024-09-11
2,164 reads
2024-09-06
334 reads
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default ...
2024-08-30
2024-08-30
279 reads
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Learn about object-level, column-level, and row-level security in Microsoft Fabric Warehouse and how this can be implemented to limit access to data.
2024-08-28
A New and Improved Data Warehouse: Data Engineering with Fabric
In this next installment, John performs the research you might do if your management asked you to examine Fabric.
2024-08-21
3,473 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers