The Danger of Sharing Data
When a company assembles a lot of data to draw conclusions, that's great. However, when that one company sells data to a number of competitors, that can be a problem.
2023-02-22
67 reads
Big Data
Data lakes take on big data
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
2022-02-04
Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services
In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS
2021-12-08
Do You Have Big Data?
Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]
2020-09-09
137 reads
Data Orchestration
Steve talks data virtualization in the age of growing data sets and larger workloads
2020-02-27
261 reads
SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,013 reads
Reduce costs by adding a data lake to your cloud data warehouse
When it comes to data warehouse modernization, we’re big fans of moving to the cloud. ...
2019-04-17
Top big data analytics trends hold true well into 2019
The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much...
2019-04-16
Databricks Dashboards: Data Exploration With Salary Classification
For many companies, the initial attraction to Azure Databricks is the platform’s ability to process big data in a fast, secure, and collaborative environment. However, another highly advantageous feature is the Databricks dashboard.
2019-03-30
Generate Big Datasets with Hive in HDInsight
This post describes how to generate big datasets with Hive in HDInsight, specifically TPC-DS benchmarking datasets. There are many tools for generating sample data, and this one is particularly nice due to its familiarity and ability to generate massive...
2019-03-30
Blogs
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
Forums
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
Ask SSC