Ubuntu Basics

New apt vs apt-get https://itsfoss.com/apt-vs-apt-get-difference/ apt-get update downloads the package lists from the repositories and “updates” them to get information on the newest versions of packages and their dependencies. apt-get upgrade will fetch new versions of packages existing on the

DBA Basics Part 1

Shrink Database DBCC SHRINKDATABASE (UserDB, 10); (shrink database to 10% of free space)Rename a database EXEC sp_renamedb N’Accounting’, N’Financial’; (old and new name)Check file group associated with a database Sp_helpfilegroupChange the database state Check the state (user_access_desc, state_desc) select *