Email Long Running SPID Info
This script will email info about the longest running SPID in an HTML formatted table
2011-07-07 (first published: 2011-06-27)
2,202 reads
Scripts
Date Dimensions in T-SQL using CTE
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,828 reads
Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,363 reads
6 Steps to setting up Replication with Mirroring
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,209 reads
Powershell - Modify Server Name in SQL 2005 SSIS Connections
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
970 reads
2011-06-23 (first published: 2011-06-20)
629 reads
2011-06-22 (first published: 2011-06-14)
1,890 reads
Vincenty Direct
Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates
2011-06-22
561 reads
SQL DBAdmin toolbox - Part 2: Verify all databases in the enterprise
Do you verify database backups regularly? If not, you may find this toolbox solution usable.
2011-06-21 (first published: 2011-06-15)
2,004 reads
Finding all Columns of an Index
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,394 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
Alamat Kontak Bank BCA KCU RUNGKUT Telp:08218154392
WA CS (08218154392) Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Alamat BCA KCU Singkawang Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota...
Alamat Kantor BCA KCU Bandar Lampung Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers