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
103 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,011 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
2,827 reads
Big Data Downsides
Too much data, especially for some data analysis isn't good for diversity of any product domain.
2023-04-12
144 reads
2022-03-25
447 reads
2022-03-11
428 reads
2022-02-25
440 reads
Machine Learning and Data Analysis Bias Challenges
How do you decide what data is important when doing machine learning?
2021-11-13
230 reads
Enhancing Client Experiences with Data and Analysis
Data can enhance the experience our client's have with software.
2021-09-03
107 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
123 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers