2008-02-25 (first published: 2008-01-15)
930 reads
Scripting extended properties
I use these to manage the addition and removal of extended properties on all tables and columns in my company's dbs.Rather than writing complicated joins or calling functions every time, I use views on sysobjects and INFORMATION_SCHEMA tables. I tried to make these scripts as flexible as possible so you can reuse them in procedures, […]
2006-01-05 (first published: 2005-11-11)
1,247 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Sentral Cikini. Tlpn:085373737845
Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Metro Tanah Abang. Tlpn:085373737845
Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H. Wahid Hasyim No.189,...
BCA KCP Cempaka Putih. Tlpn:085373737845
Jl. Letjen Suprapto No.30 EF, Harapan Mulya, Kec. Kemayoran, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers