Comments for SQL Studies https://sqlstudies.com  Live, Learn, Share Mon, 23 Feb 2026 09:12:27 +0000 hourly 1 http://wordpress.com/ Comment on Moving to Azure: A change in processes – TSQL Tuesday 103 by Vaibhav https://sqlstudies.com/2018/06/12/moving-to-azure-a-change-in-processes-tsql-tuesday-103/comment-page-1/#comment-85232 Mon, 23 Feb 2026 09:12:27 +0000 http://sqlstudies.com/?p=5612#comment-85232 This is a thoughtful and practical discussion on how moving to Azure SQL changes not just where you host your databases, but how you approach development, deployment, and operations. I appreciate how you highlight that the shift to cloud platforms like Azure requires changes in processes, tooling, and mindset — especially around automation, CI/CD, and performance tuning.

Clinical Research Training in Pune

]]>
Comment on Moving to Azure: A change in processes – TSQL Tuesday 103 by UPSKILLGENERATIVEAI https://sqlstudies.com/2018/06/12/moving-to-azure-a-change-in-processes-tsql-tuesday-103/comment-page-1/#comment-85224 Tue, 20 Jan 2026 04:58:36 +0000 http://sqlstudies.com/?p=5612#comment-85224 <!-- /wp:paragraph --></blockquote> <!-- /wp:quote --> <!-- wp:paragraph --> <a href="https://upskillgenerativeai.com/" rel="nofollow ugc">generative ai training in hyderabad</a> <!-- /wp:paragraph -->]]>

Great post! It really captures an important but often overlooked aspect of cloud adoption — how moving to Azure isn’t just a technical migration but also a shift in how teams operate and think. I’ve seen firsthand how Azure SQL Database and Managed Instances bring advantages in scalability and management, but they also require changes in provisioning, governance, and communication across teams. Your point about repeatedly reviewing and refining processes to adapt to new paradigms really resonates — success in the cloud is as much about process maturity as it is about technology. Thanks for sharing these insights! 👍

generative ai training in hyderabad

]]>
Comment on A temper, soft skills, and almost losing a job : T-SQL Tuesday #170 by Filip https://sqlstudies.com/2024/01/09/a-temper-soft-skills-and-almost-losing-a-job-t-sql-tuesday-170/comment-page-1/#comment-85222 Fri, 17 Oct 2025 07:16:10 +0000 http://sqlstudies.com/?p=9363#comment-85222 Ahhh yes, with great power comes poor soft skills.

It’s okay man we learn from our mistakes, soft skills are commonly ignored by the IT community because we’re used to working with like minded people, and let’s face it, we can be really weird sometimes, almost alien to people outside of our world.

]]>
Comment on What is the system_health extended events session? by candyco https://sqlstudies.com/2017/07/05/what-is-the-system_health-extended-events-session/comment-page-1/#comment-85220 Mon, 11 Aug 2025 13:06:25 +0000 http://sqlstudies.com/?p=4683#comment-85220 How do you typically structure your queries to extract only the most critical events from the XML data efficiently? ijm

]]>
Comment on Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions. by Kenneth Fisher https://sqlstudies.com/2025/07/14/copying-an-azure-sql-database-between-two-azure-sql-instances-in-two-different-subscriptions/comment-page-1/#comment-85216 Mon, 04 Aug 2025 14:30:40 +0000 http://sqlstudies.com/?p=9372#comment-85216 ]]> In reply to JD.

Assuming there is room why not copy it exactly and then modify? Virtually everything can be changed 😁

]]>
Comment on Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions. by JD https://sqlstudies.com/2025/07/14/copying-an-azure-sql-database-between-two-azure-sql-instances-in-two-different-subscriptions/comment-page-1/#comment-85215 Sat, 19 Jul 2025 18:23:15 +0000 http://sqlstudies.com/?p=9372#comment-85215 This works great when you want both copies to have the same configuration (DTUs or vCores). However I was unable to make it work if I wanted to have the copy “downsized”. For example, we wanted to copy a Prod database to a Dev or Test database, but didn’t want it to have the same higher performance configuration. I tried many things to get that to work, and beyond doing row-by-row copying, which is too slow, I could not get it work.

]]>
Comment on Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions. by Copying Azure SQL Databases between Subscriptions – Curated SQL https://sqlstudies.com/2025/07/14/copying-an-azure-sql-database-between-two-azure-sql-instances-in-two-different-subscriptions/comment-page-1/#comment-85214 Tue, 15 Jul 2025 12:05:11 +0000 http://sqlstudies.com/?p=9372#comment-85214 […] Kenneth Fisher is back in the fight: […]

]]>
Comment on #PowershellBasics: Using environment variables ($env:ProgramFiles) by George Simos https://sqlstudies.com/2020/04/06/powershellbasics-using-environment-variables-envprogramfiles/comment-page-1/#comment-85210 Mon, 02 Jun 2025 15:57:16 +0000 http://sqlstudies.com/?p=7201#comment-85210 For the env:ProgramFiles(x86) environment variable of PowerShell to work, you need to declare it as such in a variable:

$folderPath=”${Env:ProgramFiles(x86)}JustAFolder”

Note the dollar sign and the enclosing in curly brackets of the environment variable.

If you do this: $folderPath=”$Env:ProgramFiles(x86)JustAFolder” and type the variable $folderPath followed by enter, you will see the correct path, but when trying to do anything with it as a simple Get-ChildItem action, it will throw an error that ‘C:Program Files(x86)’ doesn’t exist.

Hope this helps.

]]>
Comment on Why you shouldn’t use SELECT * by Avoiding "SELECT *" in Production Queries - Rishan Solutions https://sqlstudies.com/2016/03/28/why-you-shouldnt-use-select/comment-page-1/#comment-85191 Tue, 29 Apr 2025 06:25:06 +0000 http://sqlstudies.com/?p=3448#comment-85191 […] Using SELECT * retrieves all columns from a table, regardless of whether all are needed. This can lead to: (Why you shouldn’t use SELECT * | SQL Studies) […]

]]>
Comment on Data jokes by Mr Iqbal https://sqlstudies.com/2021/11/23/data-jokes/comment-page-1/#comment-85188 Fri, 28 Feb 2025 13:23:31 +0000 http://sqlstudies.com/?p=8510#comment-85188 what type of tea protects your data the best? Securi-tea

]]>