Browsed by
Category: Sql Server

Azure Security Tip – Turn on SQL Database Threat Detection immediately for your Azure SQL Databases

Azure Security Tip – Turn on SQL Database Threat Detection immediately for your Azure SQL Databases

For anyone running their SQL Database in Azure, it is highly recommended that you enable Azure SQL Database Threat Detection to identify potential threats to your databases.  Types of threats include SQL injections, vulnerabilities in configuration and setup and weird database access patterns. It’s very simple and easy to do and your admins can get an immediate notification about abnormal activities on your databases in real-time. Furthermore, this service provides you with the information on how to further investigate what’s…

Read More Read More

SQL Server 2008 – Administrator account denied access or locked out

SQL Server 2008 – Administrator account denied access or locked out

I don’t know how many times my clients have given me administrator access to the SQL Server machine thinking I will automatically have access to administer the SQL Server.  However, in SQL Server 2008 and above (i.e. SQL Server 2008 R2), there is a new security feature where the installer doesn’t automatically add the local server administrators group as SysAdmin on the server.  The person doing the install has to remember to do this during setup.  Most of the time,…

Read More Read More