Add Default Constraint for Table Column
For Existing Table For New Table Definition
SQL GoTo
Using GOTO instead sql query statement.
Restore Database From Backup File
Simple restore database to same server on same disk configuration.
SQL Server Management Studio (SSMS) Keyboard Shortcut
Key Action F5 Execute Ctrl + F Find Ctrl + H Find and Replace Ctrl + F4 Close Query Crtl + K + C Comment Crtl + K + U Uncomment Crtl + Shift + V Cycle Through Clipboard
Switch SQL Server Edition
Open up the new SQL Server installation -> Maintenance -> Edition Upgrade SQL Server 2019 Standard Edition -> SQL Server 2019 Developer Edition Not supported. Have to uninstall SQL Server 2019 Standard Edition and then reinstall SQL Server Developer Edition. Rule “SQL Server 2019 edition upgrade” failed. The selected SQL Server instance does not meet... » read more
Readable Secondary Setup For Always On Among Different Editions
There are many limitations to Always On for Standard Edition, and they are all documented here. Basically, you get to use a single availability database with a single secondary replica, with no read access on the secondary replica. Issue: Unable to setup readable secondary databases on SQL Server 2019 Standard Edition Fix: Upgrade from Standard... » read more
SSIS package deployment SSMS 17 Version Discrepancy Issue
Issue: For some reason, unknown to many in the google-verse, trying to deploy the ipsac file using SSMS 17 causes there to be a version discrepancy with the script tasks (e.g. – “version 15 is not supported in this version of SSIS, etc.). Two primary options are deploying directly from Visual Studio (I used VS... » read more
Using XP_CMDSHELL to create file and send email as attachment
Note: The account using to run this job will need read/write access to the folder.
Repair/Restore Option for Database in Suspect Mode
If a database is in Suspect Mode… Try to bring the database back online. If that does not work, try to repair the database with data loss. If that does not work, you have to restore the database from a backup file.