PerfMon: Using SQL Server Performance Counters
Learn how you can use Windows Performance Monitor and the PAL to gather metrics from your SQL Server instances.
2022-07-20
21,902 reads
windows
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
2020-09-03
19,547 reads
Updates to the Deployment Suite for Oracle
Redgate has added new capabilities to the Deployment Suite for Oracle, so it now supports automated migrations-based and state-based Oracle deployments on both Linux and Windows. They've introduced Redgate Change Control, a new capability for understanding development changes, generating migration scripts for version control, and getting precise control over the migration path during automated deployments. Our Schema Compare and Data Compare for Oracle command line tools have been extended to Linux as well as Windows, and we’ve added static code analysis that encourages teams to follow good coding practices on Windows or Linux.
2020-02-06
Blogs
Measuring and Improving SQL Server Query Plan Cache Efficiency
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
Communicate to the Individual
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
PESTLE Analysis for Databases Explained | Real-World Use Cases & Tool
By Rohit Garg
📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors...
Forums
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Getting the Updated Column List
Comments posted to this topic are about the item Getting the Updated Column List
SSRS: An error occurred during local report processing. The definition of ...
Here's the complete error: An error occurred during local report processing. The definition of...
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers