SQL 2005 IndexDefrag solution
Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at night
2013-12-17 (first published: 2008-05-07)
3,713 reads
Scripts
Scripting SQL jobs using PowerShell
Using powershell to create different sql scripts in different files.
2013-12-13 (first published: 2012-04-19)
2,954 reads
How we can move the login which has Sysadmin role.
We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.
2013-12-09 (first published: 2013-11-29)
1,057 reads
2013-12-06 (first published: 2011-01-31)
4,841 reads
Find all Job Relationships with SSIS Config files
Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.
2013-12-05 (first published: 2011-03-02)
1,757 reads
2013-12-02 (first published: 2013-11-18)
1,763 reads
Create Mirror Alerts for All Mirrored Databases
Creates Mirror State-Change Alerts for ALL mirrored databases on a server - can save hours when setting up multiple mirrored instances
2013-11-29 (first published: 2010-11-23)
4,221 reads
2013-11-25 (first published: 2013-11-15)
2,230 reads
Split and concatenate function
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
3,149 reads
Powershell script to interactively move cluster resources
Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.
2013-11-19 (first published: 2013-11-04)
2,438 reads
Blogs
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
Alamat Telp BCA KCP Brebes +62 838-4945-0961
Wa:083849450961 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212
Alamat Telp BCA KCP Slawi +62 838-4945-0961
Wa:083849450961 Jl. Jend Sudirman No.46, Curah, Slawi Wetan, Kec. Slawi, Kabupaten Tegal, Jawa Tengah...
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers