SQL Server vs Oracle Query Statistics to Improve Performance
The post SQL Server vs Oracle Query Statistics to Improve Performance appeared first on SQLServerCentral.
Sites anglophones
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 […]
[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 […]
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 […]
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 […]
Storing Credentials Securely on a Windows-based Flyway Installation
The post Storing Credentials Securely on a Windows-based Flyway Installation appeared first on SQLServerCentral.
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.
When Parameter Tuning is not the Answer
So much about parameters tuning, but does it always help? Welcome to the third and final blog […]
[Video] Office Hours: DBA & Developer Relationships
Y’all posted & upvoted questions at https://pollgab.com/room/brento, and we finished up the session talking about the relationships between […]
[Video] Office Hours: Lots of Good SQL Server Questions
At https://pollgab.com/room/brento, post the questions you’d like to get my opinion on, and I’ll take a break every […]
The difference between libraries and frameworks
The post The difference between libraries and frameworks appeared first on SQLServerCentral.
Supervise the use of Microsoft Fabric
Already one month since the official announcement of Microsoft Fabric and his public Preview: https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/ Since then, […]
Bard, Google’s ChatGPT Competitor
After ChatGPT, Google announced that they had Bard. Which is a nice AI chatbot that can also help […]
SQL Server Database Backup and Restore Failure Notifications
The post SQL Server Database Backup and Restore Failure Notifications appeared first on SQLServerCentral.
Six Things to Monitor with PostgreSQL
The post Six Things to Monitor with PostgreSQL appeared first on SQLServerCentral.
Searching Flyway Migration Files using Grep and Regex
The post Searching Flyway Migration Files using Grep and Regex appeared first on SQLServerCentral.
Unpivot Data Using Python
Problem Statement In one of the Business Analytics Dashboards Projects, Sales data is received from different countries (100 […]
[Video] How to Use ChatGPT to Write WordPress Blog Posts
Today’s live stream was a little different: I demonstrated using the Aiomatic WordPress plugin, ChatGPT, and Azure Open […]
[Video] Office Hours: As They Pour My Patio Concrete Edition
I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I […]
How to Reduce the Need for Bookmarks Using Parameters in ...
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in […]
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted ...
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of […]
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people […]
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you […]
Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
[Video] Office Hours: Professional Development & Training Questions
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a […]
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, ...
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on […]
Pipelining Configuration Information Securely to Flyway
The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.