Meet the Summit 2023 Sponsors
The post Meet the Summit 2023 Sponsors appeared first on SQLServerCentral.
Sites anglophones
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.
PASS Data Community Summit – Early Bird price ends July ...
The post PASS Data Community Summit – Early Bird price ends July 26 appeared first on SQLServerCentral.
Optimizing Queries in MySQL: Optimizing Updates
In the previous parts of these MySQL optimization series, we’ve told you how queries work on a […]
[Video] Office Hours: SO MANY Good Questions
Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions […]
[Video] Office Hours: While Stack Overflow is Down
Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s […]
SQL ConstantCare® Population Report: Summer 2023
The short story for this quarter: SQL Server 2022 adoption rates have stalled, even backtracked, and it doesn’t […]
A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication
Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for […]
Free Azure Networking Training This Week
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re […]
Managing Test Data for Database Development
In coming up with a strategy for managing test data, first you need to understand what the […]
Power BI Data Gateway to Connect Data Sources in the ...
The post Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises appeared first on […]
Building a Database Dashboard with SSRS
A database dashboard is a graphical user interface (GUI) that summarizes the key performance indicators (KPIs) for a […]
Using Power BI to Analyze My Travels
As a data professional, I have some fun with data in my life. I like numbers, and I […]
Sample Use Case for Using SQLCMD Utility Batch Files
The post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral.
PostgreSQL 101: The journey towards PostgreSQL – tips and lessons ...
The post PostgreSQL 101: The journey towards PostgreSQL – tips and lessons from Grant Fritchey appeared first on […]
It’s Only Summer, but I am ready for PASS Data ...
The PASS Data Community Summit 2023 happens the week of November 12 in Seattle. WA. It will […]