Quarterly Goals
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
533 reads
Blog Posts
Reblog: April 4 to April 10
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-04-11
364 reads
Simple And Amusing Question Of The Day
I was working on a script today to check the range of some values and trying to take the time...
2014-04-11
584 reads
Speaker of the Month, April 2014
I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at...
2014-04-11 (first published: 2014-04-04)
1,205 reads
T-SQL Tuesday #53: Why so serious
Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person....
2014-04-11 (first published: 2014-04-08)
1,632 reads
Why So Serious? – #TSQL2sDAY #53
As a child/pre-teen/teenager/young adult, OK, most of my life, I’ve been labeled as “serious” or “grumpy”. Maybe I deserve it...
2014-04-11 (first published: 2014-04-08)
1,499 reads
Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
700 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,009 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
713 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
550 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers