Trusting STRING_SPLIT() order in Azure SQL Database
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
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
Here's your one-stop-shop for Flyway learning resources, curated by Tony Davis. Check out this handy learning pathway for managing and automating database deployments, from version control, using Flyway.
2021-11-22
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers