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.

The Wish List

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones asks you about your geek Christmas wishes.

What, when and who? Auditing 101 - Part 3

by Roy Ernest

SQLServerCentral.com

Auditing

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.

SQL Server Data Aggregation for Data with Different Sampling Rates

Dealing with the Evil of FMTONLY from SSRS

Practical PowerShell Unit-Testing: Mock Objects

The Big Database Freeze

Kitchen Culture

Linked lists

What counts for a DBA: Responsibility

Using the MERGE Statement to Perform an UPSERT

The Wish List

What, when and who? Auditing 101 - Part 3

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

The Book of Redgate: Taking Breaks

Database AI Agents: The Read-Only Rule

Forums

Liability for AI Errors

Running a Parameter-Sensitive Stored Procedure on a Secondary Replica

Pro SQL Server Internals

Question of the Day

Running SQLCMD II