2014-12-24
96 reads
Articles
SQL Server Data Aggregation for Data with Different Sampling Rates
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.
2014-12-24
7,922 reads
Dealing with the Evil of FMTONLY from SSRS
SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?
2014-12-23
10,560 reads
Practical PowerShell Unit-Testing: Mock Objects
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.
2014-12-23
7,027 reads
The Big Database Freeze
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.
2014-12-23 (first published: 2014-12-04)
17,000 reads
Linked lists
Learn how you can achieve better performance with linked list instead of a numbering column.
2014-12-22
9,147 reads
Using the MERGE Statement to Perform an UPSERT
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.
2014-12-22
13,060 reads
What, when and who? Auditing 101 - Part 3
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.
2014-12-19 (first published: 2012-05-31)
15,142 reads
SQL Server Analysis Services Attribute Relationships
This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.
2014-12-19
7,646 reads
GUIDs GUIDs everywhere, but how is my data unique?
After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.
2014-12-18
9,969 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers