DBA Meaning:DBA stands for “doing business as”. A DBA is any registered name a business operates under that isn’t its legal name. DBAs are sometimes called a tradename, assumed name, or fictitious name. Read
OK, now that some of the requirements are done. We can get into the heart of creating an Azure SQL Database. One thing about an Azure SQL Database is that it still uses a SQL Server, meaning there is a logical SQL Server instance created when deploying an Azure SQL Database. In this...
Consider a 1TB database with a reasonable requirement of 30,000 read IOPS during peak load. To build a solution capable of this, 5000GB (i.e. 5TB) of capacity would need to be provisioned… meaning 80% of the capacity is wasted! Worse still, the “Read IOPS per instance” row of ...
Normally, when you run a program (an executable file), it runs withyour own permissions– meaning it can only do what your user account is allowed to do. But if thesetuidbit is set on a file,the program runs with the permissions of the file’s owner, regardless of who is running it...
Administrative DBA – maintains the servers and databases and keeps them running. Concerned with backups, security, patches, replication. These are activities mostly geared towards maintaining the database and software platform, but not really invloved in enhancing or developing it. ...
Oracle’s new Exadata Database Machine X4-2 has 44.8TB of raw flash in a full rack configuration, yet the datasheet states it has an effective flash capacity of 448TB. Excuse me? Let’s read the small print to find out what this means: apparently this is “the size of the data ...
WAIT_CLASS#, andWAIT_CLASSare new in 10g. The columnWAIT_CLASSindicates the type of the wait that must be either addressed as a valid wait event or dismissed as an idle one. In the above example, the wait class is shown asApplication, meaning that it's a wait that requires your ...
Now, in the world of DevOps, TDM is super important because it helps keep testing on track with the speedy development process. Pretty much meaning you need the right stuff to keep you going without slowing down. How does TDM fit into DevOps?
Our weapon of choice will beRestore-SqlDatabase. This workhorse cmdlet has been part of the both the old SQLPS and the new SqlServer modules. The functionality hasn’t really changed, meaning that what we go over here should work for you regardless of what module you use. I always recomme...
SAP MaxDB: In the Database Assistant, choose the function Tools DBA Planning Calendar or from the user menu, choose Database: Operation DBA Planning Calendar (transaction DB13). SAP liveCache Technology: In the liveCache Assistant, choose the liveCache: Monitoring function Tools DBA Planning Calen...