Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
Mercedes has taken advantage of containers and Kubernetes to build knowledge in their staff. This investment helps them adapt and change their technology to meet the needs of the business.
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
Learn how to create a table in SQL Server using T-SQL along with several different examples that build upon each other to create the final table.
A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
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.
In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.
Today Steve talks about retrospectives and how we learn and grow as software professionals.
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I’ve added a new parameter to my permissions scripts (well, just the main two...
Comments posted to this topic are about the item The Case for Patching
Is it possible to purge the Extended Events file's (target) contents WITHOUT deleting the...
I am creating a function that should retrieve a numerical value from notes. This...
Ask SSC