Managing Files and Folders with Python – Data Engineering with ...
What is a data lake? It is just a bunch of files organized by folders. Keeping these files […]
Sites anglophones
A First Look at SSMS 20
Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool […]
What is Eventstream in Microsoft Fabric? – Part 1
The post What is Eventstream in Microsoft Fabric? – Part 1 appeared first on SQLServerCentral.
Join Me for Free Live SQL Server Training Next Week.
Next week, I’m teaching my very favorite class live online, for free, two different ways – one with […]
Pagination and ordering by large values
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on […]
Tinkering with Fabric Data Factory Framework Functionality
The post Tinkering with Fabric Data Factory Framework Functionality appeared first on SQLServerCentral.
Quick and Effective Migration Between CosmosDB Collections Using ADF
This document aims to explain the process of using ADF (Azure data Factory) to make a copy of […]
How to Optimize Power BI Semantic Model Performance with Vertipaq ...
The performance of a Power BI semantic model – formerly known as dataset – depends on a variety […]
[Video] Office Hours in Snowy Telluride, Colorado
On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is […]
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT […]
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be […]
Free Live Webcasts: Slide & Demo Versions of How to ...
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
Department of Redundancy Department
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think […]
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.
Find Unused or Backup Tables
In this article, I am going to demonstrate how we can identify the unused tables of a given […]
The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
The Benefits of Volunteering at SQL Saturdays
Editor note: The call for volunteer and speakers is open at on the Pass Data Community Summit […]
[Video] Office Hours: Speed Round
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 […]
SQL Server to PostgreSQL Database Schema Conversion
The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.
Option Recompile is a Magic Turbo Button That Actually Works.
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […]
Transforming and Analyzing Data in PostgreSQL
In our data hungry world, knowing how to effectively load and transform data from various sources is […]
Get the most out of SQL Server Agent logs
If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on […]
Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]
Why Test-Driven Development? (Part 2)
The post Why Test-Driven Development? (Part 2) appeared first on SQLServerCentral.
SSRS 2022 Install, Setup and Configuration
The post SSRS 2022 Install, Setup and Configuration appeared first on SQLServerCentral.
Power BI Auto Detect Relationship Failure
In this article, we will talk about how to manually create a relationship by identifying the primary and […]
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […]
Writing your 2024 PASS Data Community Summit Submission
It is time again for the PASS Data Community Summit Call For Speakers. Some of you are […]
[Video] Office Hours From the Future
To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as […]
Serverless Authentication methods in web apps.
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional […]
Read This Before Your Users Install SSMS 20
SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: […]
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ...
The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first […]
The Value of Conference Speaking
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, […]
Evolving Role of Data Professionals in Artificial Intelligence Era
This image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative […]
Building MongoDB Aggregations
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Updated First Responder Kit and Consultant Toolkit for February 2024
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test […]
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL […]
Live webinar: How to excel at managing multiple database platforms
The use of multiple database platforms is on the rise, however, managing them can be challenging, with issues […]
A Few Best Practices for Strong SQL Server Security
Databases serve as the critical infrastructure for numerous applications. They safeguard essential data that fuels both business operations […]
Query Exercise: Finding Sister Locations to Help Each Other
For this week’s query exercise, let’s start with a brief query to get a quick preview of what […]
Find and Replace Text in Strings in T-SQL
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […]
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last […]
SQL Server Clustered Index Seek Operation Generates Poor Query Performance
The post SQL Server Clustered Index Seek Operation Generates Poor Query Performance appeared first on SQLServerCentral.
“As DBAs, should we be worried about our jobs because ...
The post “As DBAs, should we be worried about our jobs because of AI?” and other burning questions […]
Join Me in Orange County for Tuning Databases in One ...
You’ve got production databases in SQL Server or Azure SQL DB, and you want to make ’em faster. […]
Sessions You Should Attend at SQLBits Online 2024
SQLBits 2024 is next month, and the session agenda is out, including the Microsoft-led sessions. If you’re going […]
Add Additional Nodes to SQL Server 2022 and Windows Server ...
The post Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3 […]
Meet Claude, the new AI
Introduction to Claude This time we will meet Claude, a new AI technology. Previously, we talk about ChatGPT, […]