Database and Disk Size - PowerShell Script
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
5,958 reads
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
5,958 reads
The below script is used to find the disk size for a set of servers,
## Script to Find List of...
2012-08-14
1,986 reads
Today I came accross white paper "Troubleshooting Performance Problems in SQL Server" by Sunil Agarwal, Boris Baryshnikov, Tom Davidson, Keith...
2012-08-14
1,226 reads
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,883 reads
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,074 reads
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,225 reads
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,525 reads
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,484 reads
Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...
2012-08-06
5,617 reads
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,419 reads
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
hello, i am trying to find where SSRS edition and product key information...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );See possible answers