Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.
APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]
We now know when the next version of SQL Server is coming. At Ignite last week, Microsoft announced SQL Server 2022, which comes nearly 3 years after the last version, SQL Server 2019. Apparently, the pandemic's effects include delays in product development as it's been nearly three years since SQL Server 2019. The new version […]
Database professionals are spending 1/3 of their time on security tasks each day and say it’s their biggest professional challenge this year. Learn how 2500+ database professionals are reacting to these unprecedented demands in our third database monitoring insights report.
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.
Microsoft announced the release of the next version of SQL Server, 2022. There's a bunch of new enhancements that we can all get excited about. I can't wait to test the "Parameter Sensitive Plan" optimization myself. We can look forward to seeing this stuff in action, and in detail, at the PASS Data Community Summit […]
AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce and creating and […]
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I'm running a group MSA for the database engine and SQL Agent in a...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers