Tips, Tricks, Bugs and Stuff
Need to have a place for Tips, Tricks and weird buggy stuff that happens in SQL Server from time to time...
Dark Theme for SSMS |
|
Hack to enable Dark Theme for SSMS.
My eyes get tired of all the light themes. Its really easy to do. Follow the instructions in the link below.
https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/
My eyes get tired of all the light themes. Its really easy to do. Follow the instructions in the link below.
https://www.sqlshack.com/setting-up-the-dark-theme-in-sql-server-management-studio/
A Quirk in SQLCMD and Quoted_Identifiers |
|
I had a customer who was applying a bunch of sql scripts to a database for an upgrade process. These scripts were alters to stored procedures. So some scripts would be applied with Quoted_Identifiers ON and then some scripts would be Quoted_Identifiers OFF. The scripts did not explicitly set this connection setting. I am no SQLCMD ninja and I don't know how I missed this. The box was SQL 2014. There is a -I switch to enable Quoted_Identifiers ON. Added that to his script and bamm!!! all good.
https://sqlsailor.com/2014/11/14/sqlcmdoptions/
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
https://sqlsailor.com/2014/11/14/sqlcmdoptions/
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017