Enable Source Control in SSMS

Edit this file as administrator. Ref the correct path. I am using SSMS 17.8.1. or latest. C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ssms.pkgundef Uncomment the following block and save. Relaunch SSMS, Tools, Options, Source Control, Plug-in Selection, VSTFS. You should see a Team menu at the top Menu bar. Must have VS2015 installed! https://docs.microsoft.com/en-us/visualstudio/releasenotes/vs2015-version-history Troubleshooting info: Exit… Continue reading Enable Source Control in SSMS

2 New Things in SSMS 17.2 – I Think You’ll Like.

QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats. Performance Dashboard server report now available as a default report: Can connect to SQL Server 2008 and newer versions. Missing indexes sub-report uses scoring to assist in identifying most useful indexes. Historical wait stats sub-report now aggregates waits by category. Idle and… Continue reading 2 New Things in SSMS 17.2 – I Think You’ll Like.

SQL Sync Logins – Domain Accounts

Hypothetically, say you can't grant dbo permissions. Instead you just need read, write and execute for stored procedures. Common Database-Level Roles are: db_datareader, db_datawriter, and my personal favorite db_executor. Ideally, you would use a domain security group (making the accounts members of the group) and grant the group access to the SQL Server instead of… Continue reading SQL Sync Logins – Domain Accounts

SQL Server Error – Incorrect time syntax in time string used with WAITFOR.

This is a simple one but it doesn't stick until you write/read about it.  Note, I use WAITFOR DELAY to pause/sleep the session between batches or T-SQL commands. For logic reasons, sometimes, I just gotta buy myself a few seconds for one thing to finish, before I start the next one. Ref: Control-of-Flow (lots of goodies… Continue reading SQL Server Error – Incorrect time syntax in time string used with WAITFOR.