Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
Introduction to Testing a Flyway Development
How to use Flyway Teams to run basic tests whenever it successfully executes a migration, checking that all the business processes supported by our database always produce the expected results.
Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.
How to Visualize Python Charts in Power BI
This article will show how you can code in Python and produce a chart for Power BI.
Reducing Debt and Increasing Security
DevOps is often thought of as bringing more features to customers, but it can also help security.
Metrics that matter for IT organizations on an agile journey
Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.
Re-baselining a Database using Flyway Desktop
Over time, Flyway projects can accumulate a lot of migration scripts, with many database objects being created, altered, and dropped across many files. Tonie Huizer explains why you might want to create a new baseline migration file to create the latest version of a Flyway-managed database in a single leap, and how to persuade Flyway Desktop to do it.
SQL Standard Confusion
The whole universe, the well-guarded people—may they all query databases together in a single language!
Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
DevOps is Mostly About People
Steve says the secret to DevOps is teamwork, which means that people matter. The tools help, but the humans determine the success level.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers