My SQL Server Travels in 2018
It’s the end of the year, and I’m looking back at the events and travels I’ve had this year. I...
2018-12-27
290 reads
Blog Posts
Seeing WriteLog wait type on your SQL Server?
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,589 reads
SQL server change single user mode or backup or recovery model of all database sql script
AdvertisementsFollowing is the DBA script which generally used for most cases the action needed for all the databases like migration,...
2018-12-27
261 reads
SQL server change single user mode or backup or recovery model of all database sql script
Following is the DBA script which generally used...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2018-12-27
5 reads
Watch: The Best of 2018 and Predictions for 2019 (video)
I recently got together with fellow Microsoft Data Platform MVPs Steve Jones, Kathi Kellenberger and Grant Fritchey to discuss the highlights of innovations we’ve seen in 2018 and predictions...
2018-12-27
3 reads
Adding Microsoft MVP Contributions with PowerShell – Lessons Learned using the MVP API
One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem,...
2018-12-26
6 reads
Giving thanks in 2018
It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is...
2018-12-26
193 reads
Managing Logins and Users Across An Availability Group
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,256 reads
Move The Location Map Pin in Meetup
Just received an email from Meetup with some news on enhancements and one of them was interesting to me – the...
2018-12-26
244 reads
Some pictures from 2017’s events
The 2018 year is coming to the end. It’s a good time to review the passing year and… check whether...
2018-12-26
192 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