Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183

If you are facing an issue of unauthorized index modification, you can use a very simple trick discussed in this blog post.

0:00 Intro
00:15 Real-world Scenario
00:40 Demo: Unauthorized Index Modifications
01:35 Demo: Database Trigger
02:17 Final Say

#SQLServer #PerformanceTuning #SQLAuthority

[PatrickWard]

I came here for the ukulele playing, but still always love learning something new every time I see your videos or articles.

[panapty]

Hey, you look like Jose Feliciano(singer) with those sunglasses and the ukelele. jeje

[mogarohit]

Hi There,

Database : MySQL
Table : 1 Million Rows

select id
from table
where text like '%xyz%';

Query taking more than 2 mins.
Any way to optimize this ?

[spandanshorts]

hi pinal is there any chance of restricting only some admin users from stopping creation of index using simple query like above

[r]

I would add an IF statement to allow for sa or my user account.

[mysolcsbi]

With respect sir your videos are really helpful for me. but sometimes it is too much professional information with highly experienced approach. Sir I have a database of 18 tables it is for POS .Please guide me.. Sir i did not use relationship among tables . I just used keys.. and my C# application with sql server working fine on two clients machine. Sir is it okay if we dont define relationship among tabels like one to many ...many to many etc?

[devendrasingh]

How to recover deleted table data from Azure without restoring database.

[darrylw]

OK but that prevented you from altering the index, which I guess, is not what you want. So I'm not sure how useful this really is...