Additional Articles

Creating Dashboards for Mobile Devices with Datazen – Part 1

by Additional Articles

Database Journal

Datazen

With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional costs. In this article series Arshad Ali will demonstrate how you can use Datazen for creating dashboards and KPIs (Key Performance Indicators) for mobile devices easily and quickly.

2015-08-11

5,810 reads

The Evolution of SQL Server BI

by Additional Articles

SimpleTalk

Business Intelligence (BI)

It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Robert Sheldon takes stock with the Simple BI Timeline which explains how BI has evolved over the years.

2015-08-10

4,879 reads

Introduction to SQL Server 2016 Temporal Tables

by Additional Articles

MSSQLTips.com

SQL Server 2016

Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.

2015-08-07

5,485 reads

Microsoft and Database Lifecycle Management (DLM): The DacPac

by Additional Articles

SimpleTalk

Database Lifecycle Management

The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.

2015-08-05

5,584 reads

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

by Additional Articles

Microsoft MSDN

Hyper-V

There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.

2015-08-04

3,841 reads

Change operating modes for SQL Server Database Mirroring

by Additional Articles

MSSQLTips.com

Database Mirroring

SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.

2015-08-03

3,376 reads

SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations

by Additional Articles

SQLCAT

Clustered columnstore index

Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.

2015-07-31

2,990 reads

SQL Server Archive and Data Retention Considerations

by Additional Articles

MSSQLTips.com

data retention

Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.

2015-07-30

2,895 reads

Demystifying Oracle's Clustering Factor

by Additional Articles

Database Journal

One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.

2015-07-29

3,764 reads

The Importance of Maintenance on MSDB

by Additional Articles

SQLPerformance.com

msdb

MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.

2015-07-28

6,714 reads

All authors

Additional Articles

Creating Dashboards for Mobile Devices with Datazen – Part 1

The Evolution of SQL Server BI

Introduction to SQL Server 2016 Temporal Tables

Microsoft and Database Lifecycle Management (DLM): The DacPac

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

Change operating modes for SQL Server Database Mirroring

SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations

SQL Server Archive and Data Retention Considerations

Demystifying Oracle's Clustering Factor

The Importance of Maintenance on MSDB

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener