(Samantha Toet) Building extremely deep monitoring as a SaaS product has a drawback: we capture too much data for some customers’ compliance requirements
Community
Working with the APEX tree
(Tobias Arnhold) Out of a coincidence I haven’t used the APEX tree region for years. Now I got the task to create a customizable tree in my application. Since APEX 5 there is a new tree type called “APEX tree” which supports some really cool functions.
DDL for constraints – subtle things
(Connor McDonald) The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the data dictionary, or many a DBA will be familiar with running “imp show=y” or “imp indexfile=…” in order to then laboriously extract the DDL required from the i
Oracle’s Transparent Data Encryption
(David Fitzjarrell) Security. Each day it seems another breach is reported, another hack revealed, more personal user information is stolen, apparently despite the best efforts to thwart such attacks.
How to use the TREATAS function in DAX
(Koen Verbeeck) The DAX query language – used in Analysis Services Tabular, Power Pivot and Power BI – contains some powerful functions. One of these functions is the relatively new TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where th
Binding with Angular v4 And Above
(Bhairab Dutt) Hi Readers, I hope you all are doing well and have read my previous tutorials. In my previous article about the Angular Hook Life Cycle, Learn About Angular Component Hook Life Cycle, I have explained about the life cycle of components. Today I am here with one more article, Learn Ang
Get started with Python on SQL Server – Run Python with T-SQL on SSMS
(Manoj) With SQL Server 2016 Microsoft added Machine Learning support with R Language in SQL engine itself and called it SQL Server R Services.
How to attach databases to custom SQL Server containers
(Michael Otey) Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach your databases to them.
Azure SQL Database Business Continuity Enhancements
(Marcin Policht) In one of our earlier articles published on this forum, we have presented a range of capabilities that enhance business continuity of Azure SQL Database deployments. That article is, at this point, over a year old, which constitutes a rather long time when you consider the rapid rat
Db2 for z/OS: Using the Profile Tables to Direct DDF Applications to Particular Package Collections
(Robert Catterall) I’ve posted several entries to this blog on the topic of high-performance DBATs (for example, one from a few years ago covered a MAXDBAT implication related to high-performance DBAT usage).