Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this info
We have quite a large number of databases and user connections to our SQL Server and we suspect that one application does not close connections properly. We need an automated way to collect the number of connections and the application that is creating th
SQL Server 2008 introduced Master Data Services (MDS) as Master Data Management (MDM) platform for managing enterprise master data centrally in a consistent, clean and up-to-date manner.
Have you ever wondered how SQL Server logs track transactions and what information SQL Server captures in the transaction log file? In this tip we will take a look at a SQL Server function that you can use to read the transaction log to see what entries
I have a stand-alone instances of SQL Server Analysis Service (SSAS) and SQL Server Reporting Service (SSRS) running in my environment. How can I find what the version and edition of each package as well as the Service Pack installed?
We recently upgraded one of our SQL Server to a newer version. When I took the backup from one of the databases on that server and attempted to restore it to our test restore server (where we verify backups), I received an error. The test server wasn't up