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 […]
Archives de l’année : 2023
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, […]
ODBC Driver 18.3 for SQL Server Released
Version 18.3 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.3 brings some improvements […]
JDBC Driver 12.4 for SQL Server Released
Version 12.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.4.0 brings several added […]
[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.
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 […]