2024-06-17
10,804 reads
Microsoft SQL Server
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
2023-11-06
15,650 reads
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
2023-10-30
3,627 reads
Optimized Plan Forcing with Query Store in SQL Server 2022
In this Article , We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.
2023-09-04
4,630 reads
SQL Server Resumable Index Operations
The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.
2023-06-26
10,487 reads
How to Find the SQL Server Version
This article shows a number of ways in which you can find out the version of your instance.
2023-06-23
6,290 reads
2022-06-27
32,257 reads
Fixing "The Distributor has not been installed correctly" Error with AWS
When migrating a database from SQL Server on premises to AWS, you might receive this error. Learn how to get rid of it.
2022-06-17
5,829 reads
Running SQL Server on Oracle and Google Cloud
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
2022-02-18
7,001 reads
2021-10-08
2,193 reads
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
The Long Running Backup
Comments posted to this topic are about the item The Long Running Backup
Interview Tips
Comments posted to this topic are about the item Interview Tips
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers