data

Technical Article

RE: Very Large Database Backup

  • Reply

great advice above. One more I'd add - SQL Litespeed. Works great and has reduced our largest backup substantially in size and time. Went from 60G native to 9GB with Litespeed. Times went down from 90 minutes to around 40 minutes. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

You rated this post out of 5. Change rating

2003-06-13

1 reads

Technical Article

RE: What makes a good developer?

  • Reply

Good question! Well IMHO a good developer is a good visualizer and tansformer i.e. visualizes the problem its pros and cons its limitation and then transform it to any language he knows or always can learn a new language. regards.

You rated this post out of 5. Change rating

2003-06-13

1 reads

Technical Article

RE: What makes a good developer?

  • Reply

quote: When it's art, courage is important. Not knowing how to do something but still willing to look silly, asking basic questions and making mistakes. And trying things nobody else has, or has been willing to try. Seriously, this is probably the best discription I have heard so far. NPeeters: Yes, beer back again. 🙂 […]

You rated this post out of 5. Change rating

2003-06-11

Technical Article

RE: COM+ and SQL Server Transactions

  • Reply

If you want to post the VB code, I can take a look. We have successfully used COM+/MTS components here for a while and have gone through the gammet of weird MTS errors and hangups. Just be sure that you are properly using SetComplete and SetAbort on the ObjectContext and that your error handling is […]

You rated this post out of 5. Change rating

2003-06-11

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