SQL Server Save Time Managing Multiple Servers With Central Management Servers
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
64 reads
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
64 reads
I find myself using Apply more and more in my queries, aside from the usual reasons I’ve been finding I...
2018-05-14
34 reads
If you’re seeing SSMS hang/lock timeouts when expanding nodes in the object explorer for a database it’s almost definitely caused...
2018-05-13
43 reads
I wanted to document a couple of important tasks you should be doing as part of your SQL Server maintenance/backup...
2018-05-12
42 reads
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
1,889 reads
When working with large amounts of data in ETL jobs it can often can sink a lot of time inserting...
2018-05-10
642 reads
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
371 reads
The Transaction log growing is completely normal however there are situations where a transaction log can get to a state...
2018-05-07
47 reads
Trace Flags are a way to change the behavior of the SQL Server database engine. They are often used for...
2018-05-06
60 reads
For older systems where the move to READ COMMITTED SNAPSHOT (RCSI) might not be an option or you’re running a...
2018-05-05
55 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Dears, Hope this message finds you well We have a log table which is...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers