Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
2,072 reads
Microsoft SQL Server
Database Ledger in SQL Server 2022
Learn how ledger databases and ledger tables work in SQL Server 2022.
2025-10-20
18,315 reads
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, I've often encountered situations where a single, poorly written query or a resource-intensive application threatened to cripple the entire database server. Performance bottlenecks, unexpected slowdowns, and user complaints become the norm, making your life as a DBA […]
2025-07-24
1,755 reads
How to process images and analyze charts with AI
See how ChatGPT can get data from images and conduct analysis on the data.
2025-06-16
2,258 reads
2024-06-17
17,103 reads
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
20,826 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
4,840 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
5,591 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
13,475 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
7,687 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers
