WebSenior SQL Server Database Administrator with over 25 years’ experience in the IT industry. Actively working in a Microsoft SQL Server environment, supporting; SQL Server 2000 through to SQL Server 2016. Performing the installation, configuration, backup, maintenance and patching of SQL Server instances. Migration of databases to new SQL … Web5 feb. 2024 · For ad-hoc checks on how disk space is being used by a database, we can use the built-in SSMS reports. Simply right-click on any database and select Reports …
Disk Space Monitoring using SQL Server DMV – SQLServerCentral
WebPerformed daily tasks including check for failed processes, analyze errors and validate disk space. Developed SQL scripts for maintaining administration tasks. Proactively … WebIn SSMS Object Explorer, right-click the database you want to link to source control and select Source Control > Link Database to Source Control. 2. In the Link Database to Source Control dialog that opens, click + in the Source control repository field. 3. In the Source Control Repository Properties dialog that opens, do the following: facebook malachi roberts kentucky
Principal Database Administrator Resume - Hire IT People
Web1 jun. 2024 · Step 1 – Checks to Perform on your PC The first thing you need to check when you get the “not enough space on the disk (mscorlib)” error message, when running queries in SSMS, is the system drive (usually the C drive) on the PC you are running SSMS. Web28 feb. 2024 · To monitor the amount of memory that SQL Server uses, examine the following performance counters: SQL Server: Memory Manager: Total Server Memory … Web13 mrt. 2024 · You can also query master or directly the database using TSQL. -- Connect to master. -- Database data space used in MB. SELECT TOP 1 storage_in_megabytes AS … does nicotine gum constrict blood vessels