Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2025-10-06
9,390 reads
MSSQL administration
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.
2023-07-21
4,566 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,254 reads
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,815 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,214 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers