Warehouse

Technical Article

RE: What makes a good developer?

  • Reply

I agree with what you say. I have met many people that are trying but do not understand. Is it because they don't understand logic? Select x from y where a=2 To me, that makes perfect sense but others cannot understand. I would love to view it in thier eyes. Just to see. I would […]

You rated this post out of 5. Change rating

2003-06-11

Technical Article

RE: What makes a good developer?

  • Reply

Hello Crispin, quote: Is it someone that understands logic or is it purly intelligence? the above plus self organisation curiosity love and understanding great portion of humor sarcasm all of the above none of the above don't know Now serious, I prognosticate this could be a huge thread, for it is kinda philosophical question. Let's […]

You rated this post out of 5. Change rating

2003-06-11

Technical Article

RE: Querying Active Directory

  • Reply

Found it! EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'AD Provider' grant select on corpsysad_allusers to public select * from corpsysad_allusers create view corpsysad_allusers as SELECT name FROM OPENQUERY( ADSI, ' SELECT name FROM ''LDAP://163.232.12.200/CN=Application Users,DC=ppl2kdv''') where ppl2kdv is the root node of my AD (others may include the complete .com.au or whatever, if […]

You rated this post out of 5. Change rating

2003-06-10

Technical Article

RE: Execute permission

  • Reply

You can use user defined role and add members to the role. Whatever permission the role is given will be inherited by members. But every time new objects are added, you need to adjust permission on the Role. In other word permission has to be set explicitly on newly created objects @ role level. MW

You rated this post out of 5. Change rating

2003-06-10

Blogs

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers