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.
A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.
As I think about heading into the fall conference season (and seeing so many familiar faces!!), I realize that I'm going to be asking myself a set of familiar questions. Who am I? What skills do I need to improve on in the coming year? Who do I look up to in the community and […]
In this article, I will describe how to export and import SSISDB using SSIS Catalog Migration Wizard in just a few clicks.
Steve takes a moment to think ahead to the PASS Data Community Summit 2023 and what he's looking forward to at the event.
In this article, learn how to implement drill-through in Power BI reports using the new user interface.
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases.
This was a provocative title: 6 ITOps Skills That Will Never Be Automated. In a time when AI use is growing quickly and many people fear for their jobs, it's nice to see someone writing about areas that AI will struggle to handle. Ironically, lots of these articles are written by writers without much technical […]
I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. However, I regard Chat-GPT as an indiscriminate conveyor of existing information, not artificial intelligence.
See how well the Bard AI does with moving data into SQL Server.
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers