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

Joe Celko

Looking at VIEWs, Close Up

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how...

10 May 2016 23 min read

Joshua Feierman

The Enterprise DBA Mindset as a Practical Problem-solving Approach

In order to keep the demands of the job under control, any DBA needs to automate as many as possible...

10 May 2016 13 min read

Murilo Miranda

In-Memory OLTP – Row Structure and Indexes

There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the...

04 May 2016 12 min read

Murilo Miranda

In-Memory OLTP – Understanding Memory-Optimized Tables

How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the...

04 May 2016 13 min read

Kartik Balachandran

Running Siebel CRM on Non-Standard Versions of Internet Explorer

Traditionally Siebel CRM has been heavily dependent on ActiveX controls. Oracle offers lifetime support on any Siebel version post version...

03 May 2016 5 min read

Phil Factor

SQL to UML: Auto-Generate Database Diagrams with PlantUML

Auto-generate UML database diagrams from SQL Server metadata using PlantUML and GraphViz. T-SQL scripts create class diagrams, ER diagrams, and...

03 May 2016 20 min read

Kartik Balachandran

Siebel CRM Part 12: Upgrading a Non-Development Database

In the last two articles we covered the process of upgrading a development database. The steps involved were as follows:...

26 April 2016 10 min read

Kartik Balachandran

Siebel CRM Part 11: Performing the Siebel incremental Repository Merge

As mentioned in the last article in this series, the Siebel upgrade process is split into 3 separate parts: Upgrade...

25 April 2016 8 min read

David Njoku

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility

There’s something slightly oxymoronic about the phrase XQuery Update Facility. Make your mind up, dude – are you querying or...

19 April 2016 7 min read

Register for Simple Talk

Databases

Formatting SQL Code – Part the First

SQL Server Statistics Basics

Incomplete / Complete recovery using RMAN cold backup

Clone, Sweet Clone: Database Provisioning Made Easy?

SSIS in SSDT: The Basics

Defragmentation Can Degrade Query Performance

Dynamic Images in SQL Server Reporting Services

3 Built-In Technologies for Centralizing SQL Server Administration

The PoSh DBA: Accessing SQL Server from PowerShell

Oracle SCN (System Change Number): How It Works

Predictive Analysis Basics

Looking at VIEWs, Close Up

The Enterprise DBA Mindset as a Practical Problem-solving Approach

In-Memory OLTP – Row Structure and Indexes

In-Memory OLTP – Understanding Memory-Optimized Tables

Running Siebel CRM on Non-Standard Versions of Internet Explorer

SQL to UML: Auto-Generate Database Diagrams with PlantUML

Siebel CRM Part 12: Upgrading a Non-Development Database

Siebel CRM Part 11: Performing the Siebel incremental Repository Merge

XQuery for Absolute Beginners: Part 5 – XQuery Update Facility