A Fine Slice Of SQL Server
David Lindelöf asks a question:
I sometimes use this fun interview question for aspiring data scientists:
How are p-values distributed assuming the null hypothesis is true?
Read on for four incorrect answers, followed by the actual answer. I actually got the answer right, but in the sloppiest and laziest way. But hey, it was still the right answer. H/T R-Bloggers.
Leave a CommentAdam Bertram has a series on creating Powershell modules:
In this guide, we’ll create a PowerShell module for gathering computer hardware information. This module will help system administrators collect and report on memory, storage, and processor details across multiple systems.
Our module will feature:
- Functions to gather specific hardware information
- Remote system support using PowerShell sessions
- Standardized output format for consistent reporting
Click through for the article.
Leave a CommentIt’s easy to do with this query. That’s all I have to say on this topic for now.
Click through for the query, which includes examples of concatenation, size with units (e.g., KB, MB, GB), and more.
Leave a CommentKoen Verbeeck takes a peek at what’s coming in SQL Server 2025:
We have data coming into our database from a REST API endpoint. The data is formatted as JSON documents. Is there an efficient way to handle JSON data within the SQL Server ecosystem? In this article, we look at the new JSON data types for SQL Server.
The end result is not particularly clear-cut here: reads slightly faster, writes considerably slower. There aren’t any indexes on the data type at this time, so no opportunity for improvement there.
Leave a Comment