This is a simple method to load a SQL database with active directory account information without running into the 1000 record limit. You will need to change the SERVERNAME, PORT, DATABASENAME, USERID, AND PASSWORD values in the connection strings to your own values. You will also need to change the LDAP connection string values ('LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld') […]
2011-11-21 (first published: 2007-08-01)
2,809 reads
Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]
2006-08-21 (first published: 2006-08-01)
471 reads
Look, we all know data is king these days. But having mountains of data...
This topic keeps coming up with my customers so the purpose of this blog...
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
I was trying to access SSRS report in host server browser , throwing an...
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
Hello, I have a problem and i don´t understand it. After to link a...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers