Query to Display Recent Data and TLog File Autogrowth and Autoshrink Events. Here is a query to read the default trace on your SQL instance and produce a report of recent Data and TLog file autogrowth and autoshrink events that have occurred for that SQL instance. The query works for SQL 2005 and above, and there are no edits required. To easily copy the code, hover your mouse over the below section and click the copy to clipboard button in the tool bar that appears at the top rig.

A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. Recently I was building a new database infrastructure on SQL Server 2012 to run a third party application called Relativity.

SQL Server FCI Virtual Lab. SQL Server Virtual Lab Section 1. SQL Server Virtual Lab Section 2. SQL Server Virtual Lab Section 3. I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean two podcasts recorded at one event! Last yea.

Resolutions found in SQL Server, Oracle, and other support issues. Once in while I am asked to troubleshoot a SQL Server database where my only connection is though a linked server. How FTP Multiple Files from the Command Line. 3004-303 There have been too many unsuccessful login attempts; please see the system administrator. This blog is about upgrading SQL Se.

Data Analysis and Business Intelligence Solutions for SharePoint, SQL Server and MS Excel.