2011-11-22 (first published: 2008-03-19)
5,699 reads
2011-11-22 (first published: 2008-03-19)
5,699 reads
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,798 reads
2011-11-18 (first published: 2008-01-29)
2,859 reads
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,414 reads
Script reassigns database orphan users to the matching SQL Server logins.
2011-11-15 (first published: 2011-10-24)
2,545 reads
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
646 reads
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
2011-11-11 (first published: 2011-09-27)
1,161 reads
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-10 (first published: 2011-10-12)
2,974 reads
Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year
2011-11-08 (first published: 2011-10-11)
6,138 reads
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,498 reads
A reader of one of my previous posts pointed out that the legend order...
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers