A Christmas poem for the DBAs.

SQL Server Data Aggregation for Data with Different Sampling Rates

by Additional Articles

MSSQLTips.com

Aggregate Transform

In the emerging "Internet of Things", there are multitudes of devices collecting data at differing sampling rates. Integrating this data so the data has a common granularity in time is important to not only allow for accurate analysis and mining, but it will also aid in reducing the amount of data to be stored and processed.
In this tip, we will demonstrate how to use the T-SQL AVG function and GROUP BY clause to transform data collected from two devices sampling at 100Hz and 40Hz to one row per second.

Dealing with the Evil of FMTONLY from SSRS

by David Rueter

SQLServerCentral.com

Reporting Services (SSRS)

SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?

Practical PowerShell Unit-Testing: Mock Objects

by Additional Articles

SimpleTalk

Pester allows you to automate the testing of PowerShell scripts. It can test the output of a function as you develop it by validating simple data (scalars) and arrays, and allows you to focus on the one function you want to test by using 'mocking' to fake all the other functions and Cmdlets.

The Big Database Freeze

by Additional Articles

Redgate

Verify

When a hospital’s mission-critical database fails at Christmas, disaster for the hospital – and its hapless DBA – seems certain. With less than an hour to spare before catastrophe, can the DBA Team save the day? This is a fictionalized true story.

Kitchen Culture

by Andy Warren

SQLServerCentral.com

Editorial

Today Andy Warren talks about an employee work item that many of you might not be tasked with.

Linked lists

by Andreas Bartels

SQLServerCentral.com

T-SQL

Learn how you can achieve better performance with linked list instead of a numbering column.

What counts for a DBA: Responsibility

by drsql@hotmail.com

SQLServerCentral.com

Editorial

Whose fault is it if a database is hacked and its contents appear on a hacker’s site? Louis Davidson suggests that, regardless of limitations, the DBA always bears some responsibility.

Using the MERGE Statement to Perform an UPSERT

by Additional Articles

Database Journal

MERGE

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.