SQL Server security – Providing a security model using user-defined roles
Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.
2021-05-24
security
SQL Server Security – Fixed server and database roles
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
2021-04-22
What to monitor for SQL Server security
Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.
2021-04-16
Using Kerberos Configuration Manager for SPNs Validation
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
2021-03-30
Finding Inactive SQL Server Databases
Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.
2021-01-28
Implementing SQL Server Security with Stored Procedures and Views
Learn about how ownership chaining allows you to limit permissions on specific database objects yet give users access through other objects such as views and stored procedures.
2020-10-01
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,428 reads
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
3,047 reads
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
7,139 reads
SQL Server Machine Learning 2019: Working with Security Changes
SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.
2020-03-11
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCP Kemang Pratama Cs 0823-7497-7784
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers