Additional Articles

Database Configuration Management for SQL Server

by Additional Articles

SimpleTalk

Configuration Files

It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.

2014-11-12

10,784 reads

Set up a Memory Quota for SQL Server Memory Optimized Databases

by Additional Articles

MSSQLTips.com

Memory Quota

You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.

2014-11-11

7,759 reads

Acceptance Testing with FitNesse: Database Fixtures, Project Overview

by Additional Articles

SimpleTalk

Testing

There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.

2014-11-10

5,527 reads

Backup and Restore Strategies in SQL Server – Part 2

by Additional Articles

Database Journal

Backup and restore

In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.

2014-11-07

10,468 reads

Stop Relying on Cloud File Stores as a Backup Strategy

by Additional Articles

SimpleTalk

Backup

There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.

2014-11-06

9,934 reads

Getting Data Into and Out of PowerShell Objects

by Additional Articles

SimpleTalk

PowerShell

You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.

2014-11-04

9,369 reads

Format Durations in SQL Server Analysis Services

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.

2014-11-03

7,093 reads

Does NoSQL = NoDBA?

by Additional Articles

SimpleTalk

There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What’s happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt enters the world of NoSQL to investigate.

2014-10-30

11,568 reads

Data Is Crazier than You Think

by Additional Articles

SimpleTalk

As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless.

2014-10-28

8,058 reads

SQL Monitor Custom Metric: Average I/O Stalls

by Additional Articles

Redgate

SQL Monitor

This metric is a great general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.

2014-10-28

7,321 reads

All authors

Additional Articles

Database Configuration Management for SQL Server

Set up a Memory Quota for SQL Server Memory Optimized Databases

Acceptance Testing with FitNesse: Database Fixtures, Project Overview

Backup and Restore Strategies in SQL Server – Part 2

Stop Relying on Cloud File Stores as a Backup Strategy

Getting Data Into and Out of PowerShell Objects

Format Durations in SQL Server Analysis Services

Does NoSQL = NoDBA?

Data Is Crazier than You Think

SQL Monitor Custom Metric: Average I/O Stalls

Blogs

How Fabric Mirroring Transformed with SQL Server 2025

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility