A Fine Slice Of SQL Server
Thomas Williams continues to personalize the command line:
In my last post, I customised my Linux command line with 4 dotfiles. Putting the time into finding my way around the command line, and learning Linux commands, becomes more important on a Linux server because there’s no GUI.
I’ll continue tweaking in this post by modernising two classic commands I use daily, and adding two helper packages.
Read on for a few Linux packages that make life easier.
Leave a CommentWhile on site this week, another common problem that I see everywhere arose again.
When you need to format currency, you use the “c” format right? It’s in nearly every set of course materials I’ve ever seen. And people do it in almost every demonstration.
But so often, that’s wrong!
Read on to learn why and what you can do instead.
Leave a CommentAaron Merrill shares some guidance:
As outlined in our technical whitepaper, ‘The future of data security is interoperability‘, permissions that move with data is the future of data security. As modern data lakes are built on open-source technology like Delta and Iceberg, customers expect to use the analytics engines and services that best fit their needs—without copying data or redefining security. This creates a clear requirement: security must be defined once and enforced consistently everywhere data is consumed.
OneLake security now provides API support for third-party enforcement through an authorized engine model. This release extends the same principles used across Microsoft Fabric to external engines and services. OneLake security is now closer to its vision of defined once, enforced everywhere, even beyond first-party workloads.
Click through for more information.
Leave a CommentJohannes Kebeck makes an announcement:
When we envisioned Maps in Microsoft Fabric, our goal was to empower any data citizen to analyze data in time and space without any specialized knowledge. Introduced in preview at FabCon Europe 2025, it has since been used by customers across industries creating and sharing map-centric applications. Additional features were added at Ignite 2025, and this week at FabCon Atlanta, Maps in Microsoft Fabric is generally available – along with new capabilities that expand how geospatial data can be modeled, visualized, and operationalized at any scale.
Read on to see what’s new in maps.
Leave a CommentJonathan Kehayias answers a question:
I have gotten a lot of email questions recently about TDE and SQL Server, specifically around the encryption hierarchy involved in protecting the encrypted data inside of a TDE enabled database in SQL Server. So, rather than continuing to write long emails that explain this fully, I figured this would be a great blog post topic for future reference as a way to reboot getting back to posting content more regularly on my blog. For an overview of TDE in SQL Server see the following topic in the Books Online (Transparent Data Encryption (TDE) – SQL Server | Microsoft Learn).
Click through to learn more about how SQL Server works with the in-built encryption system for TDE and what you need to back up in order to ensure you can correct anything that might go wrong.
Leave a Comment