SQL Server DMA – Data Migration Assistant V2.0
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
667 reads
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
667 reads
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
641 reads
I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...
2016-10-26
363 reads
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
465 reads
I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...
2016-10-24 (first published: 2016-10-17)
1,944 reads
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
458 reads
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
472 reads
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
522 reads
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,482 reads
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
439 reads
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...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
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...
Comments posted to this topic are about the item The DBAccountant
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