Building a Culture of Data: The Technical Aspects
In the first part of this two-part series, I covered the mostly non-technical aspects of building a data culture. While the lion’s share of the work will be getting people to work together and embrace ever deeper use of data, as a reader of Simpl …
Identifying Customer Buying Pattern in Power BI – Part 1
This article is part 1 of a retail analytics market-based analysis in Power BI. In part 1, we will analyze customer purchasing frequency for various products, and the trend across years. Identifying And Analyzing The Data We will be using a sales samp …
[Video] Office Hours: Hong Kong Harbor
I recently went to Shanghai & Hong Kong, and stopped to take your questions from https://pollgab.com/room/brento while sitting next to the Hong Kong harbor. Here’s what we covered: 00:00 Start 01:18 Jason G – RN & Accidental DBA: Wo …
Database Subsetting and Data Extraction
Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data. In doing …
Exploration Experience: Saving and Creating Datasets
I have been talking about Data Exploration in Power BI on many of my sessions, specially the sessions about Data Marts. The new data exploration feature is one more feature on this expanding scenario for data exploration. This one brings some interesti …
How to Have a Conversation About Software Licensing
As a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For example, the situation that inspired this post was seeing half a dozen SQL Servers with ~50 cores each, hundreds of cores total – yet they cons …
Full vs. Incremental Loads – Data Engineering with Fabric
The loading of data from a source system to target system has been well documented over the years. My first introduction to an Extract, Transform and Load program was DTS for SQL Server 7.0 in 1998. In a data lake, we have a bronze quality zone that is …
Announcing Offline Access to Your BrentOzar.com Courses
So you’ve got an iPhone or iPad or Vision Pro, and you bought one of my training classes or the Fundamentals or Mastering passes, and you wanna watch the classes while you’re offline. Perhaps you wanna learn on the train ride in to work, or …
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel. In the previous example, we determined a dist …
Finding Sister Locations to Help Each Other: Answers & Discussion
The post Finding Sister Locations to Help Each Other: Answers & Discussion appeared first on SQLServerCentral.
Disaster Recovery and High Availability Solutions in SQL Server
When managing a database, ensuring data availability and integrity is paramount, especially in the face of hardware failures, software bugs, or natural disasters. SQL Server offers a suite of features designed to provide high availability (HA) and disa …
Snake draft sorting in SQL Server, part 1
I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum …
Fabric and Azure SQL in a few clicks: Mirroring a Database
Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now. …
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for managing and manipulating database systems. A core component of SQL’s power and flexibility lies in its window functions, a c …
[Video] Office Hours: Career & Data Q&A
A few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s what we covered: 00:00 Start 02:10 Ethan: What percent of your constant care shops require encryption to connect with S …