Powershell/SMO: Unload table schema, dri, perms & data.
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,162 reads
Scripts
2008-06-08
1,948 reads
Difference between two dates in weeks
Returns difference between two dates in weeks, takes into account @@DATEFIRST setting
2008-05-28 (first published: 2008-04-11)
1,310 reads
2008-05-27 (first published: 2008-04-10)
1,772 reads
2008-05-23 (first published: 2008-04-10)
2,191 reads
Backup all DBs of a SQL-Server Instance
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
2008-05-22 (first published: 2008-03-28)
2,430 reads
2008-05-19 (first published: 2008-03-20)
950 reads
2008-05-15 (first published: 2008-02-29)
3,376 reads
SQL 2005 - List value of 'Not For Replication'
Script will list all identity columns with valus of 'Not for Replication'
2008-05-13 (first published: 2008-03-20)
773 reads
Import/Export SQL Server 2000 Enterprise Manager Registered Servers
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-05-08 (first published: 2008-02-15)
2,645 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Alamat BCA KCP Batu Ceper Telp:0821°8200°233
Telp/Wa 628218200233 Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan Mogot...
Alamat BCA KCP AEON Mall BSD Telp:0821°8200°203
Telp/Wa 628218200203 AEON Mall BSD City Ground Floor Unit G-80, 81 & 81A, Jl....
Alamat BCA KCP Raya Serpong Telp:0821°7555°651
Telp/Wa 628217555651 Jalan Raya Serpong 06, RT 008 RW 02, Pondok Jagung, Serpong Utara,...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers