My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?
2008-04-15
5,915 reads
QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.
2008-04-15
3,278 reads
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-15
39 reads
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-15
35 reads
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-15
42 reads
Register for the 2008 PASS Summit in November today and save! Use our code when you register and attend our opening night reception.
2008-04-14
1,202 reads
Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.
2008-04-14 (first published: 2007-05-10)
8,832 reads
It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances.
2008-04-14
4,246 reads
Part 4 of this series focuses on storing BLOBs on the Windows File System and using Microsoft SQL Server to organize them from a web page.
2008-04-14
3,318 reads
2008-04-14
32 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta Selatan,...
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Call Center Batik Air Yogyakarta dapat di lakukan menghubungi CS resmi Batik Air di...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers