Blogs Phil Factor in Blogs The Luhn Algorithm in SQL The Luhn test is used by most credit card companies to check the basic validity of a credit card number.... 16 February 2016 7 min read
Anju Garg ASM Proxy: New Instance Type in Oracle 12c Prior to Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System... 15 February 2016 11 min read
Sander Stad Documenting SQL Server with PowerShell SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check... 11 February 2016 20 min read
Robert Sheldon Five Online Database Modelling Services To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have... 08 February 2016 13 min read
Joe Celko SQL GROUP BY Basics It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives... 08 February 2016 15 min read
Jonathan Lewis Massive Deletes – Part1 In a recent article about dropping columns from a table I left hanging the question of what you might do... 29 January 2016 12 min read
Robert Sheldon SQL Server System Views: The Basics When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the... 27 January 2016 19 min read
Sergei Dumnov Using R Machine Learning Script as a Power BI Desktop Data Source You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom... 27 January 2016 11 min read
Houri 12c Hybrid histogram In the previous article about the Oracle 12c TOP-Frequency histogram, we saw that Oracle carries out a preliminary determination step... 26 January 2016 20 min read
Enrico van de Laar The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings,... 26 January 2016 13 min read
Edward Elliott Connected Development with SQL Server Data Tools Although SQL Server Data Tools (SSDT) encourages 'disconnected' database development, it also provides the SQL Server Object Explorer (SSOX) tool... 26 January 2016 8 min read
Laerte Junior The PoSh DBA – Towards the Re-usable PowerShell Script When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for... 21 January 2016 17 min read
Houri 12c Histogram: TOP-Frequency As of Oracle version 12.1, if a number of buckets N in a histogram is less than the number of... 19 January 2016 13 min read
Jonathan Lewis Dropping Columns I have my Oracle Support account configured to send me a daily email of “hot topics”, and I’ve set it... 14 January 2016 13 min read
Anju Garg Split Brain: What’s new in Oracle Database 12.1.0.2c? In an Oracle cluster prior to version 12.1.0.2c, when a split brain problem occurs, the node with lowest node number... 14 January 2016 10 min read
Joe Celko Declarative SQL: Using CHECK() & DEFAULT SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that... 13 January 2016 13 min read
Enrico van de Laar The SQL Server 2016 Query Store: Built-in Reporting One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features,... 06 January 2016 11 min read
Robert Sheldon JSON support in SQL Server 2016 At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a... 15 December 2015 21 min read
Joe Celko Declarative SQL: Using References There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective... 15 December 2015 13 min read
Anju Garg Oracle Data Pump in RAC Oracle Data Pump was introduced in Oracle Database 10g to enable very high-speed transfer of data and metadata between databases.... 10 December 2015 15 min read
