If you are not happy with the results below please do another search
SQL Server Azure walk-through and basics Cloud migrations can be tough. The last thing you want to do is overspend and negatively impact your users. First, If you would like some help or to talk with us to bounce some ideas we would love to chat with you. Below are several resources our clients find […]
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster. Microsoft’s marketing team even jumped on to help coin the phrase, “SQL Server It Just Runs Faster.” With SQL Server 2017, this started to get […]
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 […]
We are back this year! Not only are we sponsoring SQL Saturday Houston, we are also speaking! All three of us are presenting! Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business […]
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends. My talk was on Automating the Pain Away with Query Store and Automated Tuning. I hope this session helped people understand Query Store and Automated Tuning as […]
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 […]
Hello, Everyone; this is John Sterrett from Procure SQL. Today, we will discuss how you can validate SQL Server Backups with a single line of PowerShell. Due to the recent global IT outage, I thought this would be an excellent time to focus on the last line of defense—your database backups. I have good news […]
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 […]
With SQL Server 2017 Microsoft improved the journey towards making your code go faster without any code changes required by your developers. SQL Server 2019 gives you more of this super cool black magic. Today, we are going to show you the details of why scalar functions executions are changing and how you can make […]