If you are not happy with the results below please do another search
Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]
The post Query Store 101 appeared first on dbWonderKid.
What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]
Have you ever had a query that runs frequently start to randomly go slower? We all have and without the proper tools and knowledge, this can be hard to figure out because there can be so many different reasons. In this blog post, our goal is to make your query optimization in SQL Server a […]
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars! We are very proud of our team and their efforts to share knowledge and experiences. Be sure to say hello and ask questions when you see them! GroupBy September 7, 2018 We […]
Securing data access is paramount for organizations of any size. Nobody wants to be the following data security leak that goes viral. Adopting robust authentication methods that enhance security, streamline user experience, and simplify management is crucial for decision-makers. Today, I write about how you could utilize Microsoft Entra ID to improve your database security […]
In this post, we will cover a new feature in preview for Microsoft Fabric: Lakehouse Schemas. If your Lakehouse is drowning in a sea of unorganized data, this might just be the lifeline you’ve been looking for. The Data Chaos Conundrum We’ve all been there. You’re knee-deep in a project, desperately searching for that one […]
“Every business workflow in every enterprise will be engineered with GenAI at its core” -ServiceNow’s Bill McDermott Microsoft Build 2024 focused on transformative advancements in AI, cloud computing, and developer tools. This year’s event showcased Microsoft’s commitment to pushing the boundaries of what’s possible. AI and Copilots were the overwhelming theme. Even though AI has […]