2008-02-25 (first published: 2008-01-15)
911 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,211 reads
Blogs
Azure Data Studeo- Nov 2019 Release
By Vinay Thakur
SQL Server Management studio is now can be installed separately not part of SQL...
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
Forums
SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor
Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...
Basic Avaialbility setup but replicas went to resolving mode
Hi, I configured the Basic Alwayson setup in two of the test SQL standard...
I am looking to optimize this T-SQL Statement (it generates very High Reads..)
In the below SQL statement (also attached as DOC file) it has been...
Ask SSC