PySpark Secrets to use with Fabric
PySpark is a powerful language for data manipulation and it’s full of tricks. Let’s discover some of […]
Archives du mois : avril 2024
Join Me at the PASS Data Community Summit in November!
On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and […]
Updating Documents in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Learning Spark SQL String Functions with Explanations and Code Examples
The post Learning Spark SQL String Functions with Explanations and Code Examples appeared first on SQLServerCentral.
Exporting and Importing Registered Servers in SSMS
Many SQL Server Management Studio (SSMS) users connect to the same SQL Server instances over and over. In […]
Database technology learning resources
Before I started as the editor of Simple Talk, I worked on SQL Server. Only. (Ok, I […]
Building RESTful APIs in Rust With Actix and Diesel
There are many packages and tools that you can use to facilitate your API development with Rust. […]
What happens when we drop a column on a SQL ...
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […]
Why migrate Windows Server and SQL Server to Azure: ROI, ...
Hey everyone! We’ve been on the road the last couple of weeks at MVP Summit, SQLBits and Fabric […]
[Video] Database Answers in Hong Kong
As my time in Hong Kong came to an end, I sat inside on a foggy morning and […]
Working with IAsyncEnumerable in C#
IAsyncEnumerable is a powerful interface introduced in C# 8.0 that allows you to work with sequences of […]
Troubleshooting Mysterious Blocking Caused By sp_getapplock
I’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. […]
It’s almost time for Fundamentals Week! Have you signed up ...
The Monday after next, I’ll be getting together with dozens of smart people who are a lot like […]
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – […]
Unlocking Power with Updatable Views in SQL Server
Relational database management systems (RDBMS) rely on Structured Query Language (SQL) as their foundation for data management and […]
Kubernetes For Complete Beginners
The post Kubernetes For Complete Beginners appeared first on SQLServerCentral.
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 […]
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 […]
[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 […]
Database Subsetting and Data Extraction
Let’s start by defining a subset and why you would require a data subset? When dealing with […]
Exploration Experience: Saving and Creating Datasets
I have been talking about Data Exploration in Power BI on many of my sessions, specially the […]
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 […]
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. […]
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 […]
Announcing GA of enhanced patching for SQL Server on Azure ...
We are pleased to announce the GA release of enhanced patching capabilities for SQL Server on Azure VMs […]
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 […]
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, […]
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) […]