geometry STCentroid returns a polygon’s geometric center, but that point is not a promise of interior placement. I keep the center calculation separate from an interior test. A holed region makes that distinction visible.
CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small
Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.
SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008
Change Data Capture records changes without triggers or schema changes. Here are my notes on tuning the performance of Change Data Capture in SQL Server 2008.
SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’
ALTER INDEX with ENABLE fails with Incorrect syntax near ‘ENABLE’. To enable index after you disable it for a bulk load, you rebuild it instead.
SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True
I reached Seattle a week before PASS 2009 and spent it in the Advanced T-SQL course by Itzik Ben-Gan, whose T-SQL books I have all read. A dream come true.
Environment Settings in SSIS Projects
SSIS projects can deploy one package across environments by using project parameters, SSISDB variables, and tested references.
AsGml: Export a Shape as Namespaced XML
AsGml exports geometry as XML in the GML namespace. Read a line’s coordinates with a qualified path and compare an unqualified path.