Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to […]
Archives du mois : juillet 2023
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.
Released: Microsoft.Data.SqlClient 5.2 Preview 3
Microsoft.Data.SqlClient 5.2 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
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 […]
Cumulative Update #6 for SQL Server 2022 RTM
The 6th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
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 […]
[Video] Office Hours: 30 Minutes of Rapid-Fire (And a Little ...
Almost all of today’s questions from https://pollgab.com/room/brento were great! Well, except two. Here’s what we covered: 00:00 Start […]
Free Azure Networking Training This Month!
Raise your hand if you’ve ever blamed the network. You’re responsible for the health, security, and uptime of […]
What Counts for a DBA – Discretion
I was looking at the list of topics I have talked about in my “What Counts for […]
PASS Data Community Summit
The post PASS Data Community Summit appeared first on SQLServerCentral.
Let Your Data Do the Talking with PowerPoint Plus Power ...
What is this about This article will be about Power BI and PowerPoint collaborating. Both tools are well-known […]
FOR XML PATH Changed The Way I Think About T-SQL ...
The first time I saw FOR XML PATH being used to generate a comma-delimited list, I think I […]
The GROUP BY Clause
When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly […]
Released: SCOM Management Packs for SQL Server, RS, AS (7.2.0.0)
Updates to SQL Server, SQL Server Dashboards, Reporting Services, and Analysis Services Management Packs are available (7.2.0.0). You […]
Influencing Successful Cloud Transformational Change
The post Influencing Successful Cloud Transformational Change appeared first on SQLServerCentral.
Enterprises that adopt Database DevOps save an average of $4.3M ...
The post Enterprises that adopt Database DevOps save an average of $4.3M per year (Video) appeared first on […]
Get the Most Current Row From a Detail Table
Task: Update a table with the most current value of a detail table. In this article I’m using […]
N'oubliez pas les correctifs
On ne le dira jamais assez, il faut installer les correctifs sur vos instances SQL Server. Microsoft a […]
Simple-Talk RSS Feeds
Recently, we have made a few changes to the simple-talk.com website’s RSS feeds that I am pretty […]
Creating an Azure SQL Database Using Azure Cloud Shell
Introduction Azure Cloud Shell is a browser-based tool that allows the creation, configuration, and management of Azure resources […]
Starter Metadata T-SQL Query Examples for Databases and Tables
The post Starter Metadata T-SQL Query Examples for Databases and Tables appeared first on SQLServerCentral.
Storing Credentials Securely on a Windows-based Flyway Installation
The post Storing Credentials Securely on a Windows-based Flyway Installation appeared first on SQLServerCentral.
Meetup du Club Power BI, Hors-Série spécial Microsoft Fabric
Le 4 juillet 2023, le Club Power BI a organisé un nouveau Meetup titré « Hors-Série spécial Microsoft […]