SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are […]
Archives du mois : mars 2024
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
[Video] Office Hours: 25 Answers in 10 Minutes
It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento: Here’s what we […]
[Video] Office Hours: The Long One
You posted a lot of great questions at https://pollgab.com/room/brento and I spent almost an hour covering these: Here’s […]
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 […]
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 […]
Announcing the discontinuation of using DBCC CLONEDATABASE command in production ...
DBCC CLONEDATABASE command generates a schema-only copy of a database. Effective March 1, 2025, Microsoft will discontinue support […]
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 […]
Nouveau SSMS 20.0
Le nouveau SSMS (SQL Server Management Studio) version 20 est arrivé. Pas encore visible sur le site français, […]
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 […]
Expand the limits of innovation with Azure data
Over the past year, we have had a first-row seat to just how fast the introduction of new […]
[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 […]
Enabling Azure Key Vault for SQL Server on Linux
Enhancing Security with EKM using Azure Key Vault in SQL Server on Linux: We’re excited to announce […]
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 […]
Upcoming changes for SQL Server Management Studio (SSMS) – Part ...
Hey all! This is the final post in a series of three covering SQL Server Management Studio (SSMS), […]
SSMSInfoReports : nouvelle release v9.2
Encore une nouvelle version de mes rapports custom pour SQL Server Management Studio, la 9.2 ! Avec dans […]
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 […]
Networking errors when enabling SQL Server by Azure Arc
When onboarding your SQL Server instance to Azure Arc, there are some networking prerequisites that need to be […]
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 […]