Procure SQL’s Weekly Digest – January 31, 2024!
Newsletter
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…
Procure SQL’s Weekly Digest – January 24, 2024!
Newsletter
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…
Is external governance coming to SQL Server 2022?!?!
Features
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…
Procure SQL’s Weekly Digest – January 17, 2024!
Newsletter
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…
Procure SQL’s Weekly Digest – January 10, 2024!
Newsletter
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…
Query your Lakehouse in Fabric with SSMS
Data Architecture
This week, John asked, "Can you query data inside a lakehouse using SQL Server Management Studio?Yes, did you know you could query your data inside a Microsoft Fabric Lakehouse with SSMS (SQL Server Management Studio)? John didn't so Justin…
Procure SQL’s Weekly Digest – January 3rd, 2024!
Newsletter
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…
Finding Query Anti-Patterns in Your Developer’s Queries
Performance Tuning
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…