Recently a customer was asking for a way to alert on job steps that failed, but the job succeeded. They really wanted a custom metric for SQL Monitor, which I submitted, but this post looks at the query in general, trying to determine if a job step failed. Note: Let me start by noting that […]
This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]
Is your company a tech company? Steve Jones looks at the world from the perspective of software development and how that impacts business.
Well-formatted scripts are always easier to maintain and enhance readability to high degree. Formatting standards are an important part of coding standards anywhere and if not, they need to be. If there are a large number of scripts this can add up to a significant amount of time needed to maintain them. It is also […]
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
Get started with running Flyway migrations on SQLite databases, using PowerShell.
Today we have a guest editorial that asks how one might want to manage all those logging metrics produced by applications.
Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.
By Steve Jones
Data Masker for SQL Server is a great tool ensuring the data you use...
I find myself doing more and more work with containers. Yet, I also find...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi all, My understanding about the structure of data within SQL Server is that...
Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...
Good Morning, I have read that taking a log backup truncates the log file....
Ask SSC