Analyzing Breached Data
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
2024-08-17
105 reads
Data Analysis
How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
4,840 reads
Using Power BI to Analyze My Travels
As a data professional, I have some fun with data in my life. I like numbers, and I like tracking things. I've written posts about my year in numbers, and recently noted the states I've visited. Like many of you, I've sometimes used this data to practice a skill, maybe learn to ETL or query […]
2023-07-14
3,268 reads
Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
151 reads
2022-03-25
451 reads
2022-03-11
433 reads
2022-02-25
443 reads
Machine Learning and Data Analysis Bias Challenges
How do you decide what data is important when doing machine learning?
2021-11-13
233 reads
Enhancing Client Experiences with Data and Analysis
Data can enhance the experience our client's have with software.
2021-09-03
111 reads
Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
2020-08-25
126 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers