Technical Article

Add files to filegroups and log for many dbs

Purpose: This SP is used to add a logfile and a datafile to each file group in a database or all databases. This is handy when you have a lot of databases and you want to add a new big SAN-disk and stop db expansion on the old disks.Consider: Avoid running any large updates when […]

You rated this post out of 5. Change rating


119 reads


Removing a PowerShell Array Element–#SQLNewBlogger


I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure


In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server


Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs


txt file Pipe

By juliava

Hello, I need to put data from table to txt file as pipe on...

Case statement to insert a new line in query output??

By jbalbo

Hi I need to insert a new line of my output when a condition...

Database Mail to work on Azure VM

By terry999

Trying to get Database mail working sending via or port 587 using ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers