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 […]