Create 4 Drives Data for SQL DB F:\Logs E:\TempDB G:\Backups H:\Install DB to F:\MSSQLSERVER\Install Client Tools by Defaults and Anything else you might need Setup GMSA service accounts for […]
Tag: SQL
Azure SQL Profiler – In order to run a trace against SQL Server you must be a member of sysadmin
You are not allowed to run a trace against Azure SQL Database. To do query profiling on Azure SQL, you can use Dynamic Management Views or take a look at the Azure SQL […]
Azure Auto Tuning – Azure SQL Indexes
You have to evaluate the indexes based onCurrent indexes –Can it be combine with an existing index or is it really a new index to add i.e. […]
Automatic tuning – Azure SQL Drop Indexes
Careful about enabling his , it can still report the duplicates and then the indexes can be evaluated to see if they are indeed duplicates. If they […]
Add User to Azure SQL DB and Assign permissions
How to assign User Connect Permissions to Azure DB[pastacode lang=”sql” manual=”CREATE%20USER%20%5Bemail%40domain.com%5D%20FROM%20EXTERNAL%20PROVIDER%3B” message=”” highlight=”” provider=”manual”/]How to find current Roles assigned to Azure DB[pastacode lang=”sql” manual=”SELECT%20DISTINCT%20pr.principal_id%2C%20pr.name%2C%20pr.type_desc%2C%20%0A%20%20%20%20pr.authentication_type_desc%2C%20pe.state_desc%2C%20pe.permission_name%0AFROM%20sys.database_principals%20AS%20pr%0AJOIN%20sys.database_permissions%20AS%20pe%0A%20%20%20%20ON%20pe.grantee_principal_id%20%3D%20pr.principal_id%3B” message=”” highlight=”” provider=”manual”/]How […]
How to find out when the Database’s on a SQL server were last used\accessed to help with migration and decommission
Giving User Granular access to SQL Agent and SSISDB ( Intergration Services Catalog )
SQL AgentGive the user the right role e.g. SQLAgentOperatorRole to msdb ( https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-ver15 ) SSISDB ( Intergration Services Catalog ) Give the user the ssis_admin role for the SSISDB […]
SQL Licensing
Software Assurance License Mobility refers to the ability to move virtual instances from host to host and between server farms. SQL server needs Software Assurance for License Mobility.Software Assurance can […]
SQL Server / The target principal name is incorrect. Cannot generate SSPI context
Recently had a user with this error. I’ve had this before after a domain migration I had Manually create SPN , but this SQL server hadn’t moved.In […]
Cannot change Azure SQL Virtual Machines from Express to Developer
I got deployment failed when trying to change a SQL servers License from Express to Developer.I checked the Server and it had developer license installed on SQLLooking […]