Databases Archives

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

Other

Phil Factor in Other

Using Computed Columns and Scalar Functions in SQL Server for Text Transformations and Anagrams

Use SQL Server computed columns with scalar functions to precompute text transformations - shown through two worked examples: finding textonyms...

31 August 2016 15 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 31 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

SQL Server

Robert Sheldon in SQL Server

SQL Server Permissions: Principals, Securables & Roles

How SQL Server principals, securables, and permissions work together — logins, users, roles, and GRANT/DENY/REVOKE — with T-SQL examples.…

02 August 2016 18 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

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

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

Hitendra Patel

Dynamic Images in SQL Server Reporting Services

It is relatively easy to provide a smart BI solution when your customer has all the resources for a new...

01 June 2016 16 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

Aman Sharma

Oracle SCN (System Change Number): How It Works

Learn how Oracle's System Change Number (SCN) maintains read consistency and data integrity. Covers SCN structure, where it's stored (control...

23 May 2016 13 min read

Feodor Georgiev

Predictive Analysis Basics

Statistics holds out the promise of teasing out significant relationships and to determine cause and effect. Now that so much...

18 May 2016 15 min read