Here are some videos, tips, and exciting links the Procure SQL team would like to share! MLB’s Databases Have you ever wondered about what MLB teams name their databases? We like “the fish bag,” “ground control,” and “MITT.” What is your favorite one? Cloud Failures Most cloud failures are traced back to human mistakes. Have […]
Here are some videos, tips, and exciting links the Procure SQL team would like to share! Xbox and SQL Server Learn how Xbox reduced patching downtime significantly in their SQL Server environment. Fabric Common Tasks with Python Are you building complex fabric orchestrations in Python? Microsoft Spark Utilities can be your best friend. It’s like […]
Here are some videos, tips, and interesting links we have viewed at Procure SQL. Comparing NULLS Struggling to compare many columns that contain null values? Here is a great way to do so before SQL 2022; here is a newer way with SQL Server 2022. Azure SQL Database Limiting Resources Like life with Azure SQL […]
Every so often, when a new cumulative update (CU) comes out for SQL Server, I like to see what system objects are new and which ones have changed. With the cumulative SQL Server 2022 update eleven this month, I noticed some exciting views not documented in the release notes. I figured I would blog about […]
Hopefully, everyone is back into the swing of things as we are in the middle of week three of 2024! Here are some videos, tips, and interesting links we have viewed at Procure SQL. The Feature That Should Have Been Scrapped If you take anything away from reading this newsletter, please make sure you don’t […]
Hopefully, everyone is back into the swing of things as we are in the middle of week two of 2024! Here are some videos, tips, and interesting links we have viewed at Procure SQL. Free Government Data Russ Loski helps us understand why data that has changed in 2023 might relate to data you do […]
Happy New Year! We hope everyone had a happy holiday season. Here are some videos, tips and links we found interesting at Procure SQL. Developer’s Still Love Free Stuff! Stack overflow’s 2023 survey shows that developers like free databases. Maybe this is why Microsoft made a Free version of Azure Managed Instances? Why are SQL […]
In the beginning of my IT career, I was a developer. I wrote a lot of bad code that didn’t perform well. As more data entered my tables my stored procedures got slower and slower. More data, more problems! I started my career in performance tuning by making my crappy code a little less crappy. […]
Austin Texas SQL Saturday was a success! Procure SQL would not exist if it wasn’t for #SQLFamily and the SQL Community. Therefore, we always want to help connect, share and learn with our local data community. In 2010 I hosted my first SQL Saturday #36 in Wheeling, WV. One thing in common with my first […]
SQL Saturday Austin is coming to Austin Texas. That’s right, you heard it here first! Free SQL Server training in Austin, TX! SQL Saturday Austin is Feb 24th and 25 We hope you had a great holiday season. With the new year everyone made goals and resolutions. Are you looking to take your IT career […]