DMV Comparison for SQL Server 2019 vs Azure SQL Database
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
2025-06-02
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
2025-06-02
Learn how you can conduct a sentiment analysis on data loaded into an Excel spreadsheet.
2025-05-30
1,371 reads
What advice would you give to someone new to Power BI? What are common Power BI mistakes to avoid? In this article, we will discuss several Power BI mistakes to avoid to help you navigate this powerful tool effectively.
2025-05-30
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article
2025-05-28
Learn how you can use Power BI to forecase the future trends of data.
2025-05-26 (first published: 2023-02-27)
51,444 reads
What are some of the most common mistakes when working with Power BI? For example, when a junior colleague starts on a Power BI project for the first time, what are the pitfalls you try to warn them about? What advice would you give them?
2025-05-26
This article examines how tempdb is affected by recursive queries, using a few different methods.
2025-05-23
2,444 reads
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
2025-05-23
The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.
2025-05-21
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
2025-05-19
5,920 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers