Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,579 reads
Security
SQL Server Security Checklist
SQL Server security related tasks can be divided into four main categories: physical security, operating system level security, SQL Server configuration and user management. Here is your SQL Server security checklist.
2014-02-20
4,963 reads
2014-01-23
2,056 reads
2013-11-22
1,966 reads
2013-10-31
2,207 reads
Loginless Database Users and Dynamic SQL
Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.
2013-09-10
7,379 reads
2013-07-12
2,321 reads
Passively detect attempts to guess passwords
Review the error log for possible brute force or dictionary attacks on your SQL Server instance.
2015-05-08 (first published: 2013-05-22)
2,708 reads
Loginless In Seattle
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
2013-05-13
3,167 reads
Change DB Owner to sa for multiple DB's
Changes DB owner to sa for Online DB's where owner is not sa
2013-04-26 (first published: 2013-04-12)
2,764 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers