Unlock Your Notion Data with SQL
If your Notion workspace feels more like a data graveyard than a command center, you're not alone. I’ll show you how to connect SQL to your Notion setup so...
2025-08-28
168 reads
If your Notion workspace feels more like a data graveyard than a command center, you're not alone. I’ll show you how to connect SQL to your Notion setup so...
2025-08-28
168 reads
Let's build a real data dashboard. This guide will walk you through the entire process using free tools like BigQuery and Looker Studio, even if you’re just getting your...
2025-08-22 (first published: 2025-08-04)
1,252 reads
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
162 reads
They run, they return data. So what? Some SQL queries just waste your time and resources. Here’s what to stop writing – and the much smarter alternatives. Sure, your...
2025-05-31
229 reads
Wondering which database to tackle first? I’ve got the lowdown on the top free choices for anyone new to SQL, and I’ll tell you exactly why they’re stellar for...
2025-05-28
1,052 reads
Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost you. Good news: an SQL-powered product inventory dashboard puts you firmly in control of stock...
2025-05-25
270 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're in the right place. I’ve pulled together a list of the absolute best free SQL...
2025-05-24 (first published: 2025-05-23)
1,149 reads
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...
2025-05-28 (first published: 2025-05-14)
627 reads
Want to blend your love of marketing with the power of data? Becoming a marketing analyst is the way to go. This job is all about measuring how well campaigns actually work, understanding...
2025-04-02 (first published: 2025-03-18)
333 reads
If you're a data analyst drowning in Excel, you know the pain. Endless filtering, formula nightmares, and the dreaded "file not responding" message. Excel's great for small stuff, but...
2025-03-17
389 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers