Finding Sister Locations to Help Each Other: Answers & Discussion
The post Finding Sister Locations to Help Each Other: Answers & Discussion appeared first on SQLServerCentral.
Archives de l’année : 2024
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, […]
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 […]
Fabric and Azure SQL in a few clicks: Mirroring a ...
Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for […]
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 […]
Cumulative Update #26 for SQL Server 2019 RTM
The 26th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
[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 […]
How to Use Any SQL Database With Rust
Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t […]
Azure OpenAI and RAG Security
The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […]
Your Teammates Need the Fundamentals.
You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. […]
SQL Server Plan Cache Bloat Performance Impacts
The post SQL Server Plan Cache Bloat Performance Impacts appeared first on SQLServerCentral.
Security Update for SQL Server 2022 RTM CU12
The Security Update for SQL Server 2022 RTM CU12 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM CU25
The Security Update for SQL Server 2019 RTM CU25 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM
The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download […]
Update: Security hotfixes released for ODBC and OLE DB drivers ...
We’ve released hotfix packages for the following drivers to address important security issues: Microsoft ODBC Driver 17.10.6 […]
Using ChatGPT for T-SQL Code Reviews
For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […]
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, ...
In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in […]
Giving Feedback on Microsoft Data Platform Tools
As a data professional, there is a set of tools that you use on pretty much a […]
Joining Queries in Azure Data Factory on Cosmos DB Sources
This article illustrates how to join two queries using ADF (Azure data factory). Prerequisites First, prepare your data […]
SQL Server Patching Using PowerShell DSC
Introduction In the previous article we have seen how to install SQL Server Management Studio (SSMS) using PowerShell […]
Introduction to Python including Installation, Jupyter Notebooks and Visual Studio ...
The post Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code appeared first on SQLServerCentral.
[Video] Office Hours: Just Three Questions
Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what […]
Released: SCOM Management Pack for Azure SQL Managed Instance (7.4.0.0)
An update to Azure SQL Managed Instance Management Pack is available (7.4.0.0). You can download the MP from […]
Dynamic Partitioning and a Simple Incremental Load
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) […]
Who’s Hiring in the Microsoft Data Platform Community? April 2024 ...
Is your company hiring for a database position as of April 2024? Do you wanna work with the […]
Use Fabric Data Factory to Load Data From a CSV ...
The post Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to […]
Building MongoDB Aggregations in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Announcing Fundamentals Week, May 6-10
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Provision Premium SSD v2 Storage for Microsoft SQL Server on ...
Guidance on choosing SQL Server storage options in Azure We’re excited to announce the public preview of the […]
Tomorrow’s the Big Day: Free Live Webcasts!
No fooling here. Tomorrow, I’m teaching my very favorite class live online, for free, two different ways – […]
Custom Statistics Distributions in SQL Server 2022
Statistics are important for the query processing engine in SQL Server to run efficiently. The type of execution […]
Choosing Between SSIS vs ADF: What You Need to Know
The post Choosing Between SSIS vs ADF: What You Need to Know appeared first on SQLServerCentral.
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are […]
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 […]