Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,301 reads
Scripts
NULLs to Not NULLs
Script finds char types columns defined to allow NULL values but have non NULL values and generates the ALTER statements for the changes.
2016-02-22 (first published: 2016-02-08)
1,033 reads
Grant EXECUTE on all user-defines types
Gives execute permission on all user-defined types for the specific user
2016-02-19 (first published: 2016-02-03)
855 reads
SQL Agent job to show SQL Server service details upon agent restart
To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.
2016-02-18 (first published: 2016-02-04)
749 reads
Enhanced Index Rebuild Script
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,947 reads
Restore Redgate Transaction logs files via SQL
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
532 reads
2016-02-15 (first published: 2016-01-29)
963 reads
Transfer/copy data between servers using Remote Connection
Synch tables from Server 1 to Server 2 with out dropping tables in server 2 which do not exists in server 1.
2016-02-11 (first published: 2016-02-01)
1,101 reads
2016-02-05 (first published: 2014-05-15)
3,301 reads
Index stats with key,included columns, size - all you can eat
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
912 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers