How to search all objects in all databases with specific word phrase in SQL Server
When migrating SQL databases to new server, one of the challenge is to identify all the hard-coded references to old servers or services. Here is
MS SQL Server
Find missing indices using dynamic management views in SQL Server
For SQL Server performance tuning, besides rebuild index and update statistics, often we also need to identify missing indexes. This can be done from SQL
Download all RDL report files from SSRS server
Following code has been tested on SSRS 2010 to 2016
1. Install the Reporting Service Powershell Module
Install-Module -Name ReportingServicesTools
2. Code to download RDLs
Cascade Delete in MS SQL Server
Different from ORACLE and MySQL, MS SQL Server does not provide Cascade delete function natively. This maybe considered as a safety feature to prevent unintentional