Phil Factor on three "sanity checks" that any data scientist must perform in order to prevent businesses from interpreting data analysis errors, or fraudulent activity, as real trends.
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.
This article will show you the importance of Indexed Views and how they can help performance.
A picture can express a thousand words. That's a phrase that many of us understand well, and one we embrace when we try to present large amounts of data in reports and dashboards. This week Steve Jones asks you what visualizations you use.
This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.
I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database?
After a recent trip, Steve Jones noted a problem somewhere with the way airlines are handling passenger data.
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers