2025-04-30
432 reads
Backups
“But I don’t need to back up that database.”
Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.
2018-05-04
5,663 reads
Backup File Inventory
Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.
2016-01-25
2,487 reads
Generic SQL backup with Azure support
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
378 reads
Backup Growth Trend Check
-- Backup Growth Trend Check To Understand how much disk space you need in future
2019-05-03 (first published: 2015-06-02)
1,276 reads
2015-02-19
9,649 reads
2016-02-05 (first published: 2014-05-15)
3,282 reads
2014-05-30 (first published: 2014-05-05)
1,449 reads
Backup to the Cloud: The Silver Lining
Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.
2013-09-16
2,399 reads
2013-03-26 (first published: 2013-03-15)
787 reads
Blogs
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
Forums
Email change does not work
I changed my email address in Edit Profile page, but it has no effect...
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
Question of the Day
Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers