When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
BBQ and SQL Server. Come to a free day of training in Kansas City on Aug 4.
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
Today Steve Jones notes that security is improving at many web sites. It's not great, but it's improving. That's a good sign, or is it?
A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
Baton Rouge, LA. LSU. Free Training. Come visit, learn a few things, and enjoy meeting other SQL Server pros.
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
This Friday Steve Jones talks performance reviews. The system in place at Microsoft is a tough one, which allows some to thrive, and some not to. Is it one you'd like to have in place?
Arshad Ali shows you how to create standard/custom report templates in SQL Server Reporting Services (SSRS), to ensure consistency throughout the organization in both the look and feel of reports.
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
WA:0821-4447-7715 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
WhatsApp:08218200205 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers