Category: SQL

Section 6 – Design security for infrastructure – Design a strategy for securing SaaS, PaaS, and IaaS services

Time for the next section to my SC-100 study guide: Specify security baselines for SaaS, PaaS, and IaaS services Specify security requirements for IoT workloads Specify security requirements for data workloads, including SQL, Azure SQL Database, Azure Synapse and Azure…

Continue Reading Section 6 – Design security for infrastructure – Design a strategy for securing SaaS, PaaS, and IaaS services

Section 14 – Secure data and applications – Configure security for databases

In this section I will cover the following: Enable database authentication by using Azure AD Enable database auditing Configure dynamic masking on SQL workloads Implement database encryption for Azure SQL Database Implement network isolation for data solutions, including Azure Synapse…

Continue Reading Section 14 – Secure data and applications – Configure security for databases

Azure SQL Database pricing and security features

What is Azure SQL Azure SQL databases are coming more and more used. They can be expanded on the go with elastic pools or you can use them inside servers like inside on-premises installations. You can have multiple SQL services…

Continue Reading Azure SQL Database pricing and security features

SQL history and migration to Azure with security of Defender.

Hi, This time I will be blogging about SQL databases. First a little about history. SQL databases had (and still have) a significant part in the structure of a software. They contain storage for the data and configuration for nearly…

Continue Reading SQL history and migration to Azure with security of Defender.

SQL Server Backup from inside Azure VM

You can backup SQL Server databases and instances running inside Azure VM using Azure Backup. The solution leverages the SQL native APIs to take backup of your SQL databases. When you specify the SQL Server VM that you want to…

Continue Reading SQL Server Backup from inside Azure VM

Sharepoint 2013/16 and WSS_Logging DB

Sharepoint gathers usage and health data to database called WSS_Logging. By Default retention period is 14 days. If You want to make it lower, lets say 2 days use the below oneliner for it.

And then just a quick…

Continue Reading Sharepoint 2013/16 and WSS_Logging DB

User has db_owner my mistake.

Hi, When you are trying to remove user from a database, you will get: The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) There is a easy fix for this. First…

Continue Reading User has db_owner my mistake.

Install SQL when reboot is pending

Hi, First of all. There are some instructions that say you should remove pending renames from registry. Don’t do it. Just type text below from an administrative command prompt. setup /ACTION=install /SkipRules=RebootRequiredCheck

Continue Reading Install SQL when reboot is pending

Move Sharepoint database to a different server.

I wont write on article on this because I found an excellent ready one. But the situation is that you have to move sharepoint to a different server keeping the sql-server instance name as is. http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255 Thanks Todd!

Continue Reading Move Sharepoint database to a different server.

Transfer SQL Logins and their passwords.

Hi again, Done this multiple times, but thought it would be wisdom to share it. Remember this wont be necessary in SQL 2012 and higher because they save users and password directly to the user database not the master database….

Continue Reading Transfer SQL Logins and their passwords.