T-SQL Tuesday #92–Hard Lessons
A quick post, written last week as I’m relaxing in the mountains.
This month the topic is lessons learned the hard...
2017-07-11
496 reads
Save and save often
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...
2017-07-11
441 reads
SQL Server Rookie Mistakes
A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...
2017-07-20 (first published: 2017-07-11)
2,562 reads
Power BI Custom Visuals Class (Module 59 – Drilldown Cartogram)
In this module you will learn how to use the Drilldown Cartogram Custom Visual. The Drilldown Cartogram is a map...
2017-07-18 (first published: 2017-07-11)
2,019 reads
T-SQL Tuesday #92: Lessons Learned the Hard Way
This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about:
For this month, I want you...
2017-07-11
17 reads
SQL Server On Containers
On July 12th 6.30 PM PST, I will be presenting “SQL Implementations On Containers” @ at San Francisco data platform user...
2017-07-10
469 reads
Impact on Indexes When Mixing VARCHAR and NVARCHAR Types
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
5,246 reads
Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
6 reads
Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing...
2017-07-10
361 reads
How to analyze SQL Server database performance using T-SQL
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
467 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers