Security

There's a new piece of malware named skip-2.0 and it targets SQL Server. In this article learn what is it, where it came from, and how to protect your SQL Servers.

In this tip we look at a script you can use to see if a login and password is embedded somewhere with in your Linked Servers, SQL Server Agent Jobs or SSISDB information.

In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.

Learn about SQL Server functions that can help identify logins, database users, permissions and more with code examples.

In this tip we look at a SQL Server stored procedure that generates a report of all users and their assigned database roles.

SQL Server xp_cmdshell overview for SQL Server professionals - know the options and risks to invoke xp_cmdshell in SQL Server solutions.

In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.

Learn how to script out all SQL Server Credentials and Proxies.

In this tip we look at how to gain sysadmin level access to SQL Server if there is no other login to access SQL Server with sysadmin privileges.

In this tip we look at how to track forget me requests related to GDPR without actually storing any personal data.

In this tip we look at how to setup SQL Server alerts and notifications when security settings have been changed for logins.

In this tip we look at what SQL Server does with data once it has been deleted and whether the data really does go away or not.

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.

In this tip we look at the impact of the Meltdown and Spectre Vulnerabilities on SQL Server and provide a better understanding of the issue.

Check out this tip to learn how GDPR can affect your SQL Server disaster recovery plans.

In this tip, we will look at how to use group Managed Service Accounts (gMSA) for SQL Server.

In this tip we look at how to use Managed Service Accounts for SQL Server service accounts.

In this tip we see how SQL Server Management Studio 17.4 can be useful to identify SQL Server security vulnerabilities.

Here is a simple SQL Server T-SQL script to generate random strings that can be used as passwords.

In this tip we will provide a Meltdown/Spectre SQL Server Assessment Script that you can run against all of your SQL Servers to check for issues.

In this tip we look at how SQL Server security privileges can be elevated by using some backdoor security settings.

In this tip we look at how to secure and encrypt passwords used between Python and SQL Server.

In this tip we look at how to ensure our ETL files are not being tampered with prior to importing data.

In this tip we will look at the situation where a SQL Server database application requires multiple access levels with respect to accessing and modifying the data and how this can be done.