The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
Decouple the Tools
The decoupling of some tools from SQL Server seems to be working. Perhaps Microsoft should decouple them all.
Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
Quality-Driven Software Development
While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle.
Scripting Environments in SSIS
Demo and script on how to script out SSIS Environments and their associated variables
SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python
Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.
Elevation of Privileges
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?
Staying Current on Power BI Dashboards
Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Menara Palma Telpon/WA:08137887595
BCA KCP Menara Palma Telpon/WA:08137887595.Ariobimo Sentral, Gedung Menara Palma, Jl. Hr. Rasuna Said Ground...
BCA KCU MUARA KARANG Tlpn/Wa 0853.7373.7551
Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
BCA Finance WTC Mangga Dua Tlpn/Wa 0853.7373.7551
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers