Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is […]
simple-talk.com
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where […]
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address […]
MySQL Error Log Management in DevOps Operations
When it comes to the development and operations (DevOps), one thing stands out as a critical aspect […]
Fabric Notebooks and Deployment Pipelines
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on […]
Exploring PostgreSQL Indexes
In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, […]
SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]
Understanding SQL Join Types
Understanding how to join the data in one table to another is crucial for any data analyst […]
Microsoft Fabric: Extended Source Control Features
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power […]
When an update doesn’t update
Tell me if you’ve heard this one before: I changed data from my application, but when I […]
Warehouse Load Patterns – Part 1 – Requirements and General ...
No matter the ETL tool used, there are some basic patterns to follow when transferring data between […]
Updates about Database Projects for Microsoft Fabric
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an […]
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present […]
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity […]
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt […]
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT ...
Last but not least, the Community Keynote. Hang on to your hats, this is going to be […]
PASS Summit 2023 – Redgate Keynote – The New Database ...
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! <image […]
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless ...
CEO of Redgate: Jakub Lemik: This year’s theme is Connect, Share, and Learn. Tomorrow will be People […]
Autonomous Databases?
I was talking to some people today about the concept of Autonomous Databases. The idea is that […]
Getting Started with MongoDB
MongoDB is a scalable database management system that stores data as documents in a collection, rather than […]
An editor’s biggest headache: Plagiarism
As an editor working with other people’s technical writing for many years, you might guess that either […]
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified […]
Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here […]
Moving SQL Server To The Cloud: Modernizing Stack Overflow for ...
Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a […]
Creating an Azure PostgreSQL cluster and connecting to it
One of the technologies that my new job brought with it was learning about all the various […]
Getting connected to PostgreSQL for the first time
PostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...
Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […]
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Exporting and Importing Data into SQL Server Using Files
There are plenty of applications and tools available that allow for the movement of data in and […]
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
SQL Server Security Primer
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […]
A Beginners Guide To MySQL Replication Part 6: Security Considerations ...
This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The […]
PostgreSQL Indexes: What They Are and How They Help
In the previous blog in this series, we learned how to produce, read and interpret execution plans. […]
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
T-SQL Fundamentals: Controlling Duplicates
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
SQL Server Row Level Security Deep Dive. Part 5 – ...
As mentioned in previous sections, RLS is an addition to security and should not be used as […]
MySQL joins
Tables in a MySQL database are commonly related to one another, often in multiple ways, and it […]
Analyze and Tune SQL Server Statistics
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
Download the notebook used on this blog I explained in a previous article how the Tables in […]
Alternatives To SQL-2022 Built-in function GREATEST
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]
Microsoft Fabric: Using notebooks and table partitioning to convert files ...
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […]
SQL Server Row Level Security Deep Dive. Part 3 – ...
Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […]