Copy Only Backup for SQL 2005 and SQL 2008
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
2009-06-30
3,948 reads
Backup and restore
Script to find latest backups for all databases
If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.
2009-07-01 (first published: 2009-06-19)
2,359 reads
Use Backup/Restore to Minimize Upgrade Downtimes
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,565 reads
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
2009-06-04
16,216 reads
How to find out how long a SQL Server backup took
Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.
2009-05-22
3,711 reads
I Need a Backup and I Need It Now
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...
2009-04-29
4,263 reads
Operating system Error 112
The error message pops up when you try to restore the database to a different server or to a desktop or to a FAT32 file system. Learn a couple of ways for dealing with this error.
2009-04-17
5,311 reads
When was the last time your SQL Server database was restored
Often times we are asked the question "when was the last time my database was restored, and where was it restored from?" In this tip, we will look at some of the system tables that capture restore history information and how you can query these system tables to answer this question.
2009-04-16
2,899 reads
2013-04-05 (first published: 2009-03-27)
4,556 reads
2009-02-26
3,590 reads
Blogs
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
Forums
BCA KCP Cimahi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Raya Cimahi No.533, Karangmekar, Kec. Cimahi Tengah, Kota Cimahi, Jawa Barat 40523
The New Software Team
Comments posted to this topic are about the item The New Software Team
Database Mail in SQL Server 2022
Comments posted to this topic are about the item Database Mail in SQL Server...
Question of the Day
The string_agg function
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers