Daily Coping 11 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-11
13 reads
Blog Posts
How Does The CHOOSE Command Affect Performance?
Questions absolutely drive my blog content and I really liked this one: how does the T-SQL CHOOSE command affect performance. On the face of it, I honestly don’t think...
2020-05-11 (first published: 2020-04-27)
635 reads
Learn TSQL for free online – starting today
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t...
2020-05-11
70 reads
SQLpassion Online Training about Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-05-11
6 reads
The Bite-Sized Redgate Summit comes back this week
This week we have another edition of the Redgate Summit taking place on May 13, 14, and 15. We have different times each day to cover the world. The...
2020-05-11
7 reads
T-SQL Tuesday Live – 12 May 2020
Once again, I’ll be live tomorrow, ready to just chat, shoot the breeze, answer tech questions, anything. No agenda, but I’m on for an hour. If you’re bored, struggling,...
2020-05-11
9 reads
Daily Coping 8 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-08
11 reads
Dropping a Database Now–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I find myself doing...
2020-05-08 (first published: 2020-04-27)
281 reads
TSQL for Beginners–#RGCommunityCircle
As a part of the Redgate Community Circle, giving back in this strange time, each of the advocates for Redgate is teaching a free course. We’re doing this live...
2020-05-08
140 reads
2020-05-07T22:54:34+00:00
Kept getting an error Incorrect syntax near the keyword 'read' when running the some updated PowerShell 7 in lambda with the dotnet3.1 sdk. Was troubleshooting loading types thinking I...
2020-05-07
6 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers