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
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers