SQL Server – Dynamic SQL – SQL Injection – EXEC [ QUOTENAME() , REPLACE() , EXECUTE AS ] – Sp_executesql – [ RECOMPILE ]

Recently I had mess up with dynamic SQL , So whats next !!! , I started to explore on this topic and post it here , when I googled to gather some information , but what I found was , this topic has been already drilled to the core , carved and with the sculpture…

Details

SQL Server – Capturing Missing Join Predicate for queries using Extended Events

missing_join_predicate , one of the event  –  ” Occurs when an executed query is missing a join predicate. Use this event to identify a query that may perform slowly because of the missing predicate. This event only occurs if both sides of the join return more than one row ” . SELECT * FROM sys.dm_xe_objects…

Details

SQL Server – Database Read – Only

After attaching sample database – AdventureWorks2012,I noticed the database in Read-Only state as shown in below image : To change your database to Read-Write state ,execute below code: ALTER DATABASE [AdventureWorks2012] SET READ_WRITE To change your database to Read-Only state ,execute below code:  ALTER DATABASE [AdventureWorks2012] SET READ_ONLY    You can also Set Database Read…

Details