Tracking Down tempdb usage
Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues. Luckily SQL...
2018-08-08
9,861 reads
Blog Posts
Why you should not use SELECT *
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...
2018-08-08
470 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
421 reads
Considerations for Using Layout Images in Power BI
Using layout images in Power BI has become a popular design trend. When I say layout images, I’m referring to...
2018-08-07 (first published: 2018-07-28)
2,113 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
7 reads
Displaying Long Values in SSMS
Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...
2018-08-07
377 reads
Displaying Long Values in SSMS
Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
20 reads
Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of...
2018-08-07
18 reads
Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like...
2018-08-07
1,183 reads
2018-08-07
32 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers