When learning something new, we always compare it with what we know. In this case, we end […]
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]
Introduction If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged […]
Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m […]
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […]
An entire post on choosing the correct data types either seems like overkill or much needed and […]
As you all know about, just a few weeks ago we had the big CrowdStrike global IT […]
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […]
Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more […]
This is the second part of my series on auditing SQL Server. In the first part, I […]
There was a lot of great advice, and I really wonder how much of this I would […]
After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One […]
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of […]
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for […]
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […]
In the first part of this two-part series, I covered the mostly non-technical aspects of building a […]
I have been talking about Data Exploration in Power BI on many of my sessions, specially the […]
The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […]
Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode(« overwrite »).format(« delta »).partitionBy(« Year », »Month », »Day »).save(« Tables/ » + table_name) […]
Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […]
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
One of the first things you learn when working with SQL Server, and other transactional based SQL […]
My motivation for writing this summary was an interaction with a project owner that didn’t understand why […]
I used to think plagiarism was my worst thing to deal with as an editor. That is […]
I have always spent time learning relational databases on my own, non-work time. As the years have […]
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
I hate coming up with ideas for editorials, but my last editorial of the year gives me […]
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer […]
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
What a week it was. While it wasn’t my first in person conference this year, it felt […]
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
I was talking to some people today about the concept of Autonomous Databases. The idea is that […]
As an editor working with other people’s technical writing for many years, you might guess that either […]
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
One of the technologies that my new job brought with it was learning about all the various […]
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […]
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
