Databases Archives

Using DAX to retrieve tabular data

Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window...

24 June 2013 17 min read

Gert Poel

Using Subtypes for Booleans

I try to use subtypes as much as I can and after reading the “All Things Oracle” article of Patrick...

21 June 2013 5 min read

Jonathan Allen

Preparing to Upgrade SQL Server: Finding Deprecated Features with DMVs and Extended Events

Preparing for a SQL Server upgrade by identifying deprecated features still in use - querying sys.dm_os_performance_counters for deprecation counters and...

12 June 2013 18 min read

Hugo Kornelis

Painless management of a logging table in SQL Server

Tables that log a record of what happens in an application can get very large, easpecially if they're growing by...

11 June 2013 26 min read

Phil Factor

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough...

06 June 2013 8 min read

Alexander Karmanov

Automating SQL Server Database Deployments: Scripting Details

To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted...

06 June 2013 30 min read

Patrick Barel

Views

Success always occurs in private and failure in full public view. – Unknown When working with views you have several...

05 June 2013 5 min read

Satishbabu Gunukula

Oracle Database Replay for your Workload Test

Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and...

30 May 2013 8 min read

Joe Celko

The SQL of Parts Explosions

Parts explosions present a classic IT problem. How can one calculate such things as weight or cost of assemblies in...

30 May 2013 11 min read

Tools

Michael Sorens in Tools

MySQL Data Compare: The Manual that Time Forgot

MySQL Data Compare can both compare the data in MYSQL databases and also synchronise them. It is handy for a...

28 May 2013 16 min read

Robert Sheldon

Getting Started with the SSAS Tabular Model

SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to...

22 May 2013 16 min read

Andy Brown

Moving Data From Excel to SQL Server – 10 Steps to Follow

SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates...

21 May 2013 15 min read

Grant Fritchey

The DBA Detective: The Case of the Missing Index

When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect...

15 May 2013 12 min read

Allen White

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell....

03 May 2013 15 min read

Tools

Michael Sorens in Tools

MySQL Compare: The Manual That Time Forgot, Part 1

Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you...

03 May 2013 14 min read

Aman Sharma

RAC One Node

In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are...

25 April 2013 20 min read

Holger Schmeling

Developing a Report Definition Customization Extension for Multi-Language Reports

When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or...

19 April 2013 31 min read

Seth Delconte

Introduction to SQL Server Filtered Indexes

SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they...

19 April 2013 13 min read

Randolf Geist

Analyzing and Troubleshooting Oracle Parallel Execution

Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf)...

17 April 2013 1 min read

Grant Fritchey

Custom Metrics for Monitoring Database Mirroring

SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure...

16 April 2013 7 min read