Stop People From Changing Tables with This One Trick

I received today's posts from Brent Ozar, I feel it is very interesting, LOL:


Brent Ozar says:
Stop People From Changing Tables with This One Trick

Brace yourselves. Our Black Friday sale is coming.
Developers hate his bad idea jeans:
CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING
AS
SELECT COUNT(*) FROM dbo.Table1
UNION ALL
SELECT COUNT(*) FROM dbo.Table2
UNION ALL....
Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure out about your view.)
Obligatory disclaimer: seriously, this is a really bad idea. But it’s hilarious.

Comments

Post a Comment

Popular posts from this blog

Sysaux tablespace is too big

Image
 today I received my report alert regarding one of Oracle database tablespace SYSAUX is over 80% (I created automated job using SSIS package to check tablespace usage daily) following steps to resolve it:  /*  2021.07.08  Documentation steps for troubleshooting Sysaux tablespace is huge --85% full  */   ---1. see what uses the most select occupant_name,occupant_desc, space_usage_kbytes/1024 MB from v$sysaux_occupants where space_usage_kbytes > 0 order by space_usage_kbytes desc; ---find it is SM/Advisor Server Manageability - Advisor Framework 25GB --now look for top 10 big objects   select * from (                select bytes/1024/1024 MB, blocks, s.SEGMENT_NAME, s.partition_name, s.segment_type, s.tablespace_name                  from dba_segments s                 where owner='SYS'             ...
Read more

SQL server mdf file modifed date

SQL server mdf file modifed date the modified date of mdf, ndf (sql server database files) only changes when 1. Database turns online(server restart, new db, being restored) 2. file expanded/shrunk 3. DBCC checkdb ---will update if notice further factor to change the modified date of database data file.
Read more

Developing Nightly DBA PACKAGE for MS SQL SERVER and ORACLE

Scenario: 1 DBA, 200+ MSSQL instances (PM, VM), 1700+ MSSQL databases, version 2000-2016  10 Oracle machines(Windows, Linux, HPUX), 30 Oracle Databases. version 10g-12c to be able to manage such big amount of MSSQL and Oracle databases, an automatically monitored system is required to highlight only the instances/database to be checked every morning. Tool to be used: MSSQL, SSIS , SSAS, SSRS Data to be collected and analyzed Instance and Databases properties, hardware info, CPU, Memory, DiskIO, latency, waits, Part one: Design Database to store metric data
Read more