Category Archives: Security

A list of blogs focusing on security concepts in SQL and Azure

What does a brute force attack look like?

By | May 13, 2020

Ever wondered if your server is being targeted for a brute force attack? What does it look like? How to prevent it? What is a brute force attack? A brute force attack is different from other attacks because it’s relying purely on a numbers game to gain access to the system. Unlike social engineering attacks… Read More »

SQL 2019 – Christmasql

By | December 4, 2019

Early November I had posted I would be conducting a series of sessions on MS SQL server. The response was really great and while I intended to do a classroom session the interest was primarily for online delivery. So I will be arranging the first half of it this in the coming 10 days. Here… Read More »

SQL 2019-Data Classification and Vulnerability assessment

By | November 5, 2019

  Data Classification With GDPR security has become a high priority for a large number of organizations the cost of not implementing robust security has been significantly increased and therefore companies that previously used to think security wasn’t a key part of their architecture now has to revisit that approach. But complying with GDPR and… Read More »

SQL 2019 – TDE SUSPEND RESUME

By | November 3, 2019

In this video we are going to talk about transparent data encryption. Transparent data encryption is a feature in SQL server that protects data at rest. Data at rest means your MDF and LDF files. These files reside on the hard disk and are easy prey to anyone with access the file system. By simply… Read More »

Part 2 -Securing Azure :- Database Security best practices – Call to get your Azure Audited

By | October 31, 2019

In this video we continue with how to secure Azure SQL Databases based on the security best practices mentioned in the last video. We cover how to create a Azure SQL Database and SQL Server. Identify what features are enabled by default and what’s not. We then move on to enabling Auditing Advanced Threat Detection… Read More »

Powershell :- Azure database security check

By | October 24, 2019

Error on WebAPI after deployment to Azure App Services

By | January 15, 2019

Encountered this below error today while deploying a WebApI to Azure App Services. Initially it wasn’t very clear what the error was about so we checked the bin folder for the below assembly but couldn’t find it. Since the API was working locally the answer had to be a configuration change from Dev to Prod… Read More »

Installing SQL 2019 CTP 2.0

By | September 25, 2018

It’s finally out and it’s going to be awesome but there is only one way to find out, so here is the very first step, installing SQL SERVER. The trail version CTP 2.0 can be downloaded from the below link. You have four different installers. https://www.microsoft.com/en-us/sql-server/sql-server-2019 SQL for Windows SQL for Linux SQL in Docker… Read More »

The-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn -FIXED

By | April 9, 2018

Interesting little problem came up today when migrating a database from Azure SQL database to local server. The connections sting in the web app had the following property set Encrypt=True; TrustServerCertificate=False   The combination of the two keywords ensures that data transfer from Website to Database server is encrypted using a certificate generated by the… Read More »

How secure is the Aadhaar/UIDAI database?

By | March 26, 2018

The recent discussion on how social media and Big Data is being misused to profile and categorize users is very serious. However most people don’t seem to grasp the seriousness or really care about it because they feel it doesn’t affect them. Hopefully with this post we can shed some light on the topic. What… Read More »