Vikas Guptavikasfeedingdotnet.hashnode.dev·Jun 3, 2024Streamline On-Prem SQL Server with Azure DevOps CI/CDIn today's fast-paced development environment, efficient and reliable deployment processes are crucial. In my latest video tutorial, I walk you through the steps to deploy database changes from a Visual Studio project to an on-premises SQL Server usi...Discuss·133 readsazure-devops
Bob Blackburnbobblackburn.com·Apr 16, 2024How to Avoid these 10 Pitfalls during an Oracle to SQL Server MigrationMy first IT project was a data conversion for Fashion Bug. Since then, I have been on many conversions both as an in-house developer and as a consultant. The last few conversions have been moving Oracle Databases to SQL Server. Here are 10 pitfall mi...DiscussSQL Server
Yichun Zhaoyichunzhao.hashnode.dev·Jan 9, 2024SQL SEVER: Counting Jason Array SizeAssuming your table is named error_log and the column containing the JSON string is error_data, and the JSON structure is like this: { "error_code": "some_code", "error_message": ["message1", "message2", ...] } Your SQL Server query would look li...DiscussSQL
Saruf Ratulsaruf.hashnode.dev·Aug 3, 2023Connecting your ASP.NET core application to a local instance of SQLServerIt is no news that one of the best databases to use for asp.net/.net development is SQL Server because of its smooth integration provided with .net(ASP.NET/UWP/Winforms/Xamarin) applications. Let's get to the process of integrating a local Instance o...Discussasp.net core