Get Your Learn On
There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...
2019-01-21
154 reads
Blog Posts
Memory Grants part 4: The Resource Semaphore
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
1,023 reads
Move database between drives
AdvertisementsSQL server Move user database steps and scripts:
Check you have a free space on the moving drive and make sure...
2019-01-21
241 reads
Move database between drives
SQL server Move user database steps and scripts:...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-01-21
6 reads
MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...
2019-01-21
9 reads
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
208 reads
One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this week it was just my oldest, going on 15....
2019-01-21
9 reads
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,889 reads
Things I Wish I Knew When I Started
Way back in August, Matt Cushing (blog|twitter) was preparing to teach and asked for a list of “what do you wish you’d known when you started” items that he...
2019-01-21
8 reads
What could you achieve with 60% more time?
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
197 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
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
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...
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