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
Idera GeekSync: SQL Security Principals and Permissions 101
By Will Assaf
Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar...
Arrays in PowerShell–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Passwords = A Good Thing
Those my friends are, in my opinion, one of the single most wonderful things...
Forums
Looking for simple non-aggregate version of PIVOT to transpose Rows into Columns
I know I've found the answer to this before but I'm having trouble now...
Briefcase Missing Old Functionality
I haven't tried to save anything to my briefcase since the website rebuild. I...
Dynamic Partitions for Flight Data
I am parsing 30+ meg binary files, as varbinary(max), containing parameter data from an...
Ask SSC