Overview of File-group(s) and Piecemeal database restore operations in SQL Server
So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series,...
2018-06-22
746 reads
So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series,...
2018-06-22
746 reads
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the...
2018-06-20
1,398 reads
In the previous articles, we discussed several ways of taking backup and testing the restore process to ensure the integrity...
2018-06-14
1,019 reads
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-06-12
253 reads
“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...
2018-06-05
251 reads
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,083 reads
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
442 reads
This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob...
2018-05-29
383 reads
In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most...
2018-05-18
352 reads
Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance...
2018-05-17 (first published: 2018-05-08)
4,558 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers