T-SQL Tuesday #185–Being a Video Star
This month we have an interesting invite. Erik Darling is the host, and since he does a lot of video blogs, he’s asking for a video submission for T-SQL...
2025-04-08
17 reads
The Voice of the DBA
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE...
2025-04-25 (first published: 2025-04-07)
506 reads
The Book of Redgate–Being Reasonable
As a part of the Book of Redgate, we have a series of (red, of course) pages with the title “What we believe”. These are our values, as set...
2025-04-18 (first published: 2025-04-04)
419 reads
Comparing My Current Schema with a Backup with SQL Compare
A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part...
2025-04-21 (first published: 2025-03-31)
281 reads
A New Word: Zverism
zverism – n. the wish that people could suspend their civility and indulge in the physical side of each other first, sniffing each other’s hair like dogs, staring unabashedly...
2025-03-28
74 reads
CHOOSE’ing a Beer: #SQLNewBlogger
We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...
2025-04-09 (first published: 2025-03-26)
281 reads
Monday Monitor Tips: Looking Back in Time
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
150 reads
Friday Flyway Tips: State-based deployment with Flyway Teams
I was asked about state-based deployments in Flyway Teams, so I decided to show how this can work with a quick demo. This post walks through the process. I’ve...
2025-04-04 (first published: 2025-03-21)
214 reads
Advice I Like: The Main Thing
The main thing is to keep the main thing the main thing. – from Excellent Advice for Living We can summarize this advice as focus on what’s important. I...
2025-03-21
20 reads
DATEADD Truncates the Number Parameter: #SQLNewBlogger
This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them....
2025-03-19
144 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers