Skip to content
spiderip logo
Home » Posts tagged: SQL
Published August 13, 2018 by admin

SQL Server shrinkdatabase of all databases in MSSQL Server

Best Practices https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-2017 Consider the

Read More SQL Server shrinkdatabase of all databases in MSSQL Server

Windows

SQL

comments

Published August 13, 2018 by admin

Get list of databases from SQL Server

Execute this query to list of databases from SQL Server SELECT name FROM master.dbo.sysdatabases

Read More Get list of databases from SQL Server

Windows

SQL Tsql

comments

Recent Posts

  • Export SQL Agent jobs with steps and scripts using SQL Command
  • Validating commit log messages in VisualSVN Server
  • Linux copy folder structure without files to a new location
  • PowerShell script to send email using Amazon SES with credentials
  • IIS url rewrite one folder and sub-content to another domain with query string

Popular Posts

  • Powershell script to import a certificate to the local machine trusted root certificate store
  • TortoiseSVN overlay icons not showing in windows 10
  • Powershell Invoke-WebRequest ignore certificate warning
  • error CS0012: The type 'System.Object' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Runtime, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
  • PowerShell script to Remotely Enable a Local administrator Account and set a password.

Archive

  • ▼ 2019 (7)
    • September (1)
    • August (1)
    • February (1)
    • January (4)
  • ► 2018 (33)
    • November (4)
    • October (3)
    • August (4)
    • July (7)
    • June (8)
    • May (2)
    • April (5)

Popular Tags

  • linux (3)
  • powershell (3)
  • disk (2)
  • SQL (2)
  • iis (2)

Spiderip-Blog

Spiderip blog offer latest powershell scripts and resources