2008-05-15 (first published: 2008-02-29)
3,353 reads
Scripts
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)
750 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,623 reads
Script permissions on all databases
i took the core from a script found in the site for generating permissions and update it.
2008-05-06 (first published: 2008-03-06)
3,576 reads
space check
When run it will check the space left on the disk. If it was under 4GB it will raiserror.
2008-05-05 (first published: 2008-03-04)
1,449 reads
2008-05-01 (first published: 2008-03-06)
2,237 reads
Calendar Display with Language Specific Day/Month names
A stored procedure which takes a year and language as parameters and creates a calendar display for these parameters.
2008-04-25 (first published: 2008-03-04)
1,028 reads
2008-04-24 (first published: 2008-02-28)
1,863 reads
2008-04-22 (first published: 2008-02-28)
1,687 reads
2008-04-18 (first published: 2008-02-22)
3,877 reads
Blogs
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...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
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