News

In this article, we are going to learn how to use Nlog to log messages into SQL Server. We are going to see how we can configure an ASP.NET Core Web API project to support NLog and how we can ...
Is there a command line switch used to specify a default DB and logs locations? I can't seem to find anything.<BR><BR>I have installed about 5-6 instances of SQL 2005 so far.
SQL Server, of course, keeps track of everything that affects data in a transaction log, which is periodically rolled over into backup files (at least, if you're being a conscientious DBA it is). But ...
SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.
In the second blog post above, you’ll see there is a SQL Server Agent job ‘DYNPERF_COLLECT_AOS_CONFIG’, which collects the last 14 days of Windows event logs from each of the AOS servers, in addition ...
Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.