PASS Data Community Summit 2023 – Sessions are available to ...
The post PASS Data Community Summit 2023 – Sessions are available to view! appeared first on SQLServerCentral.
Sites anglophones
The PASS Summit Lineup Is Out and Registration is Open!
This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year […]
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […]
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Bing vs Bard (Chatbot wars)
Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies […]
Managing the challenge of migrating to the cloud
The post Managing the challenge of migrating to the cloud appeared first on SQLServerCentral.
Dive into RDS Custom for SQL Server – Leverage your ...
The post Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability appeared […]
Database Concurrency in PostgreSQL
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […]
How Would You Design This: Tracking Travels
One of the challenges for many database developers is coming up with a good design that not only […]
Data Transfer from Azure Blob Storage to Snowflake Using Pipelines
The post Data Transfer from Azure Blob Storage to Snowflake Using Pipelines appeared first on SQLServerCentral.
PostgreSQL 101: The ten PostgreSQL extensions you need to know ...
The post PostgreSQL 101: The ten PostgreSQL extensions you need to know about appeared first on SQLServerCentral.
Going to a conference where hardly anybody knows my name
On Friday and Saturday August 11 and 12, I am going to do something I haven’t done […]
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel. Here’s […]
[Video] Office Hours: Extended Answers Edition
Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what […]
Meet the Summit 2023 Sponsors
The post Meet the Summit 2023 Sponsors appeared first on SQLServerCentral.
Upserts in Amazon Redshift
Amazon Redshift was first announced in 2012 as a new cloud-based analytical data warehousing service. Since then, it […]
Standard Sponsor Rates End August 30!
The post Standard Sponsor Rates End August 30! appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 4: Using GTID-based ...
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s […]
T-SQL Tuesday #165 – My Experience with Database Job Titles
They mean very little. More on that after nothing that this is part of T-SQL Tuesday, and […]
Analyzing Prices of SQL Server Books, New & Used
While on a road trip, Richie stopped by a used bookstore (or would that be used book store?) […]
The Curious Case of… recovering from a ransomware attack
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
What Is an Execution Plan and How to Find It ...
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […]
Combine DATE and TIME to DATETIME2 in SQL Server
tl;dr In the following code, « DateValue » and « TimeValue » can be replaced by either variables or columns of the […]
Using Power Query to Combine Data from Multiple Sheets in ...
The post Using Power Query to Combine Data from Multiple Sheets in Excel appeared first on SQLServerCentral.
7 Essential Factors for a Successful Cloud Migration: A Non-Technical ...
The post 7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide appeared first on SQLServerCentral.
Building REST APIs in Go with Mux and GORM
In modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs […]
How to List First or Last n% Records Using NTILE() ...
The post How to List First or Last n% Records Using NTILE() in SQL Server appeared first on […]
AutomatedLab – A Quickstart for Deploying SQL Server Labs on ...
Developers require convenient and separate spaces for testing and development. They can utilize various tools, such as PowerShell, […]
[Video] Office Hours While the Pool Refills
I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
[Video] Office Hours: Stump Me With Your Data Questions
There are only a couple weeks left in this summer’s marathon of Office Hours sessions, which means there’s […]
Create Your First Pipeline in Microsoft Fabric
Introduction Microsoft Fabric is an end-to-end analytics solution that includes data lakes, data integration, data engineering, data science, […]
Who’s Hiring in the Microsoft Data Platform Community? August 2023 ...
Is your company hiring for a database position as of August 2023? Do you wanna work with the […]
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to […]
Installing SQL Server Integration Services
The post Installing SQL Server Integration Services appeared first on SQLServerCentral.
How to Change the SQL Server Database Owner
In SQL Server, each database has an associated owner, which is a principal that has certain permissions and […]
Unmasking SQL Server Dynamic Data Masking, Part 5, Mitigations and ...
This is the fifth and final part of this series on SQL Server Dynamic Data Masking. The […]
The Hidden Impact of Microsoft Defender for Azure SQL
Recently, we received a call from a customer who was experiencing timeouts on multiple SQL Server instances. We […]
Best Practices for Google Cloud Security
The post Best Practices for Google Cloud Security appeared first on SQLServerCentral.
Exporting data from a MySQL database using SELECT…INTO OUTFILE
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all of the […]
[Video] Office Hours: Overheating Cadillac Edition
I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic. Here’s […]
[Video] Office Hours: Azure SQL DB & SQL Server Questions
Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you’d like to […]
PASS Data Community Summit 2023
The post PASS Data Community Summit 2023 appeared first on SQLServerCentral.
What is OneLake in Microsoft Fabric?
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its […]
Querying PostgreSQL: Learning PostgreSQL with Grant
Writing queries to retrieve the data from a database is probably the single most common task when […]
Finishing Up Your Free Azure Networking Training
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re […]
A Overview of Amazon Redshift
Introduction In the world of big data analytics and data warehousing, Amazon Redshift has emerged as a powerful […]
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
The post DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections appeared first on SQLServerCentral.
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance […]
SQL Server vs Oracle Query Statistics to Improve Performance
The post SQL Server vs Oracle Query Statistics to Improve Performance appeared first on SQLServerCentral.