Reputation
4,339
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 22 39
Newest
 Constituent
Impact
~242k people reached

Aug
3
comment Create an AD user from a SQL Server trigger
Don't do this from within the trigger! The trigger should be fast and nimble - it should not do heavy lifting and time-consuming processing - and it should most definitely not be calling up an external resource that might take quite some time to respond! Instead - let your trigger make an entry into a "command" table, and have a separate process (T-SQL job or a little utility in any other language) read and interpret that command table and handle the actual creation of an AD user..
Aug
3
revised Create an AD user from a SQL Server trigger
edited body
Aug
1
revised Fire and Forget SQL Triggers?
added 31 characters in body
Aug
1
comment Problem with clustered index? Or bad indexes? (SQL Server 2008 R2)
Set Bad Habits to kick - putting NOLOCK everywhere - it is NOT RECOMMENDED to use this everywhere - quite the contrary!
Aug
1
revised Problem with clustered index? Or bad indexes? (SQL Server 2008 R2)
added 7 characters in body; edited title
Aug
1
revised SQL Server DeleteFolder Job ran successfully but it doesn't deleted the folder
edited body; edited title
Aug
1
revised Moving from MS Access to SQL Server 2012, need help with column history
added 34 characters in body; edited title
Aug
1
revised SQL Server replication - error when creating a subscription - The article '(null)' does not exist
added 119 characters in body; edited title
Aug
1
revised SQL Server Performance in VMWare when creating different drives from a single Datastore
added 10 characters in body; edited title
Aug
1
revised Migrate existing SQL Server database file to smaller files
added 2 characters in body; edited title
Jul
29
revised Issue in installing SSIS MS-SQL2012
deleted 7 characters in body; edited tags; edited title
Jul
29
revised SQL Server : create dynamically queries to select all related data in DB based on entry table and ID
deleted 1 character in body; edited title
Jul
29
revised Cannot connect to a SQL Server 2014 Express database intermittently
added 1 character in body
Jul
29
revised SQL Server 2014 AG Listener
added 7 characters in body; edited title
Jul
27
awarded  Caucus
Jul
27
revised How to get exact year difference between two dates in SQL Server?
added 14 characters in body; edited title
Jul
27
revised SQL Server Mirroring Removed
added 6 characters in body; edited title
Jul
27
revised How to restrict access to SQL Server user in some period of time
added 7 characters in body; edited title
Jul
27
revised SQL Server Max memory limit
added 25 characters in body; edited title
Jul
27
revised SQL Server 2012 restrict CmdExec to sysadmin server role
edited body; edited title