SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works.
2021-12-03
Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.
2021-12-03
Redgate is a proud sponsor of this year’s Accelerate State of DevOps Report, by the DevOps Research and Assessment (DORA) team at Google Cloud. Watch our lastest webinar to find out how the future of DevOps will effect you.
2021-12-01
In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.
2021-12-01
Join this Microsoft hosted webinar to hear from Microsoft MVP and Redgate Advocate, Grant Fritchey to learn more about monitoring hybrid database environments, as part of their Azure Series.
2021-11-29
In this tip we'll introduce you to Power Query, the self-service data preparation tool from the Power BI family
2021-11-29
We really enjoyed the insightful, intelligent answers Troy gave to Steve Jones’s questions and invite you to enjoy the fascinating conversation in the webinar which is now available on-demand.
2021-11-26
In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.
2021-11-26
The Estate Configuration reports SQL Server configuration across all your servers, so you can quickly investigate ad-hoc or unauthorized changes to any settings that might affect their performance, stability, or security.
2021-11-24
In this article we look at how to create a basic Power App that allows saving data to a database table.
2021-11-24
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
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 have trouble in writing a SQL query. I have a data table with...
Hi all, I am currently having performance issues by populating one of my factless...
Hi Experts, I am getting the following error when i am trying to test...
Ask SSC