Aman Sharma Understanding SQL Query Parsing – Part 1 Introduction When it comes to tuning a badly-performing query, there are many things that need to be checked. There may... 05 September 2016 14 min read
Database Administration Shel Burkow in Database Administration In-Memory OLTP: Row Visibility in SQL Server’s MVCC SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by... 05 September 2016 15 min read
Jonathan Lewis Massive Deletes – Part 4 In the previous installment of this series I produced some figures highlighting the main differences between doing a large delete... 05 September 2016 10 min read
T-SQL Programming Uwe Ricken in T-SQL Programming DELETE Operation in SQL Server HEAPs You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have... 05 September 2016 14 min read
David Njoku JSON For Absolute Beginners: Part 2 – Why Use Oracle? In this short series of articles, we’ll be talking about JSON and its integration with the Oracle database. The first... 02 September 2016 5 min read
David Njoku JSON For Absolute Beginners: Part 1- Introduction Hi, meet my friend JSON. Chances are you’ve heard of it, perhaps you have a vague idea of what it’s... 02 September 2016 5 min read
Blogs Phil Factor in Blogs The SQL of Textonyms The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word... 31 August 2016 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Predicates With Subqueries The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the... 25 August 2016 12 min read
Database Administration Robert Sheldon in Database Administration SQL Server for Linux Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform,... 25 August 2016 11 min read
BI Adam Aspin in BI Direct Query with Power BI Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify... 10 August 2016 30 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the Second When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is... 10 August 2016 15 min read
Database Administration Robert Sheldon in Database Administration SQL Server Access Control: The Basics No technology yet invented can in any way allow us to neglect the task of ensuring the security of the... 02 August 2016 17 min read
Performance Robert Sheldon in Performance SQL Server Statistics Basics Distribution statistics are used by SQL Server's Query Optimiser to determine a good execution plan for your SQL query. You... 22 July 2016 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the First With the formatting of code, we sometimes do things because they've always been done that way, rather than making code... 22 July 2016 16 min read
Anju Garg Incomplete / Complete recovery using RMAN cold backup Offline backups (also known as Cold or consistent backups) are taken when the database is in a consistent state, i.e.... 29 June 2016 12 min read
Tools Richard Macaskill in Tools Clone, Sweet Clone: Database Provisioning Made Easy? One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you... 21 June 2016 8 min read
Robert Sheldon SSIS in SSDT: The Basics SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be... 20 June 2016 31 min read
Anju Garg Defragmentation Can Degrade Query Performance As data in tables is updated and / or deleted, pockets of empty space can be created, leading to fragmented... 16 June 2016 15 min read
Joshua Feierman 3 Built-In Technologies for Centralizing SQL Server Administration DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server... 01 June 2016 13 min read
Laerte Junior The PoSh DBA: Accessing SQL Server from PowerShell The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of... 01 June 2016 17 min read
