Archive Every Day
There are challenges with the large scale archiving of data. Steve Jones talks about rethinking this as a daily process rather than a periodic one.
2015-06-09
365 reads
Archiving Data
An Automated Process to Archive Big Tables
Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.
2013-07-10
30,941 reads
Archiving SQL Server Data Using Partitioning
Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.
2012-10-22
3,934 reads
Keep Data Forever
Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.
2011-08-25
179 reads
Archiving
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
2011-06-20
665 reads
Changing the Past
This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.
2011-01-21
114 reads
Deleting old files (with/without archive bit)
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-02 (first published: 2008-12-09)
2,112 reads
How to check SQL Server Agent is running
I have biult an application in VB .Net which creates job schedules in backend.For this SQL Server Agent should be running. How can i check whether SQL Server Agent is running and if not, start SQL Server Agent using code. I'm using MSDE 2000 as backend.Thanks in advancehari
2004-07-21
RE: Exporting to Excel
I have just started working on reporting services,as of now i am able create rdl files and generate report in default format. I have some following queries-- 1)Saving reports in different file formats 2) Adding Custom Reports 3) Printing 4) Automatic Report Scheduling I am looking for urgent help u can reach me through govindpatil1@rediffmail.com […]
2004-06-19
Exporting users from SQL server to AD
We have a database that has a large number of users. We are now going to shift authentication for the application over to AD.How can I export the users AND passwords from the DB into AD?
2004-06-18
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers