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
Joe Celko Declarative SQL: Using UNIQUE Constraints In SQL, you can express the logic of what you want to accomplish without spelling out the details of how... 04 December 2015 14 min read
Laerte Junior The PoSh DBA – Using the Basic PowerShell Paradigms PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to... 04 December 2015 10 min read
David Njoku SQLcl: The new challenger for the SQL Plus crown I’m that grumpy old guy who comes to your party and sits in a corner with a face like a... 30 November 2015 9 min read
Gert Poel About functions, records and result cache This article is about functions and how to get more out of them if you combine them with record structures.... 20 November 2015 6 min read
Omid Afzalalghom Doing a SQL Server Healthcheck via PowerShell PowerShell is an ideal tool for doing health checks of a collection of SQL Server instances, and there are several... 16 November 2015 13 min read
Enrico van de Laar The SQL Server 2016 Query Store: Overview and Architecture SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information... 16 November 2015 14 min read
Edward Elliott SQL Server Data Tools (SSDT) and Database References SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database,... 16 November 2015 12 min read
David Njoku Multi-Table Insert Statements in Oracle We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming,... 09 November 2015 7 min read
Jonathan Lewis Basics of the Cost Based Optimizer – part 6 In part 5 of this series I started working through a list of queries designed to demonstrate ways in which... 04 November 2015 14 min read
