that's actually a setting in SSMS that you can toggle back and forth.
Assuming SSMS 2016, If you go to Tools>>Options>>SQL Server ObjectExplorer>>Scripting
You currently have a checkmark for...

kudos to you sir, nice job. playing with xquery and xml takes a bit of work!
I made some trivial changes to the query for the dataset, in order to...

Chandan you would probably get better, more specific help if you...

i think that resetting the database user(s) to match the login is the backwards way to do it; you have to re-do it with every restore.

i prefer to...

Anyone here who is a Chapter Leader or Volunteer for your local SQL User Group, I'm just taking over the South Florida SQL server User Group, and if you have...

I'm never surprised when this happens; 
seven months ago, a sharp reader noticed a copy paste of one of mine: i don't care personally, it wasn't rocket science to script...

Only Visual Studio Professional can connect with TFS; so the SSDT or Community Versions cannot use TFS. I've had to go through that issue at my job, everyone had SSDT,...

touching the data via a linked server, in itself, does not violate the license agreement.
 it depends on what the developer is DOING with the data.

populating dev with...

after you install, then you probably need to do the following:
run the SQL configuration tool and enable TCP IP
enable remote connections on the instance
Add Logins to your...

SQLLocalDB is a special version of an MDF for SQL, it does not allow remote connections, and only one person can open the file at a time.

if you...

you cannot, under any circumstances, change the value in SQL from UNSAFE to anything else.
you can remove and redesign features in your SQL CLR to NOT use unsafe methods,...

if you need old vs new and also whodunnit information, a trigger it the way to go.

if you need old vs new, but not whodunnit, Change Data Tracking...