Find storage including mount points sql/powershell
Find all storage including mount points and show' free and used available. Needs powershell.
2014-08-25 (first published: 2011-12-15)
1,397 reads
Scripts
Script to Restore Entire database from a directory
Script to restore the entire databases from the backup directory just by passing the backup directory.
2014-08-22 (first published: 2014-02-25)
3,320 reads
Powershell script to read Windows 2012 R2 Failover cluster log for Sql
I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.
2014-08-21 (first published: 2014-07-29)
1,752 reads
Change password for user 'sa'
Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.
2014-08-20 (first published: 2014-08-13)
1,913 reads
2014-08-18 (first published: 2014-07-28)
1,259 reads
2014-08-15 (first published: 2014-07-16)
1,555 reads
Generate Restore script for multiple databases
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
5,921 reads
Simple script to list out SPID, Program_name and login details
If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2014-08-12 (first published: 2014-06-30)
4,118 reads
2014-08-11 (first published: 2014-05-28)
1,795 reads
Script to generate the SQL to create a fulltext catalog and its underlying fulltext index
This script was published originally on http://humakhurshid.blog.com/2011/07/14/script_out_fulltext_catalog/
The author has tweaked it little bit to improve it.
2014-08-07 (first published: 2014-07-02)
5,812 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Alamat Kantor BCA KCU Green Garden Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Alamat Kantor BCA KCU Sunter Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers