Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
10,325 reads
2019-12-05
933 reads
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,648 reads
2019-09-05
613 reads
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
364 reads
2019-08-01
988 reads
2019-07-25
713 reads
2019-07-01
845 reads
2019-06-17
831 reads
If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
The...
2019-05-17
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers